Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Re-calculate function too slow
Hi, I am working on a large excel 2003 file which, although not linked to any
other files, has a large number of formulae linking to other worksheets in the same file. When I change the value in the one cell it doesn't automatically update the value in the cell which is referencing it. It updates eventually but I can't tell if this is because of the file being saved or excel getting thro the workload. So I don't know if it is to do with the processor speed, the re-calculate settings, the iteration settings or what? can anyone advise, thanks? CB (Also, the file is 30,000KB's, it was built with lots of pivot tables and vlookups but they are now all hardcoded, there's nothing more complicated than sumif and reference functions left) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Re-calculate function too slow
For lots of information and tips about calculation speed, visit Charles Williams' site:
www.decisionmodels.com -- Kind regards, Niek Otten Microsoft MVP - Excel "CB" wrote in message ... | Hi, I am working on a large excel 2003 file which, although not linked to any | other files, has a large number of formulae linking to other worksheets in | the same file. When I change the value in the one cell it doesn't | automatically update the value in the cell which is referencing it. It | updates eventually but I can't tell if this is because of the file being | saved or excel getting thro the workload. | | So I don't know if it is to do with the processor speed, the re-calculate | settings, the iteration settings or what? can anyone advise, thanks? CB | | (Also, the file is 30,000KB's, it was built with lots of pivot tables and | vlookups but they are now all hardcoded, there's nothing more complicated | than sumif and reference functions left) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
Charts calculate extremely slow in Beta 2 | Excel Discussion (Misc queries) | |||
slow replace function | Excel Worksheet Functions | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Why is the subtotal function in excel 2003 very slow compared to . | Excel Worksheet Functions |