ConsolidationReference pointing to current file in xml

K

Kan Tong

Hi,
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... ?!

something like:
<ConsolidationReference>
<filename>[XSL Output.xml]Report Data</filename>
</ConsolidationReference>

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
? i have tried <filename>Report Data</filename> (note that "Report Data" is
the worksheet name) and it doesn't work

Is there a workaround for this problem ?

thanks very much for whoever can help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top