Transition Link functionality from Excel 2003 to Excel 2007

W

webster

I have a HUGE number of spreadsheets developed while using older Excel.
Default settings for all old spreadsheets were to:
1) Not automatically update links on open
2) Not automatically update links on calculation
3) Not automatically update links on save/close

Excel 2007 enables all those when I open the legacy spreadsheets, updating
the values and forcing me to change properties on every file I open (via the
Home button and the excel options). In the excel options button you can only
set this preference at the worksheet level.

Is there a way to make this a global option that Excel 2007 defualts to for
every file opened - allowing me total control from the initial opening to the
save.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top