Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Opening file through UNC path changes my links
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.
|
#2
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening excel files with links to other data sources | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with a Macro | Excel Discussion (Misc queries) | |||
File asks to update when no links were created | Links and Linking in Excel |