A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pivot Table Formatting



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2009, 06:24 PM posted to microsoft.public.excel.misc
Nick Anderson
external usenet poster
 
Posts: 16
Default Pivot Table Formatting

I have a pivot table that I am trying to keep the formatting on. Everytime I
pivot the table, the formatting that I have set disappears. I have been
online and have read numerous ideas on how to get this to work but none seem
to work the way I need them to.

I have the auto format option and the perserve formatting boxes checked.
Does anyone have any ideas on how to keep the formatting?

Your help is appreaciated,

Thanks
Nick
  #2  
Old November 17th, 2009, 06:24 AM posted to microsoft.public.excel.misc
Sean Timmons
external usenet poster
 
Posts: 1,722
Default Pivot Table Formatting

You want autoformat UNchecked.

"Nick Anderson" wrote:

I have a pivot table that I am trying to keep the formatting on. Everytime I
pivot the table, the formatting that I have set disappears. I have been
online and have read numerous ideas on how to get this to work but none seem
to work the way I need them to.

I have the auto format option and the perserve formatting boxes checked.
Does anyone have any ideas on how to keep the formatting?

Your help is appreaciated,

Thanks
Nick

  #3  
Old November 17th, 2009, 06:50 AM posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
 
Posts: 2,641
Default Pivot Table Formatting

What type(s) of formats are you working with. Conditional Formats, borders
numeric, patterns...
--
HTH...

Jim Thomlinson


"Nick Anderson" wrote:

I have a pivot table that I am trying to keep the formatting on. Everytime I
pivot the table, the formatting that I have set disappears. I have been
online and have read numerous ideas on how to get this to work but none seem
to work the way I need them to.

I have the auto format option and the perserve formatting boxes checked.
Does anyone have any ideas on how to keep the formatting?

Your help is appreaciated,

Thanks
Nick

  #4  
Old November 17th, 2009, 02:48 PM posted to microsoft.public.excel.misc
Nick Anderson
external usenet poster
 
Posts: 16
Default Pivot Table Formatting

Hi Jim

I am working with column widths. That seems to be the big thing that changes
when I refresh.

Nick

"Jim Thomlinson" wrote:

What type(s) of formats are you working with. Conditional Formats, borders
numeric, patterns...
--
HTH...

Jim Thomlinson


"Nick Anderson" wrote:

I have a pivot table that I am trying to keep the formatting on. Everytime I
pivot the table, the formatting that I have set disappears. I have been
online and have read numerous ideas on how to get this to work but none seem
to work the way I need them to.

I have the auto format option and the perserve formatting boxes checked.
Does anyone have any ideas on how to keep the formatting?

Your help is appreaciated,

Thanks
Nick

  #5  
Old November 17th, 2009, 03:47 PM posted to microsoft.public.excel.misc
Ryan[_13_]
external usenet poster
 
Posts: 1
Default Pivot Table Formatting

On Nov 17, 8:48*am, Nick Anderson
wrote:
Hi Jim

I am working with column widths. That seems to be the big thing that changes
when I refresh.

Nick



"Jim Thomlinson" wrote:
What type(s) of formats are you working with. Conditional Formats, borders
numeric, patterns...
--
HTH...


Jim Thomlinson


"Nick Anderson" wrote:


I have a pivot table that I am trying to keep the formatting on. Everytime I
pivot the table, the formatting that I have set disappears. I have been
online and have read numerous ideas on how to get this to work but none seem
to work the way I need them to.


I have the auto format option and the perserve formatting boxes checked.
Does anyone have any ideas on how to keep the formatting?


Your help is appreaciated,


Thanks
Nick- Hide quoted text -


- Show quoted text -


I ran into a similar problem with my reports. The only solution that I
could find was to create a macro while I set up my formats. Then run
it each time I refresh.

Ryan
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.