Dependency Tree Rebuild

[Jason]

Hi Folks,

Under Windows (Excel 2002), one can force a full recalculation with a
dependency tree rebuild by either pressing <CTRL><ALT><F9>, or use the
VBA object Application.CalculateFullRebuild. But on the Mac on Excel X
(as far as I can tell), there does not appear to be a way for me to do
this, by either VBA instruction or key combo. Does anyone know of a
VBA Macro I could write, an existing key combo, or a proper VBA object
that I could call in order to effect a full recalculation with
dependency tree rebuild? Or has Microsoft left us in the cold on this
one?

Cheers,
--Jason

 

[Jim Gordon MVP]

Hi

VB 6 methods are not available on Mac Excel. You are limited to using VB 5
objects and methods.


Application.Calculate (or just Calculate)

Will recalculate the active workbook. If you are referring to dependency
trees as displayed by the auditing toolbar they should be recalculated using
this method.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.

An Excel add-in is available to help with this task.
<http://www.rondebruin.nl/Google.htm>