View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keith Keith is offline
external usenet poster
 
Posts: 262
Default Importing XML using Stylesheet doesn't allow refreshing

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