Hi all -
A few years ago I created an Excel 2003 file that has macros for Importing/Exporting and manipulating XML table data.
I had to create it again in Excel version 2007.
It has lots of cool stuff, like a macro button called 'Insert row like this' where it inserts a row where the cursor is at, with the same properties as that row. Color-coded by Type of row, a 'Sort' button, and the 'Export File' button/macro takes the data and puts it back into an XML file so the XML file can be uploaded into a PeopleSoft application.
At some point, some users started using this Excel file (I call it a 'template' but it isn't really a MS template in the true defn), in Excel 2010.
The 2010 version works the same, and works well for table import/export/insert-a-row/entering data..., however when the user opens the Excel file and Imports an XML file into the table, the display gets choppy. Users like to scroll down and across to get the picture of their data. Now the color-scheme (conditional formatting based on a value in the column called 'Row Type') is wiped out - everything is white - even data is gone... temporarily of course because it really is still there. It looks terrible.

This display can be fixed if the user waits a bit, then clicks on Shift-F9. This seems like a poor solution, and I'm hoping someone will know what I can do in the VB behind the scenes to prevent the white-out from happening.
Thank you for any help!