The Choose a Query dialog displays defaulting to the Queries folder. Select the query file to run in the Choose a Query dialog. Click the Get Data Button. The Returning Data to Excel dialog opens. You can choose a cell that will be used for the upper left cell of the imported table. To run a web query use the Data menu The 'Background query' thing has to do with if you have a really slow internet connection. It lets you do other things in Excel if your connection is slow (like mine is at the moment). Notice the status bar says it is running the background query.
![]() whbunnmacrumors member
I have a question involving using web queries in the Mac version of Excel 2008 and Excel in Office 2011 or 2016.
I have written some web queries for use in in Excel 2008. These queries get stock prices. Here is a sample, file name “stocks.iqy”: WEB 1 http://finance.yahoo.com/d/quotes?s=T+MO+AEE+BCS+WATT+HCP+JNJ+KMB+MRK+NAT+SFL&f=l1 This query was originally used in a 2008 sheet. It also works when the original sheet is opened in Excel 2011 and 2016. However, if I start a new sheet in version 2011 or 2016 and try to insert the saved query into the new sheet, I receive dialog: “The file may not be in the right format…”. Can anyone tell me what is going wrong? ![]()
It’s not there yet – but it’s starting! Excel for Mac is taking its first steps into Power Query Land (who said this was Never Never Land?).
Up until now, Power Query has not been supported in Excel for Mac, but the tide is turning. Starting with anyone with Office Insiders Fast in Excel for Mac version 16.26 (19052200) or later, the journey starts now.
As of this release, end users may refresh Power Query queries on a Mac – albeit for CSV, JSON, Text, XLSX and XML files only. It may only be baby steps – but it’s a significant start.
To see how it might work for you, refresh your workbook queries as you would do normally (either using Data -> Refresh All or VBA). The refresh will now work for the file types stipulated above. You might need to update the file path so that it works. In this instance, click Data -> Connections -> select the connection that failed to refresh -> Change File Path to update.
Alternatively, you could use a PC (bang goes our Apple freebies).
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |