View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sige
 
Posts: n/a
Default Absolute Path change ...

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