Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot table - formula help

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have created a pivot table, and I have about different formulas within in.

    Sometimes when I create a formula within the pivot table it doesn't actually put it in the table, yet when I go back into the 'Insert Calculated Field' section the formula is there - so why is it not putting it in the pivot table?

    It's happening every now and again, and it's very frustrating !!!

    Thanks in advance for your help !!!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You may need to refresh the pivot table. If you right click on it, then choose Refresh it takes into account all the changes

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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