Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi There,
In my workbook I have some absolute links like: ='S:\finplan\2005\BR9 2005\snackfood\[account profitability ..xls]BR9'!B$100 This link work perfect! I noticed though that sometimes, for some mystic reason, the link changes into: ='E:\finplan\2005\BR9 2005\snackfood\[account profitability ..xls]BR9'!B$100 (Without "updata links", nothing happens of course ... but updating the links causes: # REFs) all over ... I cannot simulate this bizar change now; but I am just sure it has happened, as this change has happened to plenty of my files... Any reason why Excel changes this drive mapping...? I hope excel.misc is the right place to ask, Best Regards Sige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
toolsoptions cannot change file locations | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
I need to change the path of the linked files - thousands of them. | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
change directory for refresh data | Excel Discussion (Misc queries) |