I use the following steps for all of my CMS report exports to Excel:
CMS: Select Edit - Export Table Data. Choose Export to Clipboard, and make sure tht Export Null Values as Zero and Include Labels and Headers are checked.
Excel: Open a blank worksheet and select PASTE from the Edit menu (or just use the CTRL/V shortcut key.
Susan
"'I wish life was not so short,' he thought. 'Languages take such a time, and so do all the things one wants to know about.'"
- J. R. R. Tolkien, The Lost Road