Excel file not saving!

[touque]

we have an excel file that is being stored in Onedrive and it doesn't seem to be saving. Changes have been implemented a couple of times and when it gets opened the next time the previous days changes are not there. I am just curious if something like this is happening with Onedrive, has anyone heard of this?
another factor could be the size of the file as it has 1 summary sheet and then 240 more sheets (tabs) with fairly simple spreadsheet data with about 10 lines each. I think the file is about 2Mb.
Another issue may be is that the inputter is a newbie and may not be doing things right as one anomaly I noticed was the version she sent today had the number 12 at the end of the title. Almost looks like she may have 12 different versions of the file!

 

[JLGWhiz]

The file was probably saved to the user's default drive instead of OneDrive. Check the user's default directory and see if you find the file there with the changes that were made. This is a common clerical error that is made with a user doing a SaveAs on a filie that is normally stored on an external drive. They forget to include the file path as part of the SaveAs file name, so Excel automatically reverts to default drive.. A regular save action would save it to the directory it currently resides in, but SaveAs must define the directory path if other than default.

 

[touque]

Thank you JLG, that Is good to know. I am gonna drop by the office tomorrow and we will walk through how she saved them.

 

[touque]

Solved! I thought it was worse than it actually was. Only our Friday's changes did not save and we are 99% sure she did not hit "save" and autosave was off.
I thought there was more data missing but she did not input that data in this file yet.
That is a good point to remember when using the "save as" feature JLG. I did warn her of that possible trap for the future.