excel errors were detected while saving....

[JonasTiger]

Hi
I can't save a file (very important one) with more than 20 sheets, all linked by formulae and queries (powerquery). It represents a very longtime work with very sensitive data in my job.
I've been googling for anykind of fixing, without sucess. Every options I've found, none of them results (change name, type or location).
Is there a way to repair or recover this? And what's the alternative to prevent that in the future?

Thanks
JT

 

[Candyman8019]

What error are you getting?

 

[JonasTiger]

What error are you getting?

Msgbox - Errors were detected while saving 'C:\Users\....*xlsb'. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving file, click Cancel.
Then
Msgbox - Excel encountered errors during save. However, Excel was able to minimally save your file to C\Users\...\AppData\ROaming\Microsoft\Excel\XL31FB.xlsb
I click OK and then
Msgbox - Repairs to '...*.xlsb' - Damage to the file was so extensive that repairs were not possible. Excel attemped to save your formulas and values, but some data may have been lost or corrupted

 

[Candyman8019]

Do you happen to have the main doc saved on a shared network drive or sharepoint site where you could grab the last version of it?

 

[JonasTiger]

Do you happen to have the main doc saved on a shared network drive or sharepoint site where you could grab the last version of it?

No, it is saved in a foulder in MyDocuments.
This happened in a laptop with office 365

 

[Candyman8019]

Assuming the laptop is functioning fine and other files save properly, I fear you may be out of luck. You said you tried a different location...that would have been my next suggestion, ie thumbdrive or cloud storage. Hopefully you have a recent backup saved somewhere. A couple of technical alternatives that may yield positive results:
1. system restore your laptop to a day prior to the file damage.
2. Check the shadow file to see if you can grab a good copy from there. Here's a brief explanation: What Are “Shadow Copies”, and How Can I Use Them to Copy Locked Files?