While editing, Excel restored the workbook and I lost all changes. Since Excel did not crash there was no recover file to retrieve the data. Has anyone seen this unexpected event before? This had never happened before while working with Excel for a long time and seemed to just start like some...
I've been working on an Excel file with no problems. Then yesterday I opened it and got the error in the subject line. Certain - but not all - of the formulas in the workbook now simply contain "=#N/A". I fixed the formulas and re-saved it. I opened the file again today and got the same...
When I reopened a large excel file, I received an error message that data was lost. In the file many formulas were converted to #N/A. Any idea how this happened? What can I do to prevent this from happening again?
Thanks.
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.