-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
get external data
-
M
Importing Website Data Into Excel Issues
I am having an issue with "Get External Data" from two different websites from the same vendor https://results.enr.clarityelections.com/IL/Will/95133/Web02.225997/#/ and https://www.dupageresults.com/IL/DuPage/94959/Web02.225997/#/. Currently, I am unable to figure out how to pull the data into...- mp338198
- Thread
- data excel external get external data greatly
- Replies: 0
- Forum: General Discussion & Other Applications
-
L
No Table Import Wizard
When I go into Power Pivot in Excel 2016 and Excel 2019 and select Get External Data From Other Sources I get nothing, no Table Import Wizard. Any ideals why? Thank you!- LDale
- Thread
- excel 2016 excel 2019 from other sources get external data power pivot
- Replies: 1
- Forum: Excel Questions
-
L
No Table Import Wizard
When I go into Power Pivot in Excel 2016 and Excel 2019 and select Get External Data From Other Sources I get nothing, no Table Import Wizard. Any ideals why? Thank you!- LDale
- Thread
- excel from other sources get external data power pivot 2016 and 2019 table
- Replies: 1
- Forum: Power Tools
-
R
Import Data from Sharepoint Web Part to Excel
I am in the process of trying to import dynamic data from a single web part in sharepoint 2013 to an excel spread sheet. Then from that spread sheet I want to export to a Powerpoint slide. My problem is I cant figure out how to pull just the data from the web part. When attempting to use get...- rcolving
- Thread
- excel get external data import sharepoint web part
- Replies: 0
- Forum: Excel Questions
-
E
Need help with Get External Data function
Hello, I would like to be able to pull the spot price of gold and silver from the internet and put them in a spreadsheet at the click of a button. I know I need to use the "Get External Data" function and / or VBA to do this. I do not know how to write Web Queries. Can someone help me out...- ExcelArtist
- Thread
- get external data gold silver spot price web queries
- Replies: 1
- Forum: Excel Questions
-
R
Choose file for Macro to import
Hi I have recorded a macro that gets external data from a text file and sorts it. However the macro always gets the same file, from the same location. How do I make the macro ask me for a file to import? And yes. This is my first macro... So I need all the help I can get.- RasmusMoerch
- Thread
- from text get external data macro
- Replies: 3
- Forum: Excel Questions
-
How to Get Data from Web and make sure that the existing table is updated with the new data?
Dear Fellow Excel Users, I need help with getting data externally from web and also keeping the previous data prior to the refresh. My external table/data has 10 rows reporting values per day (10 days data table). I can link the table to my sheet, however what I can not do is to create an...- hkaraca
- Thread
- from web get external data rolling dates year to date
- Replies: 3
- Forum: Excel Questions
-
S
Using the get external data (web) restrictions
I was trying to get the quotes from the following web site but although there is a yellow box next to the table, nothing seems to get imported. Am i doing something wrong? http://netdania.com/Products/live-streaming-currency-rates-foreign-exchange/real-time-quotes/QuoteList.aspx?m=q- scolty1985
- Thread
- get external data
- Replies: 1
- Forum: Excel Questions
-
2
Get External Data
Hi Could anyone tell how to enalble "Get External Data" section under "Data" menu? I am using Excel 2007 and want to connect two spreadsheets. But for some reason this section is grayed out. Thanks Rajesh- 22strider
- Thread
- get external data
- Replies: 0
- Forum: Excel Questions
