Thanks macropod... I didn't mention that I was opening files created from an
earlier version - obviously, that was significant. Appreciate your help.

"macropod" wrote:

Ah, so the workbooks you're getting are in an older version? In that case, it's not just that you're using Excel 2007. Rather, this
is a long-standing practice in Excel, whereby automatic links in older workbook formats are recalculated regardless of the link
update setting. This behaviour goes back to at least Excel 2000.

As you've found, opening the files in the earlier version stops the update. Similarly, if your source changes over the Excel 2007
and saves the file in the new format, the problem will go away.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Compatibility link Excel 2007" . com wrote in message
...
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.

"macropod" wrote:

Hi,

That sounds more like there is a problem with the names used in the workbook, rather than with any links to/from it. Maybe it's
corrupt. I'd suggest contacting the author to sort out the problem.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Compatibility link Excel 2007" . com wrote in message
...
Yes; that box is checked. When I try to open the file when it is first sent
to me, I never get a chance to answer the question whether to update links...
I immediately get a dialog box that says "One or more invalid names were
detected in this workbook. Those invalid names have been changed to #REF."

"macropod" wrote:

Hi,

Did you try checking the 'Ask to update automatic links' option?

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Compatibility link Excel 2007" <Compatibility link Excel wrote in message
...
I am receiving a workbook via email that includes links to files I cannot
access. In Excel 2003, this was not a problem when i open the workbook,,, I
simply could not update the links. Now under 2007, it replaces the fields
with #NAME?. I can open a blank workbook and set recalc to manual then open
the intended file but then would not be able to do any manual recalc unles I
value copy all the externally linked cells.