1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2007: Manual calculation

Discussion in 'Business Applications' started by CreepinJesus, Oct 25, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. CreepinJesus

    CreepinJesus Thread Starter

    Joined:
    Oct 18, 2007
    Messages:
    23
    Is there any way to set the calculation to manual for one worksheet only as opposed to the global setting ?
     
  2. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
  3. CreepinJesus

    CreepinJesus Thread Starter

    Joined:
    Oct 18, 2007
    Messages:
    23
    So if I stuck the following code into the workbook in question:

    Code:
    Private Sub Workbook_Open()
       Application.Calculation = xlCalculationManual
    End Sub
    It would open under Manual calculating, even if Excel is set to automatic before-hand ? Also, would this keep Excel set to Manual after it has been closed and opened again ?
     
  4. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    If U don't turn off Macros, and do not change this property after opening the workbook, then it should work fine!
     
  5. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    You really must read the links I posted, they explain what you are asking. This may - or may not - be the case.
     
  6. CreepinJesus

    CreepinJesus Thread Starter

    Joined:
    Oct 18, 2007
    Messages:
    23
    I did - that's where that code came from...
     
  7. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    did you read this line from the MS page? "In Microsoft Excel, all currently open documents use the same mode of calculation, regardless of the mode in which they have been saved."
    and this
    "To recalculate only the active sheet, use one of the following methods:
    • Press SHIFT+F9.
    • In Excel 2003 and in earlier versions of Excel, click Options on the Tools menu, and then click the Calculation tab. Click the Calc Sheet button to calculate only the active sheet.

    In Excel 2007, click Calculate Sheet on the Formulas menu in the Calculation group."
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/643247

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice