Excel prompts to save when no changes made
 

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?

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?

Excel prompts to save when no changes made
 

There are no volatile functions or charts. When I open a file save it and
close it, then I go and re-open it, it will still ask me to save my changes
(with no changes being made). It's is very frustrating. Thanks for the
help, but still looking for a solution. Anyone?

"Bernard Liengme" wrote:

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?