Results 1 to 3 of 3

Thread: Pivot table won't recalculate

  1. #1

    Pivot table won't recalculate



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to troubleshoot a pivot table a colleague uses. The pivot table is currently 20,000 rows and is added to monthly. When the most recent month was added the pivot table wouldn't recalculate to include that data. I have checked the data range which was correct, formatted the data as a table and used the table as a range and checked all the field settings to ensure the pivot table is filtered correctly.

    I can recreate the pivot table from the data and pull in the entire range, however as there are multiple calculated ranges my colleague doesn't want to do this every month.

    Any suggestions?

    Thanks in advance

  2. #2
    Well I solved my own problem. The new data was corrupted. The pivot table was actually recalculating but there was no data to bring forth with the filtered criteria for the most current period. Guess that should have been the first thing I checked.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,209
    Articles
    57
    Blog Entries
    14
    It always seems like it should have been easy once you know what the problem was.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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