Excel prompts to save when no changes made

C

CPA Jeff

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?
 
B

Bernard Liengme

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
 
C

CPA Jeff

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top