Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow response from excel
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow response from excel
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extremely slow response times in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 File Slow Response | Excel Programming | |||
Excel SLOW !! Response time ... | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Response | Setting up and Configuration of Excel | |||
Slow response to every change made in Excel | Excel Discussion (Misc queries) |