+ Reply to Thread
Results 1 to 2 of 2

tips/techniques on how to speed up pivot table calculations

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    tips/techniques on how to speed up pivot table calculations

    Hello everyone, I'm relatively new to pivot tables. I'm pretty sure this same topic has been posted before, but I was wondering if anyone could share to me the techniques and foundation of properly utilizing a pivot table. Currently I have a very large data set and my pivot table keeps on crashing every time I make changes from my slicers.

  2. #2
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: tips/techniques on how to speed up pivot table calculations

    In addition, would utilizing power pivot for the large data set be more efficient or help speed up the large data set and calculated items?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy Paste Formulas - Any Speed Tips?
    By killerkoz17 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 02-23-2014, 07:40 AM
  2. Want to learn Excel tips and techniques !
    By cena_thechamp in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-01-2013, 07:58 AM
  3. Techniques too speed up code
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 02:46 AM
  4. Replies: 0
    Last Post: 08-04-2006, 04:30 AM
  5. Tips for Minimizing size of Pivot Table workbooks
    By shadestreet in forum Excel General
    Replies: 1
    Last Post: 04-19-2006, 04:30 PM

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