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.
About Wess Tobler
Doesn’t work for me. Sheets stays empty…
Hi, this doesn’t work for me in Office 2010. It still returns a blank workbook. Any suggestions?
Thanks!