Article:
 |
|
Getting Real-Time Data from the Web in Excel
|
| Subject: |
|
Recalculate |
| Date: |
|
2005-03-16 09:19:00 |
| From: |
|
Bigd
|
|
|
|
I tried the currency exchange example exactly as described. It works great.
I have encountered one problem though. When I open the workbook, the rate data is the same as the data when I last closed/saved the file. The only way to have it recalculate is to go to the cell and re-enter the Getrate() function.
Any suggestions as to what's wrong? Is there something I can do to have it recalculate when the worksheet is opened? (Note:The worksheet options are set to recalculate automatically).
Thanks
|
Showing messages 1 through 1 of 1.
-
Recalculate
2005-03-22 06:40:30
cgb
[View]
I am new in Web Service, and I am trying to use this example with Real Time in Excell.
Did you manage to find a solution for real time refreshing??
Thank you,
Chris.