EXCEL: Eliminate Workbook Error Messages & Document Repairs - Recover Content Safely

Hello,

EXCEL begins to annoy me, namely every time I open the Workbook a message pops up "

"There is content in the new workbook that causes the problem, Do you want the program to attempt to recover the contents of this workbook?"


after clicking yes

another message pops up

"Document repairs"

The excel program opened the file by repairing ....

despite the fact that it will save after recovery or repair an error occurs

and after clicking on the repair history nothing specific

see attachments

And where from buddy do you have this peak with macros "Folder.xlsm"?

Answer the Excel question - do you have it from a trusted source?

Trusted sources - as a rule, they do not hide any macros or sheets of the "sheet8.xml" type

Open some new workbook, enter some data and save it once as a regular workbook (1) xlsx, and then save the same workbook (2) as xlsm.

Try to open them later and watch Excel's security response to really trusted files

Buddy, yes, from a trusted source, the macros are created by me, unless the error relates to a macro that retrieves storage values from the program, it goes through the SYMTRAX add-on



I was able to solve the problem !!

namely, DEFINED CELL NAMES were responsible for the formation of errors !! referring to other sheets, including the sheet in which the SYMTRAX table was updated

thanks for every tips