Making a ConsolidationReference default to the current workbook.
in [Programming]
|
Prev: System.Runtime.InteropServices.COMException (0x80020005) in excel 2k7, but worked well in 2k3
Next: Error on Excel 2003 Workbook_Open XmlMaps
From: pnschofield on 17 Nov 2006 15:31 I'm dynamically generating an XML spreadsheet in ASP.NET and setting the content disposition to attachment so the user will be able to open or save the document. If they select Open, "[1]" is getting appended to the filename, which is breaking the ConsolidationReference FileName setting in my pivot table. Is there a way to get a ConsolidationReference to default to the current workbook? Thanks in advance! Paul
From: pnschofield on 20 Nov 2006 15:30
Alright, let me break this down a little bit in case it wasn't clear what I'm doing. I have a pivot table that can't connect to a live cube, so I have it use local data within the spreadsheet. This works as long as the filename of the spreadsheet doesn't change. The pivot table knows to look within its own workbook (ReportOutput.xml) for the worksheet containing the data used for the pivot table. But when ASP.NET serves the document and the user clicks "Open," IE renames the file to ReportOutput[1].xml, and the pivot table doesn't know where to find the data. Is there a way to set a pivot table to just look in the current workbook if you can't be certain what the filename of the workbook is going to be? Paul pnschofield(a)yahoo.com wrote: > I'm dynamically generating an XML spreadsheet in ASP.NET and setting > the content disposition to attachment so the user will be able to open > or save the document. If they select Open, "[1]" is getting appended > to the filename, which is breaking the ConsolidationReference FileName > setting in my pivot table. Is there a way to get a > ConsolidationReference to default to the current workbook? > > Thanks in advance! > > Paul |