Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

Excel 2007

I have large DATA TAB - 25 0000 records and every time I click from one to another tab (I have 8 Pivots on that worksheet)
the "Calculating PivotTable Reports" shows and it does the spinning circle.
Can't turn it off with Options, doesn't work.
Any ideas?
0
CABRLU63
Asked:
CABRLU63
1 Solution
 
Haris DjulicCommented:
Try switching to Manual Calculations or Automatic exept data tables... You can find that option under File->Options->Formulas-<Calculation options
0
 
CABRLU63Author Commented:
Thanks, issue fixed.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now