G
GYRO
Why do some files ask me to save the changes I made when closing them,
when I haven't made any changes whatsoever?
when I haven't made any changes whatsoever?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Do you have any formulas in your workbook like NOW(), TODAY(), INDIRECT,
OFFSET etc.?
--
Regards,
Peo Sjoblom
(No private emails please)
OFFSET etc.?
--
Regards,
Peo Sjoblom
(No private emails please)
G
GYRO
Yes I do. I have formulas with dates as a matter of fact...
D
Dave Peterson
Those functions recalculate when excel recalculates. So the workbook changes
from its original state. That's why you get the prompt.
from its original state. That's why you get the prompt.
P
Pete_UK
I've also found that if you open a workbook and look at a filter
pull-down list (without selecting any values) then close the workbook
then Excel will think that you have changed something so it will ask if
you want to save.
Pete
pull-down list (without selecting any values) then close the workbook
then Excel will think that you have changed something so it will ask if
you want to save.
Pete