Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Temporarily Disable Pivot Tables (97 SR2)

    Greetings,

    I have a workbook which houses thousands of rows of data. This workbook also contains over a dozen pivot tables which rework the data.

    My problem is that whenever a small change is made to the workbook, the pivot tables automatically recalculate, a process which can take upwards of 15-45 minutes.

    Is it possible to temporarily disable the pivot tables so that they do not calculate until I ask them to? This is getting seriously annoying... <img src=/S/hairy.gif border=0 alt=hairy width=15 height=15> <img src=/S/aflame.gif border=0 alt=aflame width=15 height=15> Clicking on the 'design mode' icon has no effect. Any ideas?

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Temporarily Disable Pivot Tables (97 SR2)

    Drk,

    A Pivot Table should not spontaneously update, unless perhaps you have some code to trigger it, based on a Sheet_Change event perhaps ?

    Andrew

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

    Re: Temporarily Disable Pivot Tables (97 SR2)

    If the Pivot Tables are large and contain calc fields or calc items, would that impact the results? Drk, do you want to see if setting Tools, Options, Calculation to Manual and Recalc before Save speeds things up?
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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