Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table
hi
I am using Office 2007. I have created a pivot table using an excel worksheet e.g. the pivot table range is A1-Y1000. Recently i have added a new column but the pivot table is still reading A1-Y1000 instead of A1-Z1000. How can i revise the range to include the new column. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table
In your Pivottable tools you have a change data source in your data tab,
click on that and then reselect your info. hope that helps "Tiffany" wrote: hi I am using Office 2007. I have created a pivot table using an excel worksheet e.g. the pivot table range is A1-Y1000. Recently i have added a new column but the pivot table is still reading A1-Y1000 instead of A1-Z1000. How can i revise the range to include the new column. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |