Integrating OdataLink with Microsoft Excel: Difference between revisions

Created page with "This guide will assist integrating ODataLink with Microsoft Excel. Before beginning, it is recommended to test the OData feed urls. To integrate..."
 
No edit summary
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
This guide will assist integrating ODataLink with Microsoft Excel.
In order to integrate OdataLink with [[Microsoft Excel]], you will need to ensure you have:
* Microsoft Office 365
* Microsoft Office 2016 or higher
* Microsoft Office 2010 or 2013 with the [https://www.microsoft.com/en-au/download/details.aspx?id=102 Microsoft Power Query Addin].


Before beginning, it is recommended to [[Testing OData feed URLs|test the OData feed urls]].


To integrate with Mircrosoft Excel, you will need to:
= How-To Guides =
# [[Copy the OData feed URLs]].
# [[Add an OData feed query to Microsoft Excel]].


Additionally, you may want to:
The following guides will assist integrating OdataLink with [[Microsoft Excel]].
# [[Relink an existing OData feed query in Microsoft Excel]].
 
# [[Updating the permissions for an OData Feed query in Microsoft Excel]].
Before integrating with OdataLink, it is recommended to [[Testing OData feed URLs|test the OData feed URLs]] to ensure they are correctly setup.
 
 
'''[[Adding an OData feed power query to Microsoft Excel]]''' <br />
[[Editing an OData feed power query in Microsoft Excel]] <br />
[[Copying the OData feed URL]] <br />
[[Relinking an existing OData feed power query in Microsoft Excel]] <br />
[[Updating the permissions for an OData feed power query in Microsoft Excel]] <br />
 
 
= Related Topics =
[[Integrating with OdataLink]]<br />
[[Microsoft Excel]] <br />