Revisions to How do I link a cell in Google Spreadsheets to a cell in another document?

untangled tricky verbiage

Source Link

edit approved Mar 26, 2013 at 20:40

1

FYI if you want to reference another sheet within that other spreadsheet, using the ' when the sheet name has spaces doesn't work, I found out that you need to just leave them out, using the example aboveshould NOT be re-quoted:

use

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")

instead of

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")

FYI if you want to reference another sheet within that other spreadsheet, using the ' when the sheet name has spaces doesn't work, I found out that you need to just leave them out, using the example above:

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")

instead of

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")

FYI if you want to reference another sheet within that other spreadsheet, the sheet name should NOT be re-quoted:

use

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")

instead of

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")

formattnig

Source Link

edit approved May 3, 2011 at 14:22

Uticensis

103
3

FYI if you want to reference another sheet within that other spreadsheet, using the '' when the sheet name has spaces doesn't work, I found out that you need to just leave them out, using the example above:

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")

instead of

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")

FYI if you want to reference another sheet within that other spreadsheet, using the ' when the sheet name has spaces doesn't work, I found out that you need to just leave them out, using the example above:

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")

instead of

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")

FYI if you want to reference another sheet within that other spreadsheet, using the ' when the sheet name has spaces doesn't work, I found out that you need to just leave them out, using the example above:

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")

instead of

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")

Source Link

created May 3, 2011 at 7:25

0blivious

369
3
2

FYI if you want to reference another sheet within that other spreadsheet, using the ' when the sheet name has spaces doesn't work, I found out that you need to just leave them out, using the example above:

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","Sheet Name!A1:A10")

instead of

=importRange("tgR2P4UTz_KT0Lc270Ijb_A","'Sheet Name'!A1:A10")

Stack Exchange Network

Return to Answer