I have an Excel file saved in a locally-synced O365 directory. I opened it in the Excel for Mac desktop app today, and noticed the data in 3 columns were not in the correct rows.
I know this happens in columns where there is a formula, but none of the cells in any of these columns contained a formula.
When I view the contents of previous versions of the file (i.e. File > Browse File History), I can see that:
- I am the only person who has edited the file
- the last time the file was saved, the data was correct
One column is sorted (text, alphabetically), but I can’t recreate any combination of filtering / sorting that results in the view of the data I found when I opened the file today.
I would have expected any changes in filtering / sorting to be reflected in the version history.
Can anyone explain what has happened here? Although I obviously have the data, it did confuse me! It’d be nice to understand the issue, and stop it happening again…
