Difference between revisions of "Integrating OdataLink with Microsoft Excel"
Jump to navigation
Jump to search
| (8 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 | 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]. | |||
= How-To Guides = | = How-To Guides = | ||
The following guides will assist integrating | 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. | Before integrating with OdataLink, it is recommended to [[Testing OData feed URLs|test the OData feed URLs]] to ensure they are correctly setup. | ||
| Line 17: | Line 20: | ||
= 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