Topic: Saving of a file by a macro
The macro creates a file, interposes tables, forms pivot tables and charts. Then saves and closes a file.
If to open the saved file a macro produces the message "the Error regarding contained in the book. To fulfill recovery attempt? If you trust a source from which the book is received, push button" Yes "." If to push on "Yes" instead of tables as ListObject and instead of pivot tables simple tables without formatting on all tabs are displayed, there are charts.
If to pause a macro in save point and to save manually the file opens normally.
Why so happens? How correctly to save?