Pivot Table refresh

[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?

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"neeses" <neeses@discussions.microsoft.com> wrote in message
news:C931DD0D-DDA6-4DA5-B5B8-72AF328BC8AD@microsoft.com...
> 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?

[Roger Govier]

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?

[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.
--
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?
>

[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

--
Regards

Roger Govier


"Eleanor M" <vise@viaccess.net> wrote in message
news:92E7820A-918C-41AF-A6C3-0DC1239B4149@microsoft.com...
> 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?
>>

[Eleanor M]

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" <vise@viaccess.net> wrote in message
> news:92E7820A-918C-41AF-A6C3-0DC1239B4149@microsoft.com...
> > 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?
> >>
>
>
>

[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.
--
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" <vise@viaccess.net> wrote in message
> news:92E7820A-918C-41AF-A6C3-0DC1239B4149@microsoft.com...
> > 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?
> >>
>
>
>

[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

--
Regards

Roger Govier


"Eleanor M" <vise@viaccess.net> wrote in message
news:E1CC064A-CB56-4317-9BB2-8DA2848B2031@microsoft.com...
> 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" <vise@viaccess.net> wrote in message
>> news:92E7820A-918C-41AF-A6C3-0DC1239B4149@microsoft.com...
>> > 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?
>> >>
>>
>>
>>