Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have imported NBA Basketball stats from a specific site to a spreadsheet.
When the stats change on the specific site, is it possible to have the same change made automatically on my spreadsheet? Example: What must I do to make the Won/Lost record for each team change automatically on my spreadsheet when it changes at the site from which I originally imported the Won/Lost records? Thanks in advance for your help. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Walter
If you do this via DataImport external dataNew web query... You will be able to right click on the data and just click refresh for the updated data. (That is providing the website keeps the same url). You can check the features of this out here http://www.nickhodge.co.uk/gui/datam...rtexternal.htm under web queries -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Walter" wrote in message ... I have imported NBA Basketball stats from a specific site to a spreadsheet. When the stats change on the specific site, is it possible to have the same change made automatically on my spreadsheet? Example: What must I do to make the Won/Lost record for each team change automatically on my spreadsheet when it changes at the site from which I originally imported the Won/Lost records? Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Excel be setup to automatically sum imported data | Excel Discussion (Misc queries) | |||
UPDATING IMPORTED DATA | Excel Worksheet Functions | |||
Automatically modifying imported reports | Excel Discussion (Misc queries) | |||
Automatically updating Graphs | Excel Worksheet Functions | |||
Automatically updating | New Users to Excel |