Can anyone help me please.
I have a pivot table that I formatted etc and now want to update the source data. I dont want to create a new pivot on the new data but use the existing pivot table with the new data.
Is there a way I can tell the pivot table which data to now look at ?
Many thanks for any help.
Mark
Select pivot table.
Pivot table tools > Options > Data > Change Source Data.
Use the dialog to expand and or extend the data source range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks