Well figured it out.. It looks like you export them as XML not as the traditional xls format.
I found that the CLIENTS IP ADDRESSES if you drill down to one IP address only will be corrupt and will not display.
See video http://75.146.47.217/excel.wmv
The file exported will be corrupt from this section. It will now load properly in Excel.
Users will also be corrupt if you drill down to a user like IP's.
Show Involved clients will also be corrupt under Top visited dowmains.