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??