1
00:00:00,080 --> 00:00:02,123
You enter IMPORTRANGE and see #REF!.

2
00:00:02,123 --> 00:00:05,870
That code alone does not tell you whether the destination needs

3
00:00:05,870 --> 00:00:09,956
permission, the source cannot be opened, or the range string is wrong.

4
00:00:09,956 --> 00:00:13,702
In our fictional example, four order rows should arrive from one

5
00:00:13,702 --> 00:00:15,405
native Google Sheet into another.

6
00:00:15,405 --> 00:00:19,492
We will read the cell's exact message, take the matching action,

7
00:00:19,492 --> 00:00:23,919
and compare the final five-by-three block with an independent answer check.

8
00:00:24,519 --> 00:00:28,773
Download the four-row fictional CSV, import it into a new Google

9
00:00:28,773 --> 00:00:31,254
Sheets file, and rename the tab Orders.

10
00:00:31,254 --> 00:00:35,152
This native file is the source; create a second blank Google

11
00:00:35,152 --> 00:00:36,925
Sheets file as the destination.

12
00:00:36,925 --> 00:00:40,823
Copy the source spreadsheet's URL, not the CSV download path.

13
00:00:40,823 --> 00:00:45,077
If you are starting from an Excel file in Drive, Google's

14
00:00:45,077 --> 00:00:49,330
conversion help explains Save as Google Sheets before using native Sheets features.

15
00:00:49,930 --> 00:00:53,810
In destination A one, paste the formula shown in the guide,

16
00:00:53,810 --> 00:00:57,338
replacing SOURCE_URL with your new source Sheet's real URL.

17
00:00:57,338 --> 00:01:01,571
The quoted range string is Orders exclamation A one colon C five.

18
00:01:01,571 --> 00:01:05,804
Google's IMPORTRANGE syntax takes a spreadsheet URL and a range string;

19
00:01:05,804 --> 00:01:08,626
a tab name must match your source exactly.

20
00:01:08,626 --> 00:01:12,506
Keep this first test small and avoid wrapping the formula in

21
00:01:12,506 --> 00:01:14,975
IFERROR, which could hide the permission prompt.

22
00:01:15,575 --> 00:01:18,661
For a source you can open, the first #REF!

23
00:01:18,661 --> 00:01:22,775
may say You need to connect these sheets and offer Allow access.

24
00:01:22,775 --> 00:01:25,860
Google documents that this grants the destination spreadsheet permission

25
00:01:25,860 --> 00:01:27,574
to pull from the source.

26
00:01:27,574 --> 00:01:31,688
Click only for your fictional practice source, then wait for the import.

27
00:01:31,688 --> 00:01:35,459
In real work, review who can edit the destination before granting

28
00:01:35,459 --> 00:01:37,516
a connection to a sensitive source.

29
00:01:38,116 --> 00:01:41,915
If the message says you do not have permission to access

30
00:01:41,915 --> 00:01:46,059
that spreadsheet, try opening the source URL in the same Google account.

31
00:01:46,059 --> 00:01:49,512
Google says to request access from its owner if needed.

32
00:01:49,512 --> 00:01:53,311
Check whether the source is an uploaded XLSX instead of a

33
00:01:53,311 --> 00:01:57,110
native Google Sheet; Google's conversion workflow creates a new Sheet

34
00:01:57,110 --> 00:01:58,837
file with a new URL.

35
00:01:58,837 --> 00:02:02,635
Do not repeatedly click Allow access when that button is absent.

36
00:02:03,235 --> 00:02:07,228
When the connection succeeds, destination A one through C five should

37
00:02:07,228 --> 00:02:10,132
show the three headers and four fictional orders.

38
00:02:10,132 --> 00:02:14,488
The unit values are twelve, eight, three, and fifteen, totaling thirty-eight.

39
00:02:14,488 --> 00:02:18,480
Compare the order IDs and statuses with the independent answer check;

40
00:02:18,480 --> 00:02:22,836
a successful connection alone does not prove the right range was imported.

41
00:02:22,836 --> 00:02:26,829
If the tab was renamed, update the quoted range string to

42
00:02:26,829 --> 00:02:28,281
the new exact name.

43
00:02:28,881 --> 00:02:33,240
Use the error detail to choose the next step: grant first-time

44
00:02:33,240 --> 00:02:37,237
access if you own both files, request permission from the source

45
00:02:37,237 --> 00:02:41,233
owner, convert an uploaded Excel source to a native Sheet, or

46
00:02:41,233 --> 00:02:43,050
correct the tab and range.

47
00:02:43,050 --> 00:02:48,500
For this fictional exercise, the final A1:C5 contains four orders totaling thirty-eight units.

48
00:02:48,500 --> 00:02:52,859
Record the source URL and exact range to check the import later.