Pivot table formatting changing after refresh

Every time I refresh my pivot table or change a page 
field, some of my custom formatting that I set up on my 
pivot table reverts back to the default look.

How would I keep it the same as my custom look?

Thanks,
Grant.
0
anonymous (74722)
8/30/2004 9:26:02 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
521 Views

Similar Articles

[PageSpeed] 7

Set the pivot table to preserve formatting:

--On the pivot toolbar, choose PivotTable>Table Options
--Add a check mark to 'Preserve formatting', click OK
--Remove the check mark from AutoFormat Table
--Click OK

Other things to try -- if they don't work, you could record a macro as
you refresh and reformat the pivot table. Then, run that when you want
to update.

--Instead of selecting the cells to format the numbers, right-click the
field button, and choose Field Settings. Click Number, and choose your
formatting options there.

--Before formatting cells, use the selection feature to cells.
     (Depending on your version of Excel, you may also have to
     enable selection. From the Pivot toolbar, choose PivotTable>Select,
     and click on Enable Selection)
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.



Grant wrote:
> Every time I refresh my pivot table or change a page 
> field, some of my custom formatting that I set up on my 
> pivot table reverts back to the default look.
> 
> How would I keep it the same as my custom look?
> 
> Thanks,
> Grant.


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

0
dsd1 (5911)
8/30/2004 10:05:24 PM
Reply:

Similar Artilces:

Table format
Hi When I run the code below I get "External table is not in the expected format" error at line rsData.Open sSQL, sConnect, adOpenForwardOnly, adLockReadOnly, adCmdText Option Explicit Public Sub SelectFromAccess() Dim rsData As ADODB.Recordset Dim sPath As String Dim sConnect As String Dim sSQL As String 'Clear the destination worksheet Sheets(1).UsedRange.Clear 'Get the database path (same as this workbook) sPath = ThisWorkbook.Path If Right$(sPath, 1) <> "\" Then sPath = sPath & "\" 'Create the connection s...

Word text copied into email loses formatting alignment
When copying a Word document (containing indented and numbered paragraphs and bullet points into an email, the left alignment of the document loses its justification. How can this be fixed? -- HK If the formatting is important, send the document as an attachment. You have no control over how the recipient sees the email. If you are concerned that the recipient might not have Word, use one of the free pdf converters to convert the document into a .pdf file. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my s...

Dynamics 7.0 tables in SQL server 2000
I need to know what should be the content of each of the tables with names starting with "GL" in SQL Server 2000 when using 7.0. Is there a reference that I can go to in Customersource that tells me this information? Thanks. -- Dave Christman System Developer There is an online reference: Tools >> Resource Descriptions >> Tables. Also there is a SDK avaailable on the Great Plains CD's. "Dave Christman" wrote: > I need to know what should be the content of each of the tables with names > starting with "GL" in SQL Server 2000 when...

Maintain formatting of sub project when inserted into master proje
I'm using Project 2007. I have a master project and have inserted some sub-projects into the master project. ('Link to project' was checked which is what I want.) I had applied formatting to the original sub-projects' gantt charts task bars e.g. sub-project1 task bars were green, sub-project2 task bars were red etc. I found that this formatting was lost after inserting the sub-projects into the master. The sub-projects assumed the formatting settings of the master. Is there a way to maintain sub-project formatting? Thanks -- FionaDM In article <000A42E...

Changes to the global template
Recently I had to start a new username because of some corrupted files. I was able to save my documents. However, everytime that I quit microsoft office a dialogue box appears and says: "Word cannot save changes to the global template because it was opened with read only access. Do you want to save the changes in a template with a different name?" Initially I tried to save it, because I was afraid that the changes to my document would not be saved. Now I click save, and the next dialogue box appears: "Microsoft Visual Basic" "Run-Time errror "5995" Word c...

Conditional Formatting Equation Question
Greetings, I am trying to get a Conditional Format to do something if there is "NO" entry in A2. Any ideas as to what this formula would look like? Any help would be appreciated. TIA -Minitman =A2="NO" or, if by "NO" entry, you mean a blank cell: =A2="" HTH Jason Atlanta, GA >-----Original Message----- >Greetings, > >I am trying to get a Conditional Format to do something if there is >"NO" entry in A2. > >Any ideas as to what this formula would look like? > >Any help would be appreciated. > >TIA >...

Tables/ queries question
I have a table for recording college attendances, some of the courses are at Campus 1 and some are held at Campus 2. I've got a field for course code, course anme and a check box to show if the student is at campus 1. When I enter the student ID number into the form, at the moment the name of the course comes up automatically in the text book, as I think it's reading the information from another database on the system. At the moment I've got a check box on the Form to enter manually into the table whether the student is at Campus 1 or Campus 2. What I wondered is if...

Creating an Excel table from Access
Hi, I have an Access database which I use to log downtime for systems. I have a requirement to produce a monthly report based on this data, however, this needs to be exported to excel in a specific format. Down the left side of the report need to go the names of the services, with the days (numerically like: 1, 2, 3 .. 29, 30 etc) across the top. Then I need to count the number of times each service was down on a give day, and insert that information into the necessary cell - so if intranet services had been down twice on 16th March, for example, there would be a 2 in column 16, whi...

Cannot insert explicit value for identity column in table x
Sql Server 2005 9.00.4035. We have a hub and spoke topology which includes 6 tables with identity columns. I need to add a new subscription to a new server (same version/sp). I took backup from another subscriber and restored to new server, ran snapshot, push subscription. To make sure a new record would replicate, I added a record at the publisher with the followig text: Insert into tblicimagefolder (imagefolder) values ('dummy') A conflict occurs with the following: This failure can be caused by a constraint violation. Cannot insert explicit value for identity c...

problem with pivot table
Hello all: I am trying to make a pivot table from my date. My data includes Names, Dates (which I formatted to month, "m" in the format cells option)and Amount due. In designing the pt, I have "Name" in the row field, "Date" in the columnn field and "Amount due" in the Data field. I want my data to be grouped as follows: Month 1 2 3 4 Name $100 $20 $30 $20 Instead I am getting more than 1 month column i.e. Month 1 1 2 2 2 3 Name $80 $20 $30 $20 Do you know why...

Payroll w/h tables
When can we expect new payroll withholding tables for Ohio? In December our gov announced a late year change repealing a prior payroll credit previously announced. We have been told that the withholding tables are not correct yet GP/Microsoft has not released new tables yet. When can these be expected since we are practically done with January now??? Thanks. According the information I have, there are no pending changes for OH. You may need to contact Support about this issue. -- Charles Allen, MVP "INC" wrote: > When can we expect new payroll withh...

Language change in outlook express
Hi, I cannot change th language to english in outlook express by defult it has French. please help me how to change in options. i check all my regional settings shows english(us) execpt in word and express. -- Nisha P nishkrish <nishkrish@discussions.microsoft.com> wrote: > I cannot change th language to english in outlook express by defult > it has French. Ask in an Outlook Express newsgroup. microsoft.public.outlookexpress.general -- Brian Tillman [MVP-Outlook] nishkrish Ask in the Outlook Express newsgroups Outlook Express with IE7 http://www.microsoft.com/co...

modify the Type of Field in a Table From another MDB through a Command button
Hello to all! I hope can help me. By technical questions that would be to me very long to explain, the following necessity arises to me: I need To modify the Type of Field in a Table From another MDB through a Command button. The field at issue would happen to be "Number" to "TEXT". Is this possible one? I wait for alternatives. Thanks in advance, and sorry for my poor english. Dreamer. - Hi Is it not possible to open the other database and simply open the table in design view and then change the field. It seems very complex to do the codeing what will most pro...

change direction of cursor after enter
In excel 2003, how do I change cause the cursor to go the next cell to the right, rather than to go to the cell below? Thank you! Tools > Options > Edit > Move selection after Enter > select Right. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk "duke" <jbrown2lt@msn.com> wrote in message news:9793815c-97dc-4894-9adc-f3c43d71c91d@i29g2000prf.googlegroups.com... > In excel 2003, how do I change cause the cursor to go the next cell to > the right,...

How-To: Last change date on row
When I set up a database I always include a last change date that auto updates every time any field in the record changes. Does anyone have a suggestion for how to achieve a similar function in a spreadsheet. i.e. put the current date/time in a field in the row whenever anything in the row changes? -- GGG ------------------------------------------------------------------------ GGG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29220 View this thread: http://www.excelforum.com/showthread.php?threadid=489447 GGG, For example, to put the last change date in...

Stop running sum(Over All) when customer change
Dear All I hv report based on tblTransaction which contains many customers with their transactions by date wise. I grouped report on CustomerID sub Group by Fromat(trnDate,”MMM-YY”) to get monthly transactions for each customer. I made calculated field to obtained closing balance with running sum over Group. I want to make the Running sum – over all but when customers is changing it must stop and start again, by default it will give running sum of all the customer, exactly this I don’t want. Any idea to stopped or make running sum based on customer when month is changing it ...

How to change labels on a chart from numbers to words?
Can Someone Please help me? I can't figure out how to change the labels on my chart in excel from numbers to words! I'm not sure which labels you want to change to words, but maybe Jon Peltier's charting tutorial will help you: http://www.peltiertech.com/Excel/ChartsHowTo/index.html Arin wrote: > Can Someone Please help me? I can't figure out how to change the labels on my > chart in excel from numbers to words! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html I suspect it's this page: http://peltiertech.com/...

conditional format #3
Fra: "Niels B�ge Egstrand" <nbenospam@djoef.dk> Emne: Re: Condition Formatting! Dato: 2. november 2004 11:55 is it possibel to opperate with 9 different collors in conditional format ? No, you get up to 3 formats under conditional formatting (plus the normal format). If you need more formats, you could use some event macro. "Niels B�ge Egstrand" wrote: > > Fra: "Niels B�ge Egstrand" <nbenospam@djoef.dk> > Emne: Re: Condition Formatting! > Dato: 2. november 2004 11:55 > > is it possibel to opperate with 9 different collors in...

save formats of percentage when copying a chart
How do I keep the percentage format of data on a chart when I copy/move the chart to another spreadsheet that does not have the original data in it? ...

Batch Number Changed
I recently upgraded GP from Ver. 8 to 10. few days back i notices that around 800 SOP orders transfered to One batch. This Batch was not existing before. system created the batch. How this could happen? i checked in the activity tracking table, no clues from there. ...

Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a user. my client want to know how to enable it. hope for your prompt action. -- Jeremy Ayaay Technical Specialist STRC Only works for SQL 2005. If you client wants to use a beta database server... "Jher" wrote: > I'm curious why are the Change Password Next Login, Enforce Password Policy > and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a > user. my client want to know how to enab...

display a number that is decimal degrees in Deg:min:sec format
How can I create a format to display a number that is in decimal degrees, in Degree:minute:second? See http://cpearson.com/excel/latlong.htm In article <DD958DEA-4DE1-4C80-80D5-D959F720E452@microsoft.com>, "Sterling" <Sterling@discussions.microsoft.com> wrote: > How can I create a format to display a number that is in decimal degrees, in > Degree:minute:second? ...

Help using Tables
Hi guys! I need some help. I have a table that has a percentage range. Like this. Less than 90% 0 90.0% 90.9% $ 2,625 91.0% 91.9% $ 3,413 92.0% 92.9% $ 4,200 93.0% 93.9% $ 4,988 94.0% 94.9% $ 5,775 95.0% 95.9% $ 6,563 96.0% 96.9% $ 7,350 97.0% 97.9% $ 8,138 98.0% 98.9% $ 8,925 99.0% 99.9% $ 9,713 100.0% 100.9% $ 10,500 101...

league table #4
Sorry peeps email is smurfsix@hotmail.com ...

change from SIZE ON DISK: 4:00kb
I am using publisher 2000. How can I can size on disk: 4:00KB into bigger number such as 16:00KB in "properties" menu. thank: nguyen You can't. The file size is what it is because of the content. Why do you want to change the file size? This won't help you to open it. If you are getting an error message, that's a different story. Are you running Norton Antivirus on your system? -- JoAnn Paules MVP Microsoft [Publisher] "nguyen" <anonymous@discussions.microsoft.com> wrote in message news:2b6401c4be29$c5da6f60$a301280a@phx.gbl... >I am using ...