1. Run the Measure Energy Savings Report with the box "Include client, agency and landlord information" checked
2. Open the file using a text editor application such as NotePad or TextEdit.
3. Search for and delete the text string ss:ExpandedColumnCount="71"
4. Save the file, now it should open in Excel.