Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Excel Options

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    316
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello All,

    Really bizarre thing here. Under Tools>Options>Calculation I keep checking the Automatic calculation, unchecking Iterations and making the max interations 100. I think that's the Excel default.

    For some reason though when I open Excel, it defaults to Automatically Save on Tables, The Iteration box is checked, and the max Iteration is 1, which won't allow circular calcs. This is crazy!

    Any Ideas?


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Guderup, Denmark
    Posts
    288
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My Excel did the same thing by default.
    One way to overcome this, is to open a blank sheet, set the options you want.
    Save this workbook as a template, naming it Book.xlt and save it in the XLSTART directory.
    EL will now use this template for every new book including your options.
    regards Tommy

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    316
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you sir! Worked beautifully.

  4. #4
    New Member
    Join Date
    Aug 2009
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Re: Excel Options

    Hi there:

    I have a similar question about Excel 2007.

    After I check (or clear) "Show Developer tab in the Ribbon" and "Enable iterative calculation" and quit Excel, the next time I launch Excel (from start menu) I notice that Excel remembers the value of the tab property correctly but the iterative calculation is always cleared.

    To me, both settings should be remembered correctly since they are application properties

    Is there a way to change the default value for the iterative calculation property directly (like a registry entry or something like that)?

    I know about the possibility of using a template, but thatīs not what I want to do.

    As a matter of fact, I think I need the type of solution Iīm asking for because I actually need is to solve another problem, to wit, allowing iterative calculation in a embedded worksheet in a PowerPoint slide.

    Tks.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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