Importing XML using Stylesheet doesn't allow refreshing

K

keith

Hi I'm trying to import xml data into my excel workbook using a stylesheet.
When I open my xml file I'm allowed to pick my stylesheet and the data
imports exactly how I want. The problem is I can't refresh this data, if I
look at the connection property it looks as though excel made a temp xml file
to store the xslt transformed xml data. Is there any way to get an xslt
imported xml data to refresh from the origianl xml file using the xslt
stylesheet I chose when I originally imported the data.

Thanks,
Keith
 

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

Similar Threads

Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Getting "question mark in block" at EOL in CSV files transformed fromXML 1
Opening XML file with an XSL stylesheet 3
XML to Excel 0
Saving as XML 0
XML Map Refresh on Open 0
Excel 2010 - Save as XML 0
Excel Column Width in XLSX 0

Top