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

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