Excel Data deletion

[rcocrane99]

Hey Everyone, my picture above shows highlighted cells where overnight data was deleted not sure why or how but these are numbers I need. Mind you this document is shared via sharepoint and we input this data from multiple computers and tablets. Is there a way to create a backup file schedule ( maybe like every 1hr and after 24 copies it deletes the oldest version) where I can go back and look at versions where the data was there before or just check the version history and retrieve my data?

 

[myall_blues]

If it's on sharepoint then it is probably versioned anyway. Right click the file on sharepoint, choose version history and it will show you previous versions with links.

 

[rcocrane99]

Okay awesome !! I've found that and confirmed it works, that being said I've figured out why exactly it did happen, one of my team members was noted with the error cant sync data please discard, any idea why that pop up happens?

 

[myall_blues]

No sorry I don’t. I’m far from a SharePoint expert.