Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Calculation (Excel 2000)

    Could you please tell me how to change my default calculation from manual to automatic. I tried changing the setting in tools > options > calculate > automatic and by right clicking on the sheet tab > properties > view code and changing enablecalulation to true; however, neither of these settings hold when I close excel.

    Thank you.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Automatic Calculation (Excel 2000)

    The most likely reason is that when you reopen Excel, a workbook is being opened which has it's calc settings set to manual. This resets the Excel default. Review all WB's that open on Excel startup, including any hidden ones such as Personal.xls. To unhide WB's, select Window | Unhide. If this doesn't help, post back.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Calculation (Excel 2000)

    I cannot locate a personal.xl* file on my hard drive and I have selected view hidden files. When I select Windows > Unhide on my default worksheet, the option is greyed out.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Automatic Calculation (Excel 2000)

    OK, you don't have a personal.xls (see note). Do you have any *.XL? files in your XLSTART folder? If so examine the calculation settings in them all. Under Tools | Options | General, is Alternate Startup Folder blank, or is there a folder location? If there is a folder location, examine the calculation settings in all *.XL? files in that folder.

    (Note: if the option is grayed out, you don't have any hidden workbooks. However, a WB that is hidden in Excel is not necessarily a Hidden File.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Calculation (Excel 2000)

    Look for a Book.xlt or Sheet.xlt (or any other files) in your XLStart directory.
    Legare Coleman

  6. #6
    Lounger
    Join Date
    Apr 2001
    Location
    St. Louis, Missouri, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Calculation (Excel 2000)

    Try recording a simple macro to the personal macros sheet, then close Excel and answer yes to the "save personal macro shet" message. It will create the personal.xls workbook, and then you can unhide it and change the default setting. Sometimes making a default "book.xlt" workbook template and putting this in xlstartup is easier to control defaults (see other posts).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •