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/groups?thre...GP11.phx .gbl
Hal wrote:
I have a workbook that contains links to other remote data sources and when I
select the start-up prompt option that says "don't update" so that excel will
use the previous information, excel tries to update and returns error codes.
How do I work with the existing data and stop the workbook link from trying
to update when the source file is not present?
--
Now if only I could get the pod door open.
--
Dave Peterson