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又不打开.
有达人知道怎么决定么??? | c*****a
发帖数: 1577 | 2 xlsm means the file has VB macro, try enable macro first in excel
【在 t*****g 的大作中提到】
: 用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又不打开.
: 有达人知道怎么决定么???
| a*******9
发帖数: 174 | 3 looks like this pivot table is link to the data source some where, every
time when you try to open it, it ask you to update the data. if the style or
format is put in those piovt table cell, it will be recover after update
the table.
Not sure, I might be wrong. |
|
