Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    To Display The Data in Excel Inplace From An ALV and in MS Word Editor With Office 2013/2016/2019

    Uploaded by

    Díaz

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    To Display The Data in Excel Inplace From An ALV and in MS Word Editor With Office 2013/2016/2019

    Uploaded by

    Díaz
    25 views3 pages

    Original Title

    696069_E_20221215

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    25 views3 pages

    To Display The Data in Excel Inplace From An ALV and in MS Word Editor With Office 2013/2016/2019

    Uploaded by

    Díaz

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    2022-12-15 696069

    696069 - To display the data in Excel inplace from an


    ALV and in MS Word editor with Office 2013/2016/2019
    Version 10 Type SAP Note
    Language English Master Language English
    Priority Recommendations / Additional Info Category Consulting
    Release Status Released for Customer Released On 05.02.2021
    Component BC-FES-OFFI ( SAP Desktop Office Integration )

    Please find the original document at https://launchpad.support.sap.com/#/notes/ 696069

    Symptom

    No data is displayed when the view in an ALV Grid is changed to "Excel Inplace"
    and the same symptom visible in Microsoft Word editor as well.
    This happens with Microsoft Office 2013/2016/2019.

    Other Terms

    Excel inplace, Excel, ALV, ; office 2013;office 2016; Office 2019; Blank, Empty;
    Populated; Automation Security; Macros; MS Word editor;

    Reason and Prerequisites

    With newer releases of Microsoft Office (2013/2016/2019) Microsoft added new


    security settings/options for Visual Basic projects and Macros. Excel/Word
    Inplace uses Visual Basic Project and macro functionality of Microsoft Office.
    If the setting for Macro security is High (which automatically disables macros)
    or if access to Visual Basic Project is suppressed then Excel Inplace doesn't
    show any Data in Excel.

    Solution

    --------------------------------------------------------------------------------
    ----------------------
    To use the Excel Inplace functionality make sure the security settings for Macro
    is set to Medium and the option "Trust access to Visual Basic Project" must be
    checked on Tools->Macro->Security->Trusted Sources tab.

    Required settings in Microsoft Office 2013, Microsoft Office 2016 and Microsoft
    Office 2019.

    --------------------------------------------------------------------------------
    ----------------------
    To use the Excel Inplace functionality, select 'enable all macros' in Macros
    settings and the option "Trust access to Visual Basic Project" must be checked
    on File->Options->Trust Center->Click 'Trust Center Settings' button->Macro
    Settings.

    This is required with Microsoft Office 2013, Microsoft Office 2016 and Microsoft
    Office 2019.

    --------------------------------------------------------------------------------
    -----------------------

    © 2022 SAP SE or an SAP affiliate company. All rights reserved 1 of 3


    2022-12-15 696069

    Automation Security

    This policy setting controls whether macros can run in an Office 2016
    application that is opened programmatically by another application.

    Required settings in Microsoft Office 2016.

    To use the Excel/Word Inplace functionality, the registry key must set to 1 or
    2, as mentioned below.

    Registry Hive HKEY_CURRENT_USER


    Registry Path software\policies\microsoft\office\common\security
    Value Name automationsecurity
    Value Type REG_DWORD
    Value 1 OR 2

    Value Type = 2 : User application macro security level - Macro functionality is


    determined by the setting in the "Macro Settings" section of the Trust Center.

    Value Type = 1 : Macros enabled (default) - Macros can run in the


    programmatically opened application. This option enforces the default
    configuration in Excel and Word.

    Other Components

    Component Description

    BC-SRV-ALV SAP List Viewer

    This document refers to

    SAP Note/KBA Title

    878322

    722513 Desktop Office Integration: Maintenance information

    1169035 Output of specification data with Excel

    1094693 Blank/Empty Excel spreadsheet using Office 2007 and ALV

    1067844

    This document is referenced by

    © 2022 SAP SE or an SAP affiliate company. All rights reserved 2 of 3


    2022-12-15 696069
    SAP Note/KBA Title

    2445376 Issue occurs in Excel Inplace mode - To distinguish whether the issue is SAP issue or OS issue

    2914094 Excel in-place: Macros are no longer needed while exporting data from ALV(Gridview)

    722513 Desktop Office Integration: Maintenance information

    1169035 Output of specification data with Excel

    1094693 Blank/Empty Excel spreadsheet using Office 2007 and ALV

    Attachments

    File Name File Size Mime Type

    ExcelMacroSecuritySettings.zip 1863 application/x-zip-compressed

    Terms of use | Copyright | Trademark | Legal Disclosure | Privacy

    © 2022 SAP SE or an SAP affiliate company. All rights reserved 3 of 3

    You might also like