My columns have moved and I've lost data!

[fuchsia]

Hello, is anyone able to help? 

I've got a large excel sheet that I'm using for my work to help manage our workload and schedule when we see our clients. It's got basic details in a frozen frame and then you scroll across to a calendar where each column is a month. 

I've got it saved as a shared doc, autosaving every 5 mins. However, 3 of our staff have said that data they've entered in a specific month have mapped across to a different month (or column). 

Another staff member says that they've lost the data they entered in yesterday altogether. 

Does anyone know why data might be moving columns without being prompted to do so? Or how data might be lost?

Could this happen with changing the sharing settings? 

Any help much appreciated! 

Cheers!

[#2]

@fuchsia First, restore a backup. If you're using onedrive, it's easy: 

https://www.thewindowsclub.com/restore-previous-version-of-document-onedrive

If your users are entering new rows in a spreadsheet at the same time, that may cause issues.

As long as they are editing existing cell contents you should be fine.

Excel may not be the best tool for this, consider access instead.

good luck