SERVING THE QUANTITATIVE FINANCE COMMUNITY

Search found 49 matches

by FastExcel
December 15th, 2003, 9:09 am
Forum: Programming and Software Forum
Topic: making excel files smaller
Replies: 9
Views: 189593

making excel files smaller

<t>There is a small advantage (file-size and execution speed) to using multi-cell array formulae compared to a block of identical single-cell formulae.Multi-cell array formulae are better protected against accidental change, but slightly harder to maintain.Partially overlapping array formulae and th...
by FastExcel
December 13th, 2003, 1:10 pm
Forum: Programming and Software Forum
Topic: Excel range name
Replies: 3
Views: 189151

Excel range name

A closer equivalent would be to use Excel.Application.Evaluate("RangeName").The evaluate method evaluates a string using Excel's formula evaluation method.
by FastExcel
December 13th, 2003, 1:02 pm
Forum: Programming and Software Forum
Topic: making excel files smaller
Replies: 9
Views: 189593

making excel files smaller

<r>There are some tips fpr making files smaller and using less memory at:<URL url="http://www.DecisionModels.com/optspeedd.htm">http://www.DecisionModels.com/optspeedd.htm</URL> and <URL url="http://www.decisionmodels.com/memlimitsc.htmbottlenecks/sizeMemory"><LINK_TEXT text="http://www.decisionmode...
by FastExcel
December 2nd, 2003, 8:20 am
Forum: Programming and Software Forum
Topic: Excel question
Replies: 6
Views: 189506

Excel question

<r>try calculatefull rather than calculatefullrebuild.see <URL url="http://www.decisionmodels.com/calcsecretsh.htm">http://www.decisionmodels.com/calcsecretsh.htm</URL> and <URL url="http://www.decisionmodels.com/calcsecretsj.htm">http://www.decisionmodels.com/calcsecretsj.htm</URL> for advice on ca...
GZIP: On