LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove from excel automatic date function? Need Help New Users to Excel 2 September 14th 07 06:42 PM
How do I remove the automatic help box in Word and Excel? Lydia New Users to Excel 2 January 3rd 07 10:01 PM
How to Remove Automatic Links? Constructor Excel Discussion (Misc queries) 2 December 15th 06 09:41 PM
How do I remove automatic page breaks? Cici Excel Worksheet Functions 3 June 23rd 06 09:59 PM
How to remove the automatic date format? [email protected] Excel Discussion (Misc queries) 3 April 29th 06 02:52 AM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"