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?

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

--
Regards,
Tom Ogilvy

"neeses" wrote in message
...
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?

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.
--
Estandardtime Realty


"Roger Govier" wrote:

Hi

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

Regards

Roger Govier


neeses wrote:
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?

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

--
Regards

Roger Govier


"Eleanor M" wrote in message
...
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.
--
Estandardtime Realty


"Roger Govier" wrote:

Hi

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

Regards

Roger Govier


neeses wrote:
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?

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

Best Regards,
EM
--
Estandardtime Realty


"Roger Govier" wrote:

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

--
Regards

Roger Govier


"Eleanor M" wrote in message
...
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.
--
Estandardtime Realty


"Roger Govier" wrote:

Hi

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

Regards

Roger Govier


neeses wrote:
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?

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.
--
Estandardtime Realty


"Roger Govier" wrote:

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

--
Regards

Roger Govier


"Eleanor M" wrote in message
...
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.
--
Estandardtime Realty


"Roger Govier" wrote:

Hi

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

Regards

Roger Govier


neeses wrote:
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?

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

--
Regards

Roger Govier


"Eleanor M" wrote in message
...
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.
--
Estandardtime Realty


"Roger Govier" wrote:

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

--
Regards

Roger Govier


"Eleanor M" wrote in message
...
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.
--
Estandardtime Realty


"Roger Govier" wrote:

Hi

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

Regards

Roger Govier


neeses wrote:
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?

Thank you Roger.

Best Regards,
EM
--
Estandardtime Realty


"Roger Govier" wrote:

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

--
Regards

Roger Govier


"Eleanor M" wrote in message
...
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.
--
Estandardtime Realty


"Roger Govier" wrote:

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

--
Regards

Roger Govier


"Eleanor M" wrote in message
...
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.
--
Estandardtime Realty


"Roger Govier" wrote:

Hi

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

Regards

Roger Govier


neeses wrote:
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?