SOLVED

Linking to a Worksheet within a Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1878757%22%20slang%3D%22en-US%22%3ELinking%20to%20a%20Worksheet%20within%20a%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1878757%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20link%20a%20cell%20in%20one%20Worksheet%20(the%20%22Destination%20Worksheet%22)%20to%20another%20cell%20in%20another%20Worksheet%20(the%20%22Linked%20Worksheet%22)%2C%20sometimes%20the%20formula%20within%20the%20Destination%20Worksheet%20refers%20to%20the%20Linked%20Worksheet%20with%20a%20quotation%20mark%20before%20and%20after%20the%20name%20of%20the%20Linked%20Worksheet%20and%20sometimes%20it%20does%20not.%20Is%20there%20a%20reason%20for%20this%3F%20I%20ask%20because%20there%20are%20plenty%20of%20times%20in%20which%20I%20will%20just%20type%20the%20link%20myself%20rather%20than%20point%20and%20click.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1878757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1879182%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20to%20a%20Worksheet%20within%20a%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1879182%22%20slang%3D%22en-US%22%3EIf%20the%20sheet%20name%20has%20spaces%20in%20it%2C%20then%20there%20needs%20to%20be%20quote%20marks.%3C%2FLINGO-BODY%3E
New Contributor

When I link a cell in one Worksheet (the "Destination Worksheet") to another cell in another Worksheet (the "Linked Worksheet"), sometimes the formula within the Destination Worksheet refers to the Linked Worksheet with a quotation mark before and after the name of the Linked Worksheet and sometimes it does not. Is there a reason for this? I ask because there are plenty of times in which I will just type the link myself rather than point and click. Thanks in advance.

2 Replies
Best Response confirmed by dstedham (New Contributor)
Solution
If the sheet name has spaces in it, then there needs to be quote marks.

@JMB17  Thank you so much for such a quick response and you are spot on with why it has been occurring!