+ Reply to Thread
Results 1 to 3 of 3

why would calculate change from automatic to manual on its own?

  1. #1
    sandy
    Guest

    why would calculate change from automatic to manual on its own?

    undet tools, options, calulation tab, sometimes it changes from
    the default automatic to manual. why?

  2. #2
    Dave Peterson
    Guest

    Re: why would calculate change from automatic to manual on its own?

    Excel picks this setting up from the first workbook it opens in that session.

    If you have a workbook that lots of people can edit (like on a network drive),
    then you may have a co-worker who changes this setting to manual (maybe on
    purpose--maybe not!).

    If you open that workbook first, you inherit that setting.

    So if you open a workbook that you know has calculation set for automatic, then
    open the other workbook, you'll be ok.

    (Or just remember how to toggle the setting and yell at your co-worker! <vbg>)

    sandy wrote:
    >
    > undet tools, options, calulation tab, sometimes it changes from
    > the default automatic to manual. why?


    --

    Dave Peterson

  3. #3
    David McRitchie
    Guest

    Re: why would calculate change from automatic to manual on its own?

    Hi Sandy,
    Not quite on it's own.

    The first workbook to be opened is what determines your setting for automatic
    or manual calculation. You can change it anytime, but if you don't save your
    first workbook opened it will revert back. Workbooks in your XLSTART
    directory such as personal.xls and hopefully it is the only workbook there
    are opened first. Window, unhide/hide file

    You can have a macro or an addin turn off calculation and not turn it back on
    particularly if the coding aborts and no provision was made for abnormal
    terminations.

    The fastest way for me to set calculation back to normal would be to use
    my TRIMALL macro on a single cell as it will turn calculation on when if
    finishes, I just added code to tell you if if was OFF to begin with.
    http://www.mvps.org/dmcritchie/excel/join.htm#trimall
    I added that because it is a macro I run frequently and I already have it
    set to turn event handling back on if an Event Macro messed up, and
    it was already turning calculation on -- so I added the MsgBox warning
    if calculation had been OFF when macro started.

    If you can't identify when the problem is actually occuring it might help
    to modify your Auto_Open in your personal.xls which would normally
    be the first file opened. Then maybe you will remember what you
    did in the last Excel session.
    http://www.mvps.org/dmcritchie/excel...esp.htm#addins
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

    "sandy" <sandy@discussions.microsoft.com> wrote ...
    > undet tools, options, calulation tab, sometimes it changes from
    > the default automatic to manual. why?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1