Need to stop automatic column re-sizing when importing XML data

B

Brian Beckers

I have created an spreadsheet in Excel 2007 with an XML Map for importing and
reading data from an external source. My problem is that when I "Import XML"
in the Developer ribbon, the columns auto-format to match the width of the
data. I don't want this to happen.

How can I keep Excel from auto-sizing the columns when I import the XML data?
 

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

Cannot Import XML Spreadsheet 2003 with XML Data Source 0
XML data import breaks cell formatting 0
xml import problem 0
xml import....Size limit?? Can the XML file be split?? 0
XML Map Refresh on Open 0
Appending individual XML files to a sheet 0
Importing XML using Stylesheet doesn't allow refreshing 0
Import Multiple XML Files into Excel 3

Top