Thread
:
Excel prompts to save when no changes made
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_]
external usenet poster
Posts: 1,104
Excel prompts to save when no changes made
As far as I recall Excel gives this message regardless any users changes
being made when:
1) there are volatile function such as NOW, TODAY...
2) the workbook contains a chart
3) the version opening the file is newer than the on that last saved the
file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"CPA Jeff" <CPA
wrote in message
...
Whenever I open an Excel file I am ALWAYS prompted to save my changes,
even
when I made no changes. I do not have any volitale functions. There is
another computer in the office where this does not happen. We are both
running Excel 2003. I cannot find a setting where I can fix this. I do
notice that if I create the file and save it to our server, then it does
not
ask me to save when I open it (ok, so not always). However, there are
numerous files on our server that were created using an older version of
Excel, and I am ALWAYS prompted to save changes, but my co-worker's
computer
does not prompt. What setting would be different?
Reply With Quote
Bernard Liengme[_3_]
View Public Profile
Find all posts by Bernard Liengme[_3_]