Pivot tables missing fields from defined table

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

I have added a new column to a table and updated the table to include this
column. When I then go to create the pivot table this new column does not
appear in the fields to be selected

thanks
 
1) Click on your pivot table to activate it, you'll see the blue outline
around it.
2) Click the "!" on the pivot table toolbar.
3) click Pivot table dropdown button on the toolbar and choose wizard.
4) Now you can redefine the layout and source range (click "back" to
redefine source range if necessary".
 
Hi dfunk

I couldn't find the "!", but this might be due to the fact I am running on
excel 2007 ... but I actually found that I needed to "refresh" the data and
then it worked

thanks for getting back to me so quickly
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic data ranges in pivot tables 3
Pivot table grand total location 1
Pivot Table Options 'Fields per column' 1
date filter in a pivot table 1
Pivot Table - 3
Referencing a pivot tables Grand Totals Column 1
Excel 2003 Pivot Table Issues 3
Pivot Table Page Break Refresh Problem 0

Back
Top