Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table problem | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problem | Excel Worksheet Functions |