Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a 55MB workbook that takes about 3 or 4 minutes to calc. Therefore, I
use Manual recalculation. I also have 3 supplemental workbooks each of which is 5MB to 10MB and have links to the primary workbook. Sometimes (not always), when I have the supplemental workbooks open and I recalc, it can take up to 15 minutes. While inconvenient, this is not the problem. When the calc is complete and the status line shows "Ready", sometimes the workbooks get into a mode where the status line also shows "Calculate" despite the fact that it just finished calc'ing. Once this happens, it doesn't matter how mant times I recalc, I can't get rid of the status. If I close everything, reopen and then recalc, it usually clears. There are no circular relationships. What might be the issue? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i pull all subtotals from a spreadsheet | Excel Worksheet Functions | |||
Big problem with large spreadsheet. | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
large sumproducts causing memory errors | Excel Discussion (Misc queries) |