"timteebow66" wrote:
I set it to manual calculation, but it still takes a full 6 minutes to OPEN
and SAVE. Any other ideas?

a. As Excel sets the calc mode for each session following that of the first
book that's opened (the first book opened could well be set to Automatic),
just be aware of this event. That means even if your particular file is saved
at manual, it will open in Automatic mode (hence the delay?). Maybe try
opening just this particular file directly whenever you open it. And remember
to *uncheck* "Recalc before save"

b. Try the calculation secrets, optimising speed pages, etc on Charles'
website:
http://www.decisionmodels.com/
(Maybe Charles himself might drop by here, too?)

c. Test these changes carefully in a spare copy
1. Try replacing the DV? dynamic range below with a fixed range
=OFFSET($E$4,0,0,COUNT(F:F),1)

2. In A3 to D3, see whether you can live w/o the error trap, eg in A3:
=IF(ISERR(OFFSET(BudgetCost!$A$1,I4-1,0)),"",OFFSET(BudgetCost!$A$1,I4-1,0))
Replace A3 with just: =OFFSET(BudgetCost!$A$1,I4-1,0)
Similarly in B3 to D3. It might look ugly on the sheet, but if the error
returns in these cells do not have dependents elsewhere, it's tolerable.

3. Try replacing the front IF part in F3
=IF(OR(ISERR(SMALL(G:G,ROW(1:1))),BudgetCost!A4="" ),"",...
with this:
=IF(BudgetCost!A4="","",IF(ROWS($1:1)COUNT(G:G)," ",...
(Think it should be faster to check the single cell A4 first, then to use
simplier constructs in the next IF check)

Of course, after replacing the top cells above, you should fill down as
required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---