Hi 3John,

There is a change in Excel 2003 relating to subtotals (because of the extra
subtotal options) which flags the workbook as uncalculated whenever rows are
hidden/unhidden.

Also a calculation in Excel is at application level (all open workbooks)
rather than just the active workbook.

But if application is set to manual I would not expect hiding/unhiding rows
to trigger a recalc: exactly what action is the user doing that triggers a
recalculation?

regards

--
Charles Williams
Decision Models

"thirdjohn84" wrote in message
...
We have a user that encounters a problem every time he uses subtotaling in
Excel 2003 (w/SP2). Even though he has Calculation set to "Manual", every
time he attempts to subtotal on a worksheet, all other unrelated books
recalculate (and he has quite a few, that go many layers deep). and Excel
freezes up. MS KB324557 has been tried, but to no avail. The unrelated
files
include circulated references, with iterations set at 50. There are also
user
defined functions contained in an Excel add-in. This problem began after
upgrading from Excel 2000 to Excel 2003.

Any ideas of where to start?