Basic: Pivot Table formats

Hello:
This is driving me crazy. My pivot table formatting is lost any time I move
a field or change the selection. FOr example, the word wrapping goes away.

Also, what is the char limit for a pivot cell. My text is getting truncated.

Appreciate it.

Germaine

In some versions of Excel, you may have to enable selection (From the
Pivot toolbar, choose PivotTable>Select, and click on Enable Selection)

Before formatting cells, use the selection feature to select the cells.
For example, move the pointer to the top of a column in the pivot table
(just above the column's heading cell). When the black arrow appears
(like the one that appears when the pointer is over a column button),
click to select the column in the pivot table. Then apply the formatting.

If that doesn't work, you could record a macro as you refresh and
reformat the pivot table. Then, run that when you want to update.

The character limit for a cell in a pivot table is 255.

Bettergains wrote:
> Hello:
> This is driving me crazy. My pivot table formatting is lost any time I move
> a field or change the selection. FOr example, the word wrapping goes away.
>
> Also, what is the char limit for a pivot cell. My text is getting truncated.
>
> Appreciate it.
>
> Germaine


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks, Debra. I'm running Xls '03 on Windows XP, if that helps anyone. I'll
give this a try. I guessed that 255 was the limit, and w/o having counted, I
don't think I'm up to that limit before the truncation is occurring, but I'll
take a closer look.

Regards, Germaine

"Debra Dalgleish" wrote:

> In some versions of Excel, you may have to enable selection (From the
> Pivot toolbar, choose PivotTable>Select, and click on Enable Selection)
>
> Before formatting cells, use the selection feature to select the cells.
> For example, move the pointer to the top of a column in the pivot table
> (just above the column's heading cell). When the black arrow appears
> (like the one that appears when the pointer is over a column button),
> click to select the column in the pivot table. Then apply the formatting.
>
> If that doesn't work, you could record a macro as you refresh and
> reformat the pivot table. Then, run that when you want to update.
>
> The character limit for a cell in a pivot table is 255.
>
> Bettergains wrote:
> > Hello:
> > This is driving me crazy. My pivot table formatting is lost any time I move
> > a field or change the selection. FOr example, the word wrapping goes away.
> >
> > Also, what is the char limit for a pivot cell. My text is getting truncated.
> >
> > Appreciate it.
> >
> > Germaine
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Another thing to check -- Right-click on a cell in the pivot table, and
choose Table Options
Make sure there's a check mark for Preserve Formatting

Bettergains wrote:
> Thanks, Debra. I'm running Xls '03 on Windows XP, if that helps anyone. I'll
> give this a try. I guessed that 255 was the limit, and w/o having counted, I
> don't think I'm up to that limit before the truncation is occurring, but I'll
> take a closer look.
>
> Regards, Germaine
>
> "Debra Dalgleish" wrote:
>
>
>>In some versions of Excel, you may have to enable selection (From the
>>Pivot toolbar, choose PivotTable>Select, and click on Enable Selection)
>>
>>Before formatting cells, use the selection feature to select the cells.
>>For example, move the pointer to the top of a column in the pivot table
>>(just above the column's heading cell). When the black arrow appears
>>(like the one that appears when the pointer is over a column button),
>>click to select the column in the pivot table. Then apply the formatting.
>>
>>If that doesn't work, you could record a macro as you refresh and
>>reformat the pivot table. Then, run that when you want to update.
>>
>>The character limit for a cell in a pivot table is 255.
>>
>>Bettergains wrote:
>>
>>>Hello:
>>>This is driving me crazy. My pivot table formatting is lost any time I move
>>>a field or change the selection. FOr example, the word wrapping goes away.
>>>
>>>Also, what is the char limit for a pivot cell. My text is getting truncated.
>>>
>>>Appreciate it.
>>>
>>>Germaine
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html