How to remove automatic calculate function?
 

My excel always 'calculates' even when I am only typing a word or just a
number. There are no filters or formulae, it happens when I just open a new
book. How do I avoid this?

How to remove automatic calculate function?
 

Check out the options under ToolsOptionsCalculation..

--
Jacob (MVP - Excel)


"Carol" wrote:

My excel always 'calculates' even when I am only typing a word or just a
number. There are no filters or formulae, it happens when I just open a new
book. How do I avoid this?

How to remove automatic calculate function?
 

There must be Volatile Functions in your Workbook.


--
Regards
Dave Hawley
www.ozgrid.com
"Carol" wrote in message
...
My excel always 'calculates' even when I am only typing a word or just a
number. There are no filters or formulae, it happens when I just open a
new
book. How do I avoid this?

How to remove automatic calculate function?
 

Does this happen when you open excel with nothing more than that new workbook
open?

If yes, does it happen if you start excel in safe mode?

Close excel
Windows start button|run
type:
Excel /safe
and hit enter

If excel works correctly, then I'd guess you have something special in your
workbook template that's used as the basis for new workbooks.

Close excel
search for book.xlt (.xlt may be .xltx or .xltm or ...) depending on the version
of excel you're using.

Move it somewhere safe (or delete it???).

And reopen excel to test.

=======
(Saved from a previous post)

Close excel
use windows search to look for *.xlt*
and delete all that you find (or move them to a safe location if you're worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir book.xlt* /s

The /s says to search subfolders, too.

(There could be multiple *.xlt* files depending on your excel upgrade path.)

Carol wrote:

My excel always 'calculates' even when I am only typing a word or just a
number. There are no filters or formulae, it happens when I just open a new
book. How do I avoid this?

--

Dave Peterson