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).


1 to 1 of 1
  1. Recalculate
    2005-03-22 06:40:30  cgb [View]

1 to 1 of 1