Hello:

I have a big workbook with like 16 sheets and a lot of formuals and vba
moduls. However, when I enter a number in a cell in the sheets, it takes
almost a second to show the number in the cell. It slows down the whole
proccess. I tested with a speed tester to recalculate the whole workbook,
each sheet, ranges and so on, all of them take much faster. How can that be?
What can I do to speed up the proccess?

The place where I enter the number is also copied in a different sheet.
Meaning, if I enter in Sheet1!CellA1 the number 5 then in sheet5!A1 the
number 5 will appear as well, thru a simple =sheet1!A1 formula. Does this
slow it down? This formula is in over 28,000 cells.

Please help.

Hi,

One option is to put the file in Manual Recalc mode and then just
recalculate what you need when you need it.

Choose Tools, Options, Calculation, Manual. (Also not the options for
recalculating the spreadsheet that are on this tab.)

You can also code recalculation to apply to sheets, workbooks, ranges or
whatever.
--
Thanks,
Shane Devenshire


"art" wrote:

Hello:

I have a big workbook with like 16 sheets and a lot of formuals and vba
moduls. However, when I enter a number in a cell in the sheets, it takes
almost a second to show the number in the cell. It slows down the whole
proccess. I tested with a speed tester to recalculate the whole workbook,
each sheet, ranges and so on, all of them take much faster. How can that be?
What can I do to speed up the proccess?

The place where I enter the number is also copied in a different sheet.
Meaning, if I enter in Sheet1!CellA1 the number 5 then in sheet5!A1 the
number 5 will appear as well, thru a simple =sheet1!A1 formula. Does this
slow it down? This formula is in over 28,000 cells.

Please help.