| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation speed and workbook size | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| Need to Reduce the file size | Excel Discussion (Misc queries) | |||
| How to Reduce Spreadsheet Size and Speed | Excel Worksheet Functions | |||
| How do I reduce the worksheet size ? | Excel Discussion (Misc queries) | |||
Threaded Mode
