View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] barbetta3141@yahoo.com is offline
external usenet poster
 
Posts: 20
Default Copying Hyperlinks that automatically update

try to use menu item Edit | Find and Replace to replace

[c:\My Documents\OtherExcelFile.xls]SheetX!

with

Sheet1!