pistolpete66, Thank you for the explanation. It was right on and will keep
me from searching for a solution other than the workarounds in the link. I
have not checked this sight since you answered in mid-Nov. Thanks again.
"pistolpete66" wrote:
Unfortunately, you're dealing with what I consider a significant flaw in
Excel 2007. This link explains more, but essentially, any spreadsheets
created in a version prior to 2007 with links to other sheets or workbooks
external to the existing workbook will be recalculated and may/will return
errors. There's no way in Excel 2007 to prevent the auto-recalc, according
to the article. I've had the same issue come up and there's no real "fix",
just an ugly workaround. See this link for more info:
http://support.microsoft.com/kb/925893
Compatibility link Excel 2007 wrote:
Thank for responding. I have a number of worksheets sent (emailed) from the
same source. I can open them with no trouble in 2003 but have the issue when
trying to open in 2007. I am assuming it is related to tightened security in
2007... unless the names were legal in 2003 and not in 2007.
Thanks again.
Hi,
[quoted text clipped - 18 lines]
the intended file but then would not be able to do any manual recalc unles I
value copy all the externally linked cells.