...
When using a version of Excel beyond 2016 (Excel 365, Excel 2019), the "From Web (Legacy)" option must be used to import data from the Report Direct Link. Perform the following steps to add this option to the Data ribbon.
Note |
---|
You may need to Enable the Legacy Wizard in Microsoft Office Excel 365 if they do not appear in the Get & Transform area (under the DATA tab). To do this,
|
- In Excel, Go to File-> Options-> Customize Ribbon-> select All Commands-> From Web(Legacy)- and add it to “New Group” under the Data tab.
...