View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links

2003

Even though I select "Do not Update" every time I Open certain files, the Sheet-to-Sheet references
within the workbook, now show the links with the path add to the sheet reference.

Of course, this causes Memory and File size issues.

Also, how can one remove the path so as to not cause reference problems?

I would prefer a VBA-type answer because there are thousands of references to remove the path
information.


Thanks,

EagleOne