Integrating OdataLink with Microsoft Excel: Difference between revisions

(11 intermediate revisions by the same user not shown)

Line 1:

In order to integrate ~~ODataLink~~ with Microsoft Excel, you will need to ensure you have Microsoft Office 365 or Microsoft Office 2016 or higher.

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 =

The following guides will assist integrating ~~ODataLink~~ with Microsoft Excel.

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.

'''~~Initial Development''' ~~

'''[[Adding an OData feed power query to Microsoft Excel]]'''

[[Adding an OData feed power query to Microsoft Excel]]

[[Editing an OData feed power query in Microsoft Excel]]

[[Copying the OData feed URL]]

~~'''Ongoing Development''' ~~

[[Relinking an existing OData feed power query in Microsoft Excel]]

[[Updating the permissions for an OData feed power query in Microsoft Excel]]

Line 21:

Line 20:

= Related Topics =

[[Integrating with ~~ODataLink~~]]

[[Integrating with OdataLink]]

[[Microsoft Excel]]

@@ Line 1: / Line 1: @@
-In order to integrate ODataLink with Microsoft Excel, you will need to ensure you have Microsoft Office 365 or Microsoft Office 2016 or higher.
+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 =
-The following guides will assist integrating ODataLink with Microsoft Excel.
+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.
-'''Initial Development''' <br />
+'''[[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 />
-'''Ongoing Development''' <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 />
@@ Line 21: / Line 20: @@
 = Related Topics =
-[[Integrating with ODataLink]]
+[[Integrating with OdataLink]]<br />
+[[Microsoft Excel]] <br />