PivotTable Nightmare

Everytime I refresh my pivot table it keeps dropping part of information on
my spreadsheet. I have a list of agencies in alphabetical order and each
time I refresh it will drop letters U-Z. I have had to recreate the pivot
table numerous times to fix the problem. Any help would be appreciated.
Sandi Gardner

Kind of hard to diagnose with limited info. If you refresh and lose U-Z and
then right-click on the pivot table and choose Pivottable wizard / Back,
what range do you see selected? Is it all your data? If not then how does
your data get selected, ie is it by any chance a dynamic range formula?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Sandi" wrote in message
...
Everytime I refresh my pivot table it keeps dropping part of information
on
my spreadsheet. I have a list of agencies in alphabetical order and each
time I refresh it will drop letters U-Z. I have had to recreate the
pivot
table numerous times to fix the problem. Any help would be appreciated.
Sandi Gardner

Are these page fields? If so, could the last few letters be hidden?


"Sandi" wrote:

Everytime I refresh my pivot table it keeps dropping part of information on
my spreadsheet. I have a list of agencies in alphabetical order and each
time I refresh it will drop letters U-Z. I have had to recreate the pivot
table numerous times to fix the problem. Any help would be appreciated.
Sandi Gardner

I go in and select my range when I start the wizard. I don't understand how
it can keep dropping when I refresh. What is a dynamic range formula?
--
Sandi Gardner


"Ken Wright" wrote:

Kind of hard to diagnose with limited info. If you refresh and lose U-Z and
then right-click on the pivot table and choose Pivottable wizard / Back,
what range do you see selected? Is it all your data? If not then how does
your data get selected, ie is it by any chance a dynamic range formula?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------



"Sandi" wrote in message
...
Everytime I refresh my pivot table it keeps dropping part of information
on
my spreadsheet. I have a list of agencies in alphabetical order and each
time I refresh it will drop letters U-Z. I have had to recreate the
pivot
table numerous times to fix the problem. Any help would be appreciated.
Sandi Gardner

No - Nothing is hidden in the worksheet at all.
--
Sandi Gardner


"MarkM" wrote:

Are these page fields? If so, could the last few letters be hidden?


"Sandi" wrote:

Everytime I refresh my pivot table it keeps dropping part of information on
my spreadsheet. I have a list of agencies in alphabetical order and each
time I refresh it will drop letters U-Z. I have had to recreate the pivot
table numerous times to fix the problem. Any help would be appreciated.
Sandi Gardner

Maybe you're adding rows of data on the worksheet, then sorting the rows
alphabetically. The pivot table may continue to use the cells that you
originally selected, when you first created the pivot table, ignoring
all the additional rows, where the U-Z entries now appear.

To expand the range automatically, you can use a dynamic range, as
described he

http://www.contextures.com/xlPivot01.html

Sandi wrote:
I go in and select my range when I start the wizard. I don't understand how
it can keep dropping when I refresh. What is a dynamic range formula?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html