Prev: Be Careful while dealing with dynamic type and System.DBNull in C# 4.0(beta)
Next: anyone know if it'spossible to de-dupe a mailing list using excel
From: Carol on 29 Apr 2010 03:11
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?
From: Jacob Skaria on 29 Apr 2010 03:18
Check out the options under Tools>Options>Calculation..

--
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?
From: ozgrid.com on 29 Apr 2010 03:48
There must be Volatile Functions in your Workbook.


--
Regards
Dave Hawley
www.ozgrid.com
"Carol" <Carol(a)discussions.microsoft.com> wrote in message
news:AB035E27-3F46-4906-ABDB-130BB017F781(a)microsoft.com...
> 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?

From: Dave Peterson on 29 Apr 2010 08:11
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
 | 
Pages: 1
Prev: Be Careful while dealing with dynamic type and System.DBNull in C# 4.0(beta)
Next: anyone know if it'spossible to de-dupe a mailing list using excel