|
我做了一个统计表格，里面有两个数据透视表，平时打开都没问题，但有的时候一打开就显示“数据透视表XX由于完整性问题而被丢弃”，我找了好久都没有相关的解决办法，最后换英文搜了一下，找到下面一段：
“Errors were detected in ‘[file name].xls’, but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent. Pivot-Table report ‘[report name]’ on ‘[file name].xls [worksheet_name]’ was discarded due to integrity problems.”
Solution: Microsoft claims these errors usually happen only under a specific set of circumstances: Auto-Save must be turned on, the workbook containing the PivotTable must be unprotected, and you must turn on worksheet protection but then have turned it back off. Microsoft has a fix, but you can’t download it directly from the company’s Web site. Users experiencing these errors must contact Microsoft’s customer service technicians to obtain the patch files. Visit www.support.mi crosoft.com/default.aspx?scid=fh;EN-US;CNTACTMS and use the contact information there to obtain the patch. Otherwise, never enable and then disable worksheet protection when dealing with files that contain PivotTables.
本人英语不好，虽然能看懂大部分单词的意思，但还是不能完全领会整段话的意思，望哪位高人给详细的翻译一下，或是直接告诉我上述问题的解决方法。
谢过
急
再谢
[此贴子已经被作者于2006-4-1 23:09:44编辑过] | 
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2006-3-31 18:49
楼主