I'm running Excel 2003.
This has been an annoyance of mine for quite some time. After only viewing (making no changes) an Excel file containing worksheets with dates, Excel always prompts with a "Save changes?" dialog when closing the file.
I have one sheet containing dates of birth and another column with a formula that shows the persons' ages. I can understand why that one prompts me, as the age column always changes, but I wish it wouldn't. In another worksheet, though, all I have is data containing formatted dates and I still get the prompt.
Can this behavior be defeated?
Bookmarks