Stop asking to save changes if nothing has changed
You open and Excel file and look at it for a moment then click Close. Excel pops up a dialog "Want to save your changes?". I didn't change anything! Please stop asking to save changes when nothing has changed. It confuses the user.
This is made worse if I've has that spreadsheet open for a long time and I don't remember if I changed it or not. Or worse, there may be other people working on the same file and if I say "Save", I overwrite their changes.
I heard that this has to do with Excel saving the current cell position. If all that changed is that, or some other thing that doesn't change the data, maybe the dialog should say "Only current cell position has changed, save it?" Or have a button that says "See what changed" and takes you to a summarized list of what changed. If the only item in the list is "current cell position" I know I can safely click "Don't save".
This is my #1 annoyance with Excel.
Mary OD commented
I think I'm only asked whether or not to save my files I intend to open and not edit when there is a TODAY formula somewhere - like 'hidden' in a header or footer.
When I'm asked whether I want to save changes and believe there is not such a date formula, I can see what I changed by clicking the Undo button in my toolbar. If it's disabled, I know I've done nothing. I have this button first on my button bar, right below the File drop down menu.
Perhaps what works for me can help others?
Most people don't care about cell position and other minor changes.
Give us the option to include them, its very annoying getting prompted to save a document that hasn't been modified.