View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Reduce Fie Size, Speed Up Calculation

Yes Links are a disaster area waiting to happen.

Its only worthwhile using a RDB such as Jet/Access if the spreadsheet only
needs a small subset of the data at any one time.
but if thats what happens in your backtesting model it could be worthwhile.

Of course if the calculations are simple enough to be handled easily by SQL
then you could migrate the whole thing.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"chg" wrote in message
...
so links to external workbooks really do suck!
Simon knows why (http://smurfonspreadsheets.wordpress.com/2007/01/29/
links-to-external-workbooks/)

Anybody knows a tutorial for putting these data in access, would you
think this could be the right choice for my project?