Why adding a "" on my excel file name causes issue in Pivot table refresh?
Posted on 2011-05-01
I have an excel file with normal pivot talbe: document.xls,
when I renamed it with docuemtn.xls, and then refresh the data source, I will get errors (reference is not valid, etc.). But when I revised the name by removing  sign, say, document.xls, I don't have this issue anymore in refresh the pivot table data source.
The only difference is the "" sign in the excel document name.
Anyone could give me some hint? Thanks a lot!