Forum Discussion
How to import an .XML table in Excel 2010 whilst ensuring cell references are maintained?
I have a spreadsheet where sheet 1 (e.g. A1:E10) is monthly data in the form of a table created from imported .XML data (and which allows Excel to determine the structure of the table); and sheet 2 w...
In the properties of the external data connection, somewhere there's an option that tells Excel what to do with the newly imported data and what to do if less rows are imported. Experiment with those sttings.
