One week data is missing from excel file stored in onedrive

mdhaumyu

New Member
Joined
Mar 8, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Hi,

I am using excel file in onedrive and I am using auto-save option. I am also having a habit of saving (CTRL+S) quite oftenly (every few minutes).

Last week Friday I saved the file in onedrive and today (Monday) when I opened the file from onedrive, one weeks data is missing. I have tried recover data, manage workbook options. When I check the version history, the latest version is showing as one week before's date (by right it must show last Friday's date).

Today, my laptop had installed some Dell updates which was related to Wi-Fi UWD driver. When I restart and opened excel file from onedrive, data was missing.

Any idea how to recover the data for last week.

Thanks in advance.

Regards,
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Hi,​
the only way is to have some backup on a local drive …​
 
Upvote 0
Hi Marc,

Thanks for the reply. May I know, what might be the reason for missing data, maybe in future I will be careful.

Thanks in advance.
Hi,​
the only way is to have some backup on a local drive …​
 
Upvote 0
Try to copy the file on a local drive, open the workbook from the local drive, work and save it then copy the local workbook to onedrive …​
 
Upvote 0
Try to copy the file on a local drive, open the workbook from the local drive, work and save it then copy the local workbook to onedrive …​
Thanks again.

I know the process of copy to local drive, work on it, save and then copy it to onedrive.

I wanted to know what was the root-cause for the missing data.
 
Upvote 0
Differents sources may exist, to see with your IT …​
 
Upvote 0

Forum statistics

Threads
1,214,996
Messages
6,122,636
Members
449,092
Latest member
bsb1122

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top