foulty value if no update links to other woorkbooks

  • Thread starter Thread starter danlar56
  • Start date Start date
D

danlar56

Hallo ,

I have following problem in Excel for XP ( Ok in Excel 97 and 2k).

I recive an workbook with links to an other workbook. I don't want t
update the links to the other workbook, insted I select to not updat
the links. Then I don't get any data in the sheet in sted I get wron
values. As I sad before it work Ok in 97 and 2k.

Regards // Dan
 
Hi Dave ,

I have an non english version of excel. If I translate the error t
english it says "wrong value" in formula box. Insted of data it's
filled with ###### sign insted of data. This happens in the hol
workbook.

Regards // Da
 
Later versions of excel like to calculate a workbook right when it's opening if
it was created in an earlier version.

If there are links that can't be refreshed, you'll get those errors.

You could ask the xl97 user to convert those links to values (a copy of the
workbook--not the original!).

Or you could try a registry tweak posted by Jim Rech:
http://groups.google.com/[email protected]
 
Back
Top