For Office 365 Excel Version 16.70 (For previous versions of Excel for Mac click here)
-Open a blank workbook
-Click Data and then Get Data (Power Query)
...
-In the popup screen click on OData
...
-Enter the URL: https://api.buzmanager.com/reports/YOUR-ORGANISATION-CODE
-Change the Connection Credentials to Basic and enter your BUZ user name and password
...
-Follow instructions from step 5 onwards on page Excel Reporting using OData to edit the query
...
| Anchor | ||||
|---|---|---|---|---|
|
Some older versions of Excel for Mac may not be supported. Please follow instruction below if you are not using Office 365 Version 16.70
There are no ability to query the data at this stage in Excel on OSX , however Excel allows you to open and refresh spreadsheets previously created in Excel for Windows.
...