t*****g 发帖数: 2941 | 1 用Excel 2007. 有Pivot Table.
之前做好的报告,现在打开,有error message
"Excel found unreadable content in 'filename.xlsm'. Do you want to recover
the contents of this workbook? If you trust the source of this workbook,
click Yes"
Yes后,之前设计好的style, format什么都不见了.
No呢,file又不打开.
有达人知道怎么决定么??? | t*****g 发帖数: 2941 | 2 Microsoft的support上是这个
http://support.microsoft.com/kb/929766
CAUSE
This issue occurs if the following conditions are true: The workbook
contains a...This issue occurs if the following conditions are true:
The workbook contains a PivotTable that uses key performance indicators (
KPIs).
The KPIs are created in the Analysis Services Business Intelligence
Development Studio.
One or more of the KPIs have an expression in the Current Time Member
property.
RESOLUTIONTo resolve this issue, remove the expressions from all Current
Time Member prope...To resolve this issue, remove the expressions from all
Current Time Member properties. | t*****g 发帖数: 2941 | 3 怎样才能remove current time member??? | s****r 发帖数: 180 | 4 why can't you delete the pivot table, saved the file under another name, and
recreate the table after opening? | t*****g 发帖数: 2941 | 5 I can not. Other people need to use my file too.
and
【在 s****r 的大作中提到】 : why can't you delete the pivot table, saved the file under another name, and : recreate the table after opening?
| t*****g 发帖数: 2941 | | t*****g 发帖数: 2941 | 7 后来知道怎么回事了
因为那个file的format和style超过了4千个, 达到了excel 2007的极限
以后format的时候尽量少用很多不同的combination
一发现copy paste不work了,就不要save
总是,excel就这一点上,真是个烂东西,一不小心,活就白干了 | r********r 发帖数: 964 | 8 好大的文件
【在 t*****g 的大作中提到】 : 后来知道怎么回事了 : 因为那个file的format和style超过了4千个, 达到了excel 2007的极限 : 以后format的时候尽量少用很多不同的combination : 一发现copy paste不work了,就不要save : 总是,excel就这一点上,真是个烂东西,一不小心,活就白干了
| n***b 发帖数: 5914 | 9 4千个style.........你是在给奥巴马政府做税么。。。。
【在 t*****g 的大作中提到】 : 后来知道怎么回事了 : 因为那个file的format和style超过了4千个, 达到了excel 2007的极限 : 以后format的时候尽量少用很多不同的combination : 一发现copy paste不work了,就不要save : 总是,excel就这一点上,真是个烂东西,一不小心,活就白干了
|
|