Excel Returns Blank Workbooks in SAPGUI

Don’t you hate it when you’re trying to view a report as a spreadsheet in SAPGui and it returns a blank workbook?  The problem could be due a security settings inside of Excel that is preventing the data from being displayed.  It is real easy to fix.  Use the following instructions for your version Microsoft Office.

Office/Excel 2003:

Open Excel

Tools -> macro -> security

Security Level tab: make sure level is set to “medium”

Trusted Sources tab: Check the box beside “Trust access to visual basic project.”

Office 2007:

Click the Office button.  Click Excel Options.

Click on Trust Center -> Trust Center Settings

Check the box beside “Trust access to VBA project object model”

Close Excel and try to view your report again.  The workbook should no longer be blank and it should be populated with the correct data.