R
Ron Rosenfeld
I just upgraded from Excel 2002 --> 2007
A particular file behaves strangely when saved in the original .xls format.
EOMONTH function gets replaced with a currently unused NAME that refers to a
formula upon Save. (This screws everything up, of course).
Enabling the ATP add-in in the Name manager doesn't seem to make any
difference.
Saving in .xlsm format does seem to result in a proper file.
What is going on?
How to prevent it?
Do I need to enable the either the regular, or the VBA ATP add-ins?
Thanks.
--ron
A particular file behaves strangely when saved in the original .xls format.
EOMONTH function gets replaced with a currently unused NAME that refers to a
formula upon Save. (This screws everything up, of course).
Enabling the ATP add-in in the Name manager doesn't seem to make any
difference.
Saving in .xlsm format does seem to result in a proper file.
What is going on?
How to prevent it?
Do I need to enable the either the regular, or the VBA ATP add-ins?
Thanks.
--ron