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.
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.