I have never set a workbook to manual and can only assume I have
downloaded one that was set that way and that it reset all mine. This
seems dangerous, especially as the cells erroneously indicate that they
are the sum of the cells. (ie they indicate that the calculation has
been carried out by updating the cell references) There is no warning
that this is not so. I can hardly believe this can happen. So much for
telling my employees that to check their work just click on the cell
and it will tell you what cells have been used to obtain that figure.
Gord Dibben wrote:

Sarah

Re-read the response from Gary's Student about the order in which you open
workbooks and what Calc Mode Excel defaults to.


Gord Dibben MS Excel MVP

On 21 Jan 2007 09:33:51 -0800, "Sarahj" wrote:

Can anyone throw any light
on how the setting had become changed to Manual? I certainly did not
consciously change it.