Support Knowledge Base, Article 1120 |
| Product |
| ExcelWriter |
| Version |
| Any |
| Title |
| Cannot open PivotTable source file '[filename(x.y).xls]SourceData' |
| Problem |
| Excel spreadsheets streamed to an IE client that contain pivot tables give the following error message when opened: Cannot open PivotTable source file '[filename(x.y).xls]SourceData' |
| Solution |
This is a known problem with IE, see this Microsoft KB. There are a few ways to avoid this problem.
- When calling the Save method, set the openInBrowser parameter to true, so the spreadsheet will open in the browser plugin rather than Excel. When spreadsheets open directly in the browser window, this problem does not occur.
- Use a non IE browser like FireFox.
- Use the OfficeWriter Assistant to transfer the file.
|
| Created : 1/7/2008 3:22:50 PM (last modified : 1/7/2008 3:22:50 PM) |
