advertisement

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
Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • Recalculate
    2005-03-22 06:40:30  cgb [Reply | View]

    Hello,

    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.