If you do not see the Allow access button, try authorizing the importrange() formula through a temporary formula cell. To get the imported data back in the new spreadsheet, delete the data that you tried to add. Third, if both importrange() parameters pass the test, confirm that you have clicked the Allow access button that shows when you hover over the importrange() formula cell. If you try to change a value in the new spreadsheet, you'll find that an error message will appear. The data synchronization only updates in one direction - from the old spreadsheet to the new one. When using importrange, how do you add permissions from another sheet It is perpetually loading. ![]() If you own a Windows PC, press Ctrl + Shift + Delete to open the menu for clearing browsing data.
0 Comments
Leave a Reply. |