![]() ![]() Open your Excel application, and check if there is the POWER QUERY tab or the Get & Transform section under the Data tab. Open Control Panel > Programs and Features, select Office application and click Change > Online Repair > Repair. I cannot upgrade my current version of Internet Explorer for my current Windows system, so I am not sure what can be done here. Run the Online Repair for your Office applications, and check the outcome. The problem is that the page from which I am attempting the import does not support IE8, and so my attempted Web Query fails. In Excel 2016, the Power Query tab has been integrated into Excel and is available in the Get & Transform group on the Data tab (figure 1b). 101), Excel insists on using that for the Web Query, and I do not appear to be able to change it. the closest I found was a powerpivot download for Excel 2010, tried to install it but complains that I do not have excel 2010. HOWEVER Power Pivot is not listed in the options for addins. Unfortunately, even though Internet Explorer 8 is not set as my default browser (which is Google Chrome - version. Instructions claim to go into Excel and click File>Options>Add Ins etc etc. I'm currently attempting to set-up a Web Query in Excel 2010 using Data/ Connections/ From Web to import data from a particular website (a Google Sheets page, to be precise). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |