I use the smfUpdateDownloadTable macro for such situations. This would actually place values into the table, so no recalculation occurs. When I want "fresh" values, I just rerun the macro. Here is the documentation for the table setup from the macro's module:
- The upper left hand corner cell of the table needs to have a range name of "Ticker"
- The cells below the "Ticker" cell should be filled in with ticker symbols, one per cell
- The cells to the right of the "Ticker" cell should be filled with column titles
- The cells above the column titles need to be filled in with SMF add-in formulas or element numbers. Use five tildas as a substitute for a ticker symbol. For example, any of the following text strings could be used to get "Market Capitalization" from Yahoo:
On 10/19/07, rjlabs <rick@...> wrote:
> I have a large table of =RCHGetElementNumber() that has historical
> quarterly info that I only need to update sporadically. It takes about
> 15 minutes to update (about 60 tickers x 150 fields).
> Is there a way I can control when those functions run and update? I
> want to be able to open the spreadsheet with perhaps stale data and
> not have it update. However I don't want to set calculation to manual
> because other parts of the workbook I want regularly calculating. (Any
> programmer guide or FAQ or embedded docs on this just point me to them.)