Pivot table problem
I have created a Pivot Table with peoples names and different information associated with each. Every month that information changes along with the people on the report, my problem is that when i replace the source information and refresh the information on the chart the Individual keeps all the old names in the tab but it updates the infoon the sheet. What do i do to change that? -- seantera ------------------------------------------------------------------------ seantera's Profile: http://www.excelforum.com/member.php...o&userid=27294 View this thread: http://www.excelforum.com/showthread...hreadid=505335 |
Pivot table problem
There's information here on clearing old items in a pivot table:
http://www.contextures.com/xlPivot04.html seantera wrote: I have created a Pivot Table with peoples names and different information associated with each. Every month that information changes along with the people on the report, my problem is that when i replace the source information and refresh the information on the chart the Individual keeps all the old names in the tab but it updates the infoon the sheet. What do i do to change that? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 06:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com