Can XML Schema Be Refreshed Along with XML Data?

G

Gcleaves

I have an Excel worksheet with an XML imported list. The source is a web URL
that returns XML. I can choose to refresh the XML data and things work well,
if new the new data (records) comes into Excel. However, I need to modify
the XML source's schema after the first import takes place. After modifying
the schema (on the webserver), the new fields DO NOT appear in Excel after
refreshing the XML feed. It seems that the schema from the initial import is
set in stone. Is there any way to force Excel to reevealuate the schema,
thereby grabbing any new fields (elements), that may now exist in the source?

To summarize, a refresh will show new rows but not new columns.

Was I clear? Hope so, thanks for any suggestions...
 
G

Gcleaves

"After modifying the schema (on the webserver), the new *columns* DO NOT
appear in Excel after refreshing the XML feed."
 

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

XML Schema 0
Cannot Import XML Spreadsheet 2003 with XML Data Source 0
Excel 2007 and XML Schemas 0
XML Mapping 0
XML Schema edit 0
XML data import breaks cell formatting 0
Issues with opening an xml page 0
Appending individual XML files to a sheet 0

Top