Pivot Table refresh

N

neeses

Data has been removed from the worksheet that feeds the Pivot Table. After
Refesh the deleted field name still appears in the drop down list. How can
the field name be removed?
 
T

Tom Ogilvy

Unless you want to write a macro, delete the pivot table and create a new
one.
 
R

Roger Govier

Hi

Drag the field out of the PT, Refresh, then drag the filed back again.

Regards

Roger Govier
 
E

Eleanor M

Hi Roger,

I have the refresh problem with my pivot table too and I use sbe office
2003. I have dates in my column field and whenever I update the data on a
different page and go to the pivot table and refresh it does not add the new
dates I added.

Any suggestions would be greatly appreciated.
 
R

Roger Govier

Hi Eleanor

I just posted an answer to the other thread you have running in this
group.
In case you can't see it, I repeat it below.


With regard to grouping by Year and Month, they are not mutually
exclusive.
If you click on Year, you can also click on Month and both will stay
selected (as will ill Quarter, if you chose to select that as well)
The above only applies if you do have valid Excel dates in your source
data, not text values.

With regard to refreshing data, have you tried clicking the Refresh icon
on the PT toolbar. Its the Red exclamation mark.
If this doesn't include the data you have just added, then it is
probably because the range you defined for the Pivot Table does not
include the rows you have just added.
Create a Dynamic range for the Pivot Table instead.
Debra has excellent examples of how to do this at
http://www.contextures.com/xlPivot01.html
 
E

Eleanor M

Thanks for your suggestion. However, adjusting the pivot table range - how
to do this again?

Best Regards,
EM
 
E

Eleanor M

Thanks again. I forgot to check the box to notify me of responses so I will
ask the same question. How do I change the range for the pivot table?

Thanks.
 
R

Roger Govier

Hi Eleanor

First define your dynamic range (and I pointed you to a site with
excellent instruction on how to do this)
http://www.contextures.com/xlPivot01.html

Once the range is defined, and assuming it is called Data, then on your
Pivot Tables Toolbar, select the Pivot Table dropdown.
From that list select Pivot Table Wizard.
Click the back button and in the dialogue box replace the current range
that is entered there with
=Data
Click Finish
 
Top