Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Excel Add-In (no data)

  • 1.  Excel Add-In (no data)

    SILVER CONTRIBUTOR
    Posted 15 days ago
    Edited by Mark Yankovich 14 days ago
    Hello!

    Made a first attempt to use the Dynamics AX add-in for Excel.  All seems fine, except that no data is returned.  The tables and fields show in the left pane, but no data is returned.  What are we missing?

    We are in an AX 2012 R3 on-premise implementation stage.

    (The client components were removed and re-installed with no change in the results).

    Thank you!

    #AX2012
    #Beginner
    #Admin
    ​​​

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    ------------------------------​​
    AXUG Summit - Post


  • 2.  RE: Excel Add-In (no data)

    TOP CONTRIBUTOR
    Posted 14 days ago
    Hi Mark,

    What exactly do you mean with a left pane. Can you possibly include a screenshot (using the advanced editor) to illustrate exactly what you are looking at?

    ------------------------------
    kind regards,

    André Arnaud de Calavon
    Solution Architect, Microsoft MVP - Microsoft Dynamics Business Solutions
    ------------------------------

    AXUG Summit - Post


  • 3.  RE: Excel Add-In (no data)

    SILVER CONTRIBUTOR
    Posted 14 days ago
    Andre,

    Here is a screenshot.  The left side displays the fields of the InventTable.  Notice that no data was returned to the spreadsheet.

    Excel - Dynamics AX (screenshot)

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    ------------------------------

    AXUG Summit - Post


  • 4.  RE: Excel Add-In (no data)

    TOP CONTRIBUTOR
    Posted 14 days ago
    You are currently in "Design mode" when the field list is displayed on the left, you cant retrieve data in design mode.  Double click / drag the fields onto the worksheet that you want to see / edit.   Right mouse click on the top level table -> Properties -> tick the "show calculated fields" box to show display methods.  Then, once your done selecting fields,iIn the Dynamics AX tab in the ribbon, click the "Fields" button so it is not highlighted.

    Once you have exited design mode, click the "refresh" button in the top left.

    Also, hit the Options button and verify you are connected to the correct AOS.


    ------------------------------
    Colby Gallagher
    Manufacturing Systems Consultant
    Agility Business Solutions
    Brecksville OH
    ------------------------------

    AXUG Summit - Post


  • 5.  RE: Excel Add-In (no data)

    Posted 14 days ago
    Hi,

    Please refer below links to check if any setup/configuration is missing:

    (Integrating Microsoft Dynamics AX with Microsoft Office)
    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/integrating-microsoft-dynamics-ax-with-microsoft-office

    (Set up integration with Microsoft Office Add-ins)
    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/set-up-integration-with-microsoft-office-add-ins

    (Using the Microsoft Dynamics AX Add-in for Excel)
    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/using-the-microsoft-dynamics-ax-add-in-for-excel

    ------------------------------
    Regards,
    Chaitanya Golla
    Lead Architect
    ------------------------------

    AXUG Summit - Post


  • 6.  RE: Excel Add-In (no data)

    SILVER CONTRIBUTOR
    Posted 13 days ago
    All is working now.  Thanks to your help!

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    ------------------------------

    AXUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role