Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|