Difference between revisions of "Integrating OdataLink with Microsoft Excel"
Jump to navigation
Jump to search
(18 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
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 | |||
= 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 | [[Integrating with OdataLink]]<br /> | ||
[[Microsoft Excel]] <br /> |
Latest revision as of 18:14, 15 March 2023
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 Microsoft Power Query Addin.
How-To Guides
The following guides will assist integrating OdataLink with Microsoft Excel.
Before integrating with OdataLink, it is recommended to test the OData feed URLs to ensure they are correctly setup.
Adding an OData feed power query to Microsoft Excel
Editing an OData feed power query in Microsoft Excel
Copying the OData feed URL
Relinking an existing OData feed power query in Microsoft Excel
Updating the permissions for an OData feed power query in Microsoft Excel