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.