+ Reply to Thread
Results 1 to 4 of 4

Small pivot crashes/not responding when adding a calculated item

  1. #1
    Registered User
    Join Date
    01-05-2021
    Location
    Cayman Islands
    MS-Off Ver
    Professional Plus 2013 64-bit
    Posts
    2

    Small pivot crashes/not responding when adding a calculated item

    Hi all!

    I'm hoping you can help m with a pivot issue I'm having......

    I have a very small workbook with two tabs (one with the source data and another for the pivot table).

    I would like to insert a calculated item for Income - Expenses, but when I try to add this my excel crashes and goes to Not Responding and I have to exit.

    Any help/workaround would be much appreciated!

    Thanks

    Millie
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    156

    Re: Small pivot crashes/not responding when adding a calculated item

    Hi

    I guess the reason for the crash is that you refer to the whole sheet for your pivot table!
    After I change the pivot table source to the range containing data, i can add the formula without issues.

    My tipp is to create a table for the raw data and use the table as source for the pivot table.

    good luck
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-05-2021
    Location
    Cayman Islands
    MS-Off Ver
    Professional Plus 2013 64-bit
    Posts
    2

    Re: Small pivot crashes/not responding when adding a calculated item

    Thanks so much for the tip, and that worked when I changed the source, but if I add more data to the source then the same issue occurs.

    Seems I can only add calculated items with very small source data.

  4. #4
    Forum Contributor
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    156

    Re: Small pivot crashes/not responding when adding a calculated item

    Hi
    i just added a new row in the DATA sheet, added some numbers in the month column and i do have no issues. I added in total 200 rows and have no issues
    What and where do you add new items to get a crash of xls again.

+ 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. Creating calculated field and calculated item into a pivot table
    By dvpe in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-12-2019, 12:15 PM
  2. Problem encountered when adding calculated item into pivot tabe
    By SUNNY ISLAND in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2016, 01:37 AM
  3. [SOLVED] Creating a formula in a pivot table while using another calculated item in the pivot
    By mvhs1073933 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2015, 12:44 PM
  4. Calculated Item in Pivot table
    By Centre13 in forum Excel General
    Replies: 5
    Last Post: 03-04-2014, 10:17 AM
  5. Adding a calculated item to a pivot table - problem encountered
    By Jimmy Newman in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-23-2012, 08:35 AM
  6. Need help with a calculated item in a pivot
    By thedon_1 in forum Excel General
    Replies: 2
    Last Post: 02-25-2012, 06:11 PM
  7. Replies: 3
    Last Post: 06-06-2006, 12:10 AM

Tags for this Thread

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