Excel found unreadable content in

Question

When I open an excel file (generated via VBA code), I get an error

"Excel found unreadable content in <filename>. Do you want to recover the contents?"

After clicking "Yes" I get a message

'Repairs were made to PivotTable report 'pvtName' on '[filename.xls]Tab'.'

The corresponding pivot table is generated by VBA code. Is there a way to find out what is being done on the pivot table so that I can make the necessary changes to the code before creating the file?

Thank:)

Answer 1

This problem was resolved by providing the .xlsm file extension and FileFormat 52 (Macro Enabled Workbook).

However, users with Excel 2003 will not be able to view the pivot table correctly.

If anyone has a better workaround, let me know.