Report Templates with PivotTables don''t open

[Jim Barry]

I am using excel template ideas to preform Excel templates (including pivot tables). I then take the template, dynamically add data and provide a web link to download the resuling file.

When the file is downloaded through IE, the PivotTable is having problems with the IE naming convention (ie the brackets) while the file sits inside of Temporary Internet Files

Two scenarios are troublesome:

1) DataSource =

If I use named regions as the datasource, I get the following error:

"The PivotTable field name is not valid. To create a Pivot Table report, you must use the data...".

If I save the file, and then refresh the PivotTable data --- it works.

All columns are non-blank and valid.

2) DataSource =

If I use a standard range syntax for the datasource, I get the following error:

"Cannot open PivotTable source file'[filename[x].xls]'Results!"

where 'Results!' is the worksheet that has the dynamic data.

It can't seem to reference the file because of the naming convention that includes brackets.

I tried opening the template excel files two ways with no luck..

workbook = excelEngine.Excel.Workbooks.Open(
strNewFileNamePath,
ExcelParseOptions.DoNotParseCharts
);

workbook = excelEngine.Excel.Workbooks.Open(
strNewFileNamePath,
ExcelParseOptions.Default
);


Operating Systems = XPSP2
Browser = IE7

If I save the file to be outside of the Temporary Internet Files, everything works as expected.

Any Ideas...

[Jim Barry]

Also tried opening the workbook with no luck using...

workbook = ExcelUtils.CreateWorkBookUsingTemplate(
strNewFileNamePath
);

[Melba Winshia]

Hi Jim,

Your direct-trac incident 38886 has been updated which has been created for the same issue. Please follow this issue in that incident #38886.

Kindly let me know if you have any other questions.

Thanks,
Melba