View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default 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?