I tried this out. Once I refresh the data using menu Data -- Refresh
Data, the formatting will be gone.

Sorry, I didn't state my scenario completely. I am using a .NET
WinForm app to control the Excel programmtically. The data will be
generated as XML and imported into Excel. So every time, I need to
refresh the data.

Any other ideas?

Thanks!