Solution : https://service.sap.com/sap/support/notes/696069 (SAP Service marketplace login required)
Summary :
This SAP Note addresses an issue where no data is displayed when switching the view from ALV Grid to Excel Inplace on Microsoft Office XP/2003/2007/2010. The core issue stems from the high-security settings in new Office releases which impact macro functionalities and Visual Basic projects - essential components of Excel Inplace. To resolve, set the Macro security to Medium in Office XP and 2003, and ensure 'Trust access to Visual Basic Project' is enabled. For Office 2007 and 2010, configurations require enabling all macros and trusting access to the Visual Basic Project via the Trust Center settings.
Key words :
file->options->trust center->click 'trust center settings' button->macro settings, tools->macro->security->trusted sources tab, security settings/options, excel inplace onalv grid, excel inplace functionality make, automatically disables macro, solution required settings, terms excel inplace, visual basic project, excel inplace functionality
Related Notes :
| 1169035 | Output of specification data with Excel |
| 1094693 | Blank/Empty Excel spreadsheet using Office 2007 and ALV |
| 722513 | Desktop Office Integration: Maintenance information |