#NAME? Error When Linking

dwhickm · Post by **dwhickm** » Sun May 18, 2008 7:36 pm

What I did: in one sheet entered "=", then selected another spreadsheet cell and pressed "Enter".

What happened: Got a #NAME? error. When selecting the cell, the correct path appears. Sometimes it works ok. ???

edit this topic's initial post · Post by **Villeroy** » Sun May 18, 2008 8:04 pm

This may happen when the path has quotes (C:\John's Directory\...).

dwhickm · Post by **dwhickm** » Mon May 19, 2008 6:24 pm

Thanks for the reply. In this case, there is no apostrophe in the path to the cell. I noticed I didn't mention that the cells involved are in different workbooks. The path references the cell correctly but displays the #NAME? error. This condition is repeatable and consistent when trying to link any 2 cells between these 2 workbooks.

edit this topic's initial post · Post by **Villeroy** » Mon May 19, 2008 7:05 pm

Open both files
In the target file (the one which imports data) start a formula with =
While in edit mode switch to the other window showing the source file and select the cell/range you want to import into the target file.
Hit the enter key.
If this does not work for some reason, show us the resulting formula together with the error (e.g. #NAME)
You find more details on this type of link in the first chapter of my [Tutorial] External Links In Calc

dwhickm · Post by **dwhickm** » Wed May 21, 2008 3:56 am

Thanks - I'll check this out and respond in a few days.
Dan

dwhickm · Post by **dwhickm** » Sat May 24, 2008 6:32 pm

Hi, I'm back. Thanks again for your help. I tried the process you supplied, which is identical to the process I have been using. This process works fine in all workbooks I have tried except the two in question. The resulting formula is:

='file:///c:/documents%20and%20settings/danny/my%20documents/financial/investment%20data.ods'#'acct smy'.b4

The cell into which the link was attempted displays:

#NAME?

The actual content of the cell being referenced ( ... 'acct smy'.b4) is the number 449,803

edit this topic's initial post · Post by **Villeroy** » Sat May 24, 2008 7:02 pm

Seems to be a bug. I can reproduce the error when I create a link with spaces in the sheet name by using the point-and-click method. If you would rename the sheet in the source file from 'acct smy'.b4 to acct_smy.b4 the problem should disappear. But you may prefer to simply edit the formula. Put a dollar sign before the quoted sheet name ='file:///.../file.ods'#$'acct smy'.b4
All subsequent references to the same extenal sheet will work right away. It's just a "first-time-hickup".

dwhickm · Post by **dwhickm** » Sun May 25, 2008 8:58 pm

Again, thanks for all your help. Removing the space from the worksheet name resolves the problem.

#NAME? Error When Linking

#NAME? Error When Linking

Re: #NAME? Error When Linking

Re: #NAME? Error When Linking

Re: #NAME? Error When Linking

Re: #NAME? Error When Linking

Re: #NAME? Error When Linking

Re: #NAME? Error When Linking

Re: #NAME? Error When Linking