Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
I'm building XSLT files to transfomr XML data to XML Excel spreadsheet files,
From the worksheet that I created with the XML data I am taking the data and creating another worksheet with pivot table, the problem is that this requiring except the source worksheet name the file name too... ?! somthing like [XSL Output.xml]Report Data The problem is that the file name is not static and it could change from time to time... so... Is there a way to tell Excel too look for the worksheet in the current file ? Is there a workaround for this problem ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |