MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculations in large spreadsheets


Posted by Jeremy on December 16, 1999 1:39 AM

Does anyone know if there is a way to calculate only a selection of cells within Excel 2000. I know that you can do [Shift] + F9 which will only calculate the active sheet, but even that is taking me a few minutes each time I recalculate due to many formulas in a very big spreadsheet. Any ideas greatly appreciated !


Posted by Ivan Moala on December 16, 1999 3:03 AM

Hi Jeremy
One way you could do this is
1) If you know which ones NOT to calculate the
select these and do a search & replace of the "="
sign and replace with a unique character, then after calculation replace the unique character with the "=" sign. If you had the inclination you could do this via macros;
Look @ doing this via > assigning a range object to Selection.SpecialCells(xlCellTypeFormulas, 23)
in combination with your target cell range and application.intersect(range).


Ivan