Hi how to Extract date from another excel table in the same file?
@vaclavplanicka2375
2 жыл бұрын
Hi I followed all the steps from your video. Unfortunately when I want to open saved query I can't select the saved file. The only files I can access are the original samples. Any ideas? Thx
@charliecheesman
2 жыл бұрын
If you right click and select Quick Look it will then let you select the file
@masonc7417
2 жыл бұрын
@@charliecheesman Thank you that works
@pankajsharma1125
2 жыл бұрын
this message coming again n again ...please help...."This Web query returned no data. To change the query, click OK, click the arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection and then click Edit Query."
@andreas4714
Жыл бұрын
i cant find the queries folder on my mac? where do you guys get this folder from?
@geoffwatson
2 жыл бұрын
Dragging query to the dock does nothing!
@vash6249
2 жыл бұрын
Is it possibile create a button in a sheet to refresh queries instead that use "refresh all" button provided by excel?
@QVisible
2 жыл бұрын
In Mac version it is more limited. But I would imagine you could write a macro and insert a button on the spreadsheet to do it if you wish. I don't know of hand what the code would be.
@sattikiganguly544
2 жыл бұрын
What does one do if there is no "queries" folder?
@QVisible
2 жыл бұрын
you can make one. They are just text files.
@TrangCherryblossomTr
2 жыл бұрын
which version of your excel? My version does not have the "New database queries" button :((((
@QVisible
2 жыл бұрын
Are you mac or Windows?
@TrangCherryblossomTr
2 жыл бұрын
@@QVisible I use MAC, friend!!
@rajatchauhan4410
Жыл бұрын
At the moment this feature is only available to Microsoft 365 users on the Beta Channel using a certain version and later of Excel. What version of Excel do you have? Are you on the Beta Channel? To check what version you are on, click Excel (from the Menu Bar) and About Microsoft Excel. To join the Beta Channel, start a new workbook and click the Help menu. Then click Check for updates and then click Click Advanced. To switch to the Beta Channel set the update channel dropdown to Beta. if you are already on the Beta channel, Microsoft roll these updates out in batches. It might not be your turn just yet. All I can say is keep hitting update (like when you keep hitting refresh)
@danybernal8918
Жыл бұрын
my excel won't show external data or web query. been trying for over an hour and can't figure out what's wrong :(
@dieuhiennguyenvu9119
Жыл бұрын
You probably check your updated excel version
@tonytaf107
Жыл бұрын
How do we magically find this query crap into docs!!!!!!!??????????
@DwaipayanRC
2 жыл бұрын
In 2021 version this option of get data is not available in as I checked in my mac.
@QVisible
2 жыл бұрын
Good to know.
@darryldeklerk5452
2 жыл бұрын
Hi all. Thanks for the info. Can someone please help me. I can successfully import the web query into excel (Mac), but I am unable to use the data in calculations. For example, I am unable to multiply the data by the data in another cell. I get #VALUE! returned. Can anyone please help. Id appreciate it.
@timmyc3152
8 ай бұрын
Hmm edited the sample iqy file with a new URL and it won’t let me access the file
@darrenwarmington7037
2 жыл бұрын
What if you want to combine multiple sheets into one sheet can that be done
@QVisible
2 жыл бұрын
Refer to the different cells from other worksheet?
@darrenwarmington7037
2 жыл бұрын
@@QVisible I'm not sure what you mean
@sebastianramos4428
3 жыл бұрын
If I want to obtain the financial statements, how do I do it?
@QVisible
3 жыл бұрын
Go to historical data on youtube finance for a stock. e.g. finance.yahoo.com/quote/TSLA/history?p=TSLA. This is the type of url that's in the qry file in this video.
@gwilympugh139
2 жыл бұрын
How would you access web data that requires an API?
@QVisible
2 жыл бұрын
You maybe able to do it through VBA. Better using the Windows version of excel for this.
Пікірлер: 30