Excel 发现不可读的内容
当我打开 Excel 文件（通过 VBA 代码生成）时，出现错误
“Excel 在 <文件名> 中发现无法读取的内容。您想要恢复内容吗？”
单击“是”后，我收到 错误消息消息
'Repairs were made to PivotTable report 'pvtName' on '[filename.xls]Tab'.'
有问题的数据透视表是由 VBA 代码生成的。有没有办法弄清楚数据透视表上正在进行哪些修复，以便我可以在生成文件之前对代码进行必要的更改？
谢谢 ：）
When I open an excel file (generated through VBA code), I get an error
"Excel found unreadable content in <filename>. Do you want to recover the contents?"
Upon clicking yes, I get a message
'Repairs were made to PivotTable report 'pvtName' on '[filename.xls]Tab'.'
The pivot table in question is generated by the VBA code. Is there a way to figure out what repairs are being done on the pivot table, so that I can make the necessary changes in the code before the file is generated?
Thanks :)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
通过确保文件扩展名是 .xlsm 且 FileFormat 52（启用宏的工作簿）已解决此问题。
但是，使用 Excel 2003 的用户将无法正确查看数据透视表。
如果有人有更好的解决方法，请告诉我。
This issue was resolved by making sure the file extension was .xlsm and the FileFormat 52 (Macro Enabled Workbook).
However, users with Excel 2003 won't be able to view the pivot table properly.
If someone has a better workaround, please let me know.