Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Turning off calculation on a single sheet

  1. #1
    Join Date
    18th January 2005
    Posts
    19

    Turning off calculation on a single sheet

    I have a workbook that contains a seperate sheet for the database. This database contains between 3 and 6 weeks of data depending on how much is inserted each week (varies between users of the workbook). The total number of rows will reach the maximum of 65536, causing a long time to calculate when saving, opening, or doing pretty uch anything. There are a great deal of formulas and pivot tables that need to relate to this data, but once the new data is inserted, the database doesn't change. I'm after a way to permanently turn off the calculation of this sheet so that things work a little faster.

    I've tried placing the database in a seperate file and writing the code to open, insert, save, and close the database. trouble is that I've got some DSUM and DAVERAGE formulas that need the file to be opened before they'll refresh.

    Any help will be much appreciated

    Gareth

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    8th September 2004
    Location
    Northampton, England
    Posts
    2,746

    Re: Turning off calculation on a single sheet

    Gareth,

    The VBA statement
    VB:
    activesheet.enablecalculation = False 
    
    
    will turn off calculation on the active worksheet.

    Hope this helps.

    Regards,
    Batman.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Turning Off Calculation
    By Reafidy in forum Non Confidential Showcase
    Replies: 1
    Last Post: May 29th, 2008, 12:18
  2. Turning off ScreenUpdaint/Calculation
    By JMAN in forum EXCEL HELP
    Replies: 4
    Last Post: March 22nd, 2006, 04:45
  3. Manual Calculation on a single row
    By Yoman in forum EXCEL HELP
    Replies: 1
    Last Post: November 10th, 2005, 23:03
  4. Turning an xls sheet into a calendar
    By excel_for_fun in forum EXCEL HELP
    Replies: 1
    Last Post: February 14th, 2005, 05:31
  5. Replies: 1
    Last Post: November 19th, 2004, 19:29

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
  •  
porno