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.