Opening file through UNC path changes my links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mchambers_autocam - 15 Jun 2005 22:32 GMT

I have a workbook with many named cells. A second workbook has links
back to the first workbook. When I open the second workbook via an UNC
path, rather than a named drive letter, the link changes to a different
named cell of the first workbook.

Signature

mchambers_autocam

Reply to this Message

Bill Manville - 17 Jun 2005 08:35 GMT

If it is indeed doing what you describe then you would seem to have
found a bug in Excel, but it is strange that no-one else has previously
reported such a problem.

What version of Excel are you using?
Do you have the latest Service Pack?
What was the formula shown as before you opened the source workbook via
the UNC name?
What was it showing afterwards?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message