Pivot table question

S

steveL

New Member
Joined
Jul 25, 2006
Messages
4
I am refreshing a pivot table from a newly populated named range. Why do old descriptions of OLD data hang around? :devilish: :devilish:

Is there a command that will get rid of these?

I've used the refresh method but the the old description are still there..... could this be an Excel bug? I'm using Excel 2002

Thanks! :p

Stepehn
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
I have seen this in Pivot tables too. Found this code to get rid of the old phantom data.
Code: 
Sub Clean_Pivots()
for each pt in activesheet.pivottables
 pt.pivotcache.missingitemslimit = xlmissingitemsnone
next
end sub
 
Upvote 0
...Why do old descriptions of OLD data hang around?
Click to expand...

Because they're in the domain of PivotField. They're retained so a fixed-dimension PivotTable (with "Show items with no data" checked) can be created; thus, preventing a pre-configured GETPIVOTDATA function from returning #REF! when the data changes.
 
Upvote 0
John,

Thanks for the reply and isn't the internet GREAT!

Your code worked just as is and problem solved.

Thanks!

Stephen
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Question
Excel table To split or not to split??
Replies
5
Views
283
Fluff
Fluff
R
  • Question
Restack Pivot Table question
Replies
9
Views
287
twinetwstr
twinetwstr
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
O
  • Question
Running through a Config and pulling out the relevant information using keywords into smaller sheets
Replies
0
Views
132
oitbc
O
T
  • Question
Display Refresh Date Pivot Table Online
Replies
0
Views
695
tboneotter
T

Forum statistics

Threads
1,214,797
Messages
6,121,629
Members
449,041
Latest member
Postman24

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top