ExcelML and Pivots ConsolidationReference
 

I have successfully implemented a XML pivot report transform that is
available via a web page. If you have experience with this you know
about the consolidationreference tag. The consolidation reference tag
takes the filename of the excel file holding the pivot data.

Scenario:
I have a web page that generates (via XML/XSL) an excel file with two
worksheets. Sheet one holds a pivot report. Sheet two contains the
pivot data.

The url (for example) to open the sheet is http://localhost/excel.xml

Everything is wonderful.

If I would like to add url parameters then the pivot fails reporting
that it is unable to find the pivot source sheet.

I.E. http://localhost/excel.xml?id=4455

All of this tracks back to the consolidationreference tag in ExcelML. I
wish ExcelML had a notation for referencing "current file".

Has anyone experienced/solved this particular problem??


--
kleine98
------------------------------------------------------------------------
kleine98's Profile: http://www.excelforum.com/member.php...o&userid=22203
View this thread: http://www.excelforum.com/showthread...hreadid=493093