Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Neily
 
Posts: n/a
Default Pivot Tables and Formatting

Hi,

Could anyone explain the Pivot Table options Format Report and Preserve
Formatting and how they affect any formats you put on a pivot tables.

I have a pivot table which is refreshed every day. It has Row, Column and
Page selections but the formatting I apply changes after refreshes.

Has anyone tamed the Pivot Table Beast and could point me in the right
direction?

Ta...

Neily
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

In some versions of Excel, you may have to enable selection (From the
Pivot toolbar, choose PivotTableSelect, 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.


Neily wrote:
Hi,

Could anyone explain the Pivot Table options Format Report and Preserve
Formatting and how they affect any formats you put on a pivot tables.

I have a pivot table which is refreshed every day. It has Row, Column and
Page selections but the formatting I apply changes after refreshes.

Has anyone tamed the Pivot Table Beast and could point me in the right
direction?

Ta...

Neily



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

  #3   Report Post  
Neily
 
Posts: n/a
Default

Cheers Debra,

I found the black arrow thing and thought I had conquered it, but it started
to misbehave. I'll try the other thing from the Pivot Tabe menu.

Ta.

"Debra Dalgleish" wrote:

In some versions of Excel, you may have to enable selection (From the
Pivot toolbar, choose PivotTableSelect, 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.


Neily wrote:
Hi,

Could anyone explain the Pivot Table options Format Report and Preserve
Formatting and how they affect any formats you put on a pivot tables.

I have a pivot table which is refreshed every day. It has Row, Column and
Page selections but the formatting I apply changes after refreshes.

Has anyone tamed the Pivot Table Beast and could point me in the right
direction?

Ta...

Neily



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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Formatting Phil vK Excel Discussion (Misc queries) 1 May 22nd 05 03:09 PM
Using Date Grouping in Pivot Tables RaoulDuke Excel Discussion (Misc queries) 1 May 9th 05 07:04 AM
Pivot Tables lose some formatting when Updated Jugglertwo Excel Discussion (Misc queries) 1 March 23rd 05 01:48 AM
Problem with times in pivot tables and graphs [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 07:59 AM
Loosing My Pivot Tables during SAVE AS LostintheJungle Excel Discussion (Misc queries) 1 February 16th 05 07:41 PM


All times are GMT +1. The time now is 05:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"