ExcelBanter - PivotTable Nightmare

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - PivotTable Nightmare (https://www.excelbanter.com/excel-discussion-misc-queries/104902-re-pivottable-nightmare.html)

MarkM

PivotTable Nightmare

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

Sandi

PivotTable Nightmare

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

All times are GMT +1. The time now is 03:39 AM.