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