I have been upgraded to Excel 2007 at work. I have been having problems
working with versions of workbooks that are linked to other workbooks. On the
previous version of Excel it asked you if you wanted to update links or not.
Everyone here at work knows to answer this question no. By answering no, it
doesn't matter if the linked workbook is on someone's computer it leaves the
cell values alone.

With 2007, when I open a workbook it automatically updates it, until I go
into the Excel options and unclick the first box under Excel
OptionsadvancedWhen calculating this workbook. After I uncheck the box it
doesn't update any more but the linked cells have already been changed to
Ref! errors.

I have also saved as and the checkbox was checked again on the new version.
This is a major pain in the you-know-what.

I can't find any other place to make Excel 2007 not update upon opening a
workbook.

Any suggestions out there on how to make this work?
--
Thanks,
Laura