[mso] Re: Excel (2000, 2003) Formatting Pivot Table Sheets

 
Thanks you Andrew, by the way do you know or someone else know how to clean
the filters in a pivot table, I mean when I have entries in a pivot table
andlater they don't exist anymore in the data origin, I still have those
entries in the pivot table filters. 

  

Best regards 

  

Alex

>From: "Andrew Kendon" <andrewkendon@xxxxxxxxxxxxxxxxxxxxxxxxx> >Reply-To:
mso@xxxxxxxxxxxxx >To: "Mso@Freelists. Org" <mso@xxxxxxxxxxxxx> >Subject:
[mso] Re: Excel (2000, 2003) Formatting Pivot Table Sheets >Date: Tue, 25
Jan2005 10:41:46 -0000 >>Thank you Alex, for pointing me in the right
direction.  The solution >appears to be to leave the Preserve Format box
checked but to uncheck the >Autoformat Table option. >>This is still not
quite how I'd like it, in that, when refreshing the Pivot >Table, any new
entries which exceed the cell width don't widen the cell to >accommodate the
data.  Nothing is perfect, however <grin>. >>Andrew >>-----Original
Message----- >From: Andrew Kendon
[mailto:andrewkendon@xxxxxxxxxxxxxxxxxxxxxxxxx] >Sent: 24 January 2005 16:50
>To: mso@xxxxxxxxxxxxx >Subject: RE: [mso] Re: Excel (2000, 2003) Formatting
Pivot Table Sheets >>>Thanks, Alex >>Unfortunately this does not solve the
problem.  The Preserve Format box is >already checked.  It seems to apply to
cell formatting rather than column >formatting - if I uncheck it, all the
cell formatting (Font and Number >formatting) reverts to default.
>>-----Original Message----- >From: mso-bounce@xxxxxxxxxxxxx
[mailto:mso-bounce@xxxxxxxxxxxxx]On >Behalf Of Alejandro Velazquez >Sent: 24
January 2005 16:18 >To: mso@xxxxxxxxxxxxx >Subject: [mso] Re: Excel (2000,
2003) Formatting Pivot Table Sheets >>>>Hi Andrew, >>>>In the Pivot Table
menu, there is an option that says "Table Options" or >"Pivot Table Options"
once there, there is a part that says Format Options, >check the "keep
format" option. >>Hope this solve your problem. >>Regards
>>>************************************************************* >You are
receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx >>To send mail to the group, simply address
it to mso@xxxxxxxxxxxxx >>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line. >>Or, visit the group's homepage and use the dropdown
menu.  This will also allow you to change your email settings to digest or
vacation (no mail). >http://www.freelists.org/webpage/mso >>To be able to
usethe files section for sharing files with the group, send a request to
mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions.  Once you are a member of the files group, you can go here to
upload/download files: >http://www.smartgroups.com/vault/msofiles
>************************************************************* 

----------------------------------------------------------------------------
T1msn Search. Todo lo que buscas ahora más rápido Haz clic aquí [1]

--- Links ---
   1 http://g.msn.com/8HMAESMX/2728??PS=47575
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: