View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] guido@bvunet.net is offline
external usenet poster
 
Posts: 2
Default In Excel linked values turn to #REF! after clicking don't update

I am getting an xl attachment that uses linked sheets. At computers
that have Office 2000, I can open it without a problem when I choose
don't update. At my new laptop that has Office 2003, the cell turn to
#REF!. Is there an easier fix than create a copy of a spreadsheet and
insert the =substitute function or creatin a macro? I do not have
access to the original files. Your help is appreciated. Thanks,
-Guido