I have a couple shared workbooks where I work, and every now and then, when I open a file, all the formatting has been changed. The "Normal" version of the text has been switched to "Time" format.
To fix it, I have to make sure everyone exits the spreadsheet, unshare, and redo the formatting of "Normal" from time to general, correct miscellaneous formatting issues that are leftover, then reshare the file. Some of the spreadsheets are fairly complex, so this is challenging at best.
This begs a few questions:
- How might this be happening? None of my users are Excel savvy, and none are intentionally doing it.
- Is there a way to figure out which machine/user is making the change?
- How can I prevent it from happening?