Update links

[totomaster]

Hi

I have one excel files with references to anotehr file, but on some pc I
don't have the source. I have to see the data on those pc's.

Here is the situation. When I double click on the file Excel gives me the
choice to update or not. When I have this message I can see the data in
cells, but as soon as I click don't update (because I don't have access to
trhe source) the values are replaced by #N/A.

This situations occured only on Excel 2003 and Excel XP not on Excel 2000,
so where is the options that 200 has and not the others

thank you

 

[Dave Peterson]

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]

Maybe it'll work ok for you.

 

[totomaster]

Thanks I have tried the twek and its working fine for me