Excel corrupt files with BI models sometime. Help!

[IlyaK]

Hi everyone!
For a long time can't find a solution of this problem: while saving file with using BI, Excel makes fatal damages on the file:
attempt to open this file after save&close arise an error: "Can't find library or property" and lead to closing Excel.
Situation very sad because data in files isn't accessible - file isn't openable, make connection by Get&Transform is impossible.
This situation driving me mad, because it demand making backup copies every time I intend to make ctrl-S.

Environment description:
Files locates on net-storage (by MS Server), In file exist some VBA-code, not used in this session.
Version of MS Excel: MSO (16.0.4498.1000) 64-bit.
No third-side addons in Excel.

PS: may be there is some connection with subject:
Sometime while closing Excel, pop up a dialog with:
"You are changed personal book of VBA-macros. Save?" (this my inexact translation in English),
in spite of the fact that I haven't made any modification on this.
It's not a signal means that file now to be broken, but look some strange..


Many thanks for any help!
Regards, Ilya.

 

[SpillerBD]

"Can't find library or property"... Probably an Open_Event not well written and the library resource is not active in your Excel. That is probably the source of the attempt to change the personal macro workbook.

Data may be retrieved if you change the file extension to ".zip" and then look through the Table objects in the compressed "folder." (The .XLSX file extension is actually a compressed file folder of XML data.)

 

[IlyaK]

Thanks for replay, but it would be right if this situation would be repeatable, but it is not. Corrupt of file occure absolutely random. There is no open_event there either..

 

[IlyaK]

Hi everyone! Here is the great tread about subject (directed by Maxim Zelenskiy):
http://exceleratorbi.com.au/does-the-power-pivot-excel-add-in-crash-for-you/
Really helpful discussion. I'm not alone And I hope that MS doing their best to resolve those problems.

 

[SamSamSam]

Registered to respond. Try opening the file but do not click enable. Save it as an xlsx instead of xlsm. Worked for me.

Also FYI I'm on 64bit 2016 and it was stored on MS Server at one point. Macros in book had no open event so that root cause is not clear to me.