default pref choosen ws format forced to an existing worksheet
I noticed that there is a setting that forced every opened WS to set to dirty state ( unsaved state) and when saved it will use/forced a different, the set default WS format.
This setting is found, preferences > tab Compatilibity > preffered file format. The popover note says, that I can set this to the one that I used most, but not that it forces me to change an existing WS format to that format.
So, instead that it is used only with a new document, where and when I do expect it to effect on, Excel doesn't respect the current document format. It try to force to change it.
Why? Sounds irrational.
It is really annoiing when you open a document and later quit Excel or a system shutdown, that it request/required to save that document even when nothing has changed.
So, please let that setting only be used with new worksheets.