Integrating OdataLink with Microsoft Excel: Difference between revisions

No edit summary
No edit summary
 
(18 intermediate revisions by the same user not shown)
Line 1: Line 1:
The following guides 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 integrating with ODataLink, it is recommended to [[Testing OData feed URLs|test the OData feed URLs]] to ensure they are correctly setup.
 
= How-To Guides =
 
The following guides will assist integrating OdataLink with [[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 />
'''[[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 />
[[Copying the OData feed URL]] <br />
[[Relinking an existing OData feed power query in Microsoft Excel]] <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 />
[[Updating the permissions for an OData feed power query in Microsoft Excel]] <br />


= Related Topics =
= Related Topics =
[[Integrating with ODataLink]]
[[Integrating with OdataLink]]<br />
[[Microsoft Excel]] <br />