Linked Table Problem 1

[bernie10]

Hello everyone,
I am having some trouble with a linked table. The linked table had been pointing to a file, professional_07.xls, saved in "My Documents" and it had been working fine. But I just recently updated the file (keeping the same file name) and now I'm getting an error.

The error states: "'professional_07$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long." When I go to the linked table manager it shows the table at \\MyDirectoryPath\professional_07.xls\professional_07$

I am not sure where the "professional_07$" part came from. Does anybody know what this means? Also is there a way I can edit this to fix it? Whenever I try to change what the linked table is pointing too I get the same error.

Thanks in advance for any suggestions.

Collen

 

[traingamer]

'professional_07' is the worksheet within the excel file that you are linking.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[traingamer]

So I'm guessing that you changed the worksheet name, but not the file name.

 

[bernie10]

Yes, exactly, thanks. Just for future reference is there a way to change the name of the table/sheet which the linked table points too? (I know how to change the location, but not the table name/sheet in the linked table manager)

Collen

 

[traingamer]

Not that I'm aware of, short of deleting and re-linking (although someone else may know a way).

The linked table manager seem to want it to keep the same worksheet name.


Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Welshbird]

Can you link to a named range within the Excel workbook instead? I haven't tried, but it strikes me it might just work.

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]