Menu
Cart 0

Our Blog — Excel

Add Additional Dynamics AX Fields to Worksheets After Exporting to Excel

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Exporting to Excel from Dynamics AX is probably one of the most used features for all of the do-it-yourselfers out there because once the data is in Excel you can create your own reports, dashboards, and analysis in a tool that we are all very familiar with. But just because Dynamics AX exports the fields …

Read More

Read more →

Update Dynamics AX records through Excel using the Excel Add-in

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

The Excel Add-In does more than just download data to Excel, you can also use it to publish data back to Dynamics AX, making it a great tool for performing mass imports of records, and also for tweaking your data after you have it within Dynamics AX. This is a much better option than ODBC …

Read More

Read more →

Use Export to Excel and the Excel Add-in for Dynamics AX to create Reports in Excel

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

When you have the Dynamics AX Add-In for Excel installed, the Export to Excel function within Dynamics AX automatically links the data table that you exported back to the data within Dynamics AX.  This means that you are able to refresh the data at any time, returning back the latest information without having to re-export …

Read More

Read more →

Creating & Consuming Web Services with Excel

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

There are a whole slew of web services available in Dynamics AX 2012, but how do you use them?In this example we will show how you can publish the web services so that you can use them in an application, and also show an example of the web services in action by using them to …

Read More

Read more →