pivot table changes when data is refreshed.

I have a pivot table with grouping based on a field called "period
which is of date type. I have grouped it into months and quarters
However when i refresh the pivot table whenever the data (which is in 
seperate sheet) is changed, the groupings are going out. I want t
preserve the groupings as they are like a template. How do i stop th
changing the format  and layout of the pivot table whenever i refres
the data? any ideas? please help.

~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

11/26/2003 7:02:29 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 21

Intentionally or otherwise, XL does not retain all of the custom 
formatting applied to a PivotTable.  Two documented examples are:

XL2000: PivotTable Does Not Preserve Conditional Formatting

XL97: Formatting Not Retained in PivotTable

You might find more information by searching the MSKB.

[Posted directly to the Usenet newsgroup -- no affiliation with 


Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <isskiran.xim2a@excelforum-nospam.com>, 
isskiran.xim2a@excelforum-nospam.com says...
> Hi, 
> I have a pivot table with grouping based on a field called "period"
> which is of date type. I have grouped it into months and quarters.
> However when i refresh the pivot table whenever the data (which is in a
> seperate sheet) is changed, the groupings are going out. I want to
> preserve the groupings as they are like a template. How do i stop the
> changing the format  and layout of the pivot table whenever i refresh
> the data? any ideas? please help.
> regards
> Kiran:mad:
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
11/30/2003 2:09:49 PM

Similar Artilces:

Displaying hidden data on a chart
I have a number of data series in a table on sheet 1, and this data is plotted as an x-y scatter in a chart on sheet 2. I want to hide a column in the table, but when i do this the related data series disappears from the chart. Is there a way to hide a column whilst still having it plotted on the chart? At the moment I have just set the column width to 1 pixel, which is a bit messy. Thanks Hi, Yes, select the chart and then via the menu Toosl > Options > Chart. unchecked the Plot visible cells only. Cheers Andy Nick Terry wrote: > I have a number of data series in a tabl...

Secure deletion of data from Exchange server networks.
I would like to completely eradicate messages from my exchange server network. When I say eradicate i don't mean detonating my servers and melting them down for scrap or running 'Boot & Nuke' disks but i want at the very least to overwrite the clusters on which the data was stored so as to prevent recovery of the data without examination of the disk platters. This as far as I know, would require: Deleting messages from the server message store. Deleting entries from the server logs. Deleting messages from the client .ost file. Deleting entries from client logs. Running a...

CRM E-mail editor
Hello, When you are in a client record in CRM and click the 'Send E-Mail' button to send them an email, is there any way to get this to open in Outlook? My colleague has asked as there is no spell checker in the editor and his signature is not attached etc. Thanks, Katherine ...

Excel 2007 Pivot Table Question
Is there any programming way to change data sources within a Pivot Table, we need to switch from a UNC to a drive letter? Thanks in advance ...

Value filter missing in pivot table
I have a spreadsheet that totals sales and commisions based upon a date range. Basically I've got two worksheets. One with the raw data, and another with the pivot table based upon the raw data. I've been unable to validate my totals as compared to other established reports. After digging into the report, I see that I'm missing 1 specific sales associate's data in my pivot table. I can clearly see a lot of data for this associate in the raw data sheet. While in the pivot table, I can go to the row label, and value filter, but this one sales associate is not ...

Purge trailing space in a table
Below does not purge trailing space in a table:- Fred Smith trailing space (no merge cells and anywhere in table rows) What vba do tables require to clean up properly please? Many thanks. Sub Purge_Trailing_Space() Dim s As String With ActiveDocument If Len(.Range) = 1 Then Exit Sub s = .Characters.Last.Previous While s = " " Or s = Chr(13) Or s = Chr(11) .Characters.Last.Previous = "" s = .Characters.Last.Previous Wend End With End Sub Hi Janine, That code does not relate to tables per se, but to a document generally. In part...

Dots running across table. Help!
I've created a table with one row and one column, but later I added a second row. When I added text to the second row, suddenly the last row moved to the next page, even though Print Preview showed that there was enough room for the row and text. When I tried to move that row back to its original position, I notice black dots on either side of the table, which act like a page break. I can't get the row and text back to its original page. What do I do? What's going on? Is there a way to get rid of the dotted lines so that I can place the last row with the rest of ...

Code to select data
Hi - I am using v2007 and want to know code for selecting from row 2 to the end of populated data in a spreadsheet. The length of the data will vary everytime. Any help gratefully nreceived. Thanks. Anita Assuming you mean you want to select entire rows, give this a try... Dim LastRow As Long LastRow = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlRows, _ SearchDirection:=xlPrevious, LookIn:=xlFormulas).Row If LastRow > 1 Then Range("2:" & LastRow).Select -- Rick (MVP - Excel) "Anita" <Anita@discussions.m...

Linking to an Excel Pivot Table
Does anyone know how to break the link between an Excel pivot table that uses Access as it's data source without recreating the pivot table? It links to a network drive at work, I need to relink to my local drive but it keeps looking for my "m" drive on my network at work. ...

Data in columns
Good afternoon, In Access 2007, I have a table that looks like this: EquipID Text (5) ChackDate Date UserID Text(2) Check1 Y/N Check2 Y/N Check3 Y/N Obs Text (255) .... I need a report that looks like this: 01/01/2007 Equipment A1 A2 A3 User MF FO MF Bolts secured Y N Y Instruction Manual Y Y N Packaging ...

Cannot change Gantt ownership to a user with Deny on New Project
Hi, Our system is Project Server 2007 with SP2. For a division with a PMO department – all project managers can edit Gantts and create new Gantts. We want to change it so that only project managers which are PMO members can create Gantts. The PMO members will create the Gantts, change ownership to the rest of the project managers, and the project managers will continue from there. The change is to deny the single permission of creating a new Gantt from the project managers, which are not PMO members. I don’t want to create two separate and almost identical project mangers ...

Un-linked table.
Is it possible to have a text box or combo box in a form that has information in it from a table that is not linked to any other tables?? On Thu, 2 Aug 2007 13:16:03 -0700, tflett <tflett@discussions.microsoft.com> wrote: >Is it possible to have a text box or combo box in a form that has information >in it from a table that is not linked to any other tables?? Yes. Why do you ask? John W. Vinson [MVP] ...

Change IP address of exchange server
Hi , Thought this would be an easy question to get an answer to, but had no luck with my searches... I need to change the ip address of my exchange server, but want to make sure that won't screw anything up... I thought that its ok to do that, but because the server is also a dc I want to make sure. Thanks for any help on this. Art -- Art Feel free to change the address. While possibly not required, I'd recommend rebooting afterward. Make sure that there are no hardcoded host files or WINS or DNS entries for the server. After the change, clients might not be able to connect fo...

Extra Spaces with copied data
I recently had to copy a large amount of data from my company's website. When I copied it over to Excel all cells had trailing spaces, 5 spaces to be exact. What I need to know is how do I sweep through and get rid of all those extra spaces. They are interferring with calculations and sorting of numbers. Thanks for all your help. -- shane24 ------------------------------------------------------------------------ shane24's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4770 View this thread: http://www.excelforum.com/showthread.php?threadid=490089 Tr...

Bar data not displaying
I am trying to create a bar chart that refers to a set of cells which are calculating the remaining time after subtracting the differences between beginning and end times from a static time value (1:15) using the following formula: =IF(AND(COUNT(D9:DL9)<>0,COUNT(D9:DL9)=COUNT(D8:DL8)),$B$2-(SUM(D9:DL9)-SUM(D8:DL8)),B2) The B2 cell refers to the static time of 1:15 that is formated as h:mm. If there is no start and end time values in the range and therefore the cell is assigned a IF-FALSE value of 1:15, when the bar chart is created there is no bar value displayed in the chart. If...

Adding information from a form into a table
After data is entered into a form how can I add it to an existing table? If it's a bound form (the norm), you don't have to do anything. Forms are intended to be "windows" to tables. A bound form will automatically write its data to the table when the current row loses focus. If it's an unbound form, you have to add the data yourself, either using a SQL INSERT INTO statement, or using VBA and a recordset. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "carrie" <carrie@discussions.microsoft.com> wrote in message ...

Auto-Forward Rule Changes Sender to Me
I work part-time at a college that just upgraded to Exchange. With their old mail system, I set up a rule to auto-forward all my mail to my main POP account, which I monitor using Outlook. With Exchange, the auto-forwarding rule changes the sender to my email address. This means that when I hit reply, the response gets sent to me. This is not what I want. The school help desk people tell me that's the way it is and they can't do anything about it. This seems like such a common situation that someone would have developed a fix for it. If anyone is familiar with this situation, I ...

How to get data from Yahoo calender ?
Hello all, I am developing an application in VC++/MFC to fetch the data from the Yahoo calender. I searched the Yahoo developers site but i am not getting any clue that from where to start. Can anybody tell me that how to start? Means suppose i would have user's Yahoo ID and Pswrd then which URL should i call so that i will get the Yahoo Calender data(Events in it etc.) Thx in Advance... Rohit ...

Change Permissions
I have changed some of the user roles and permissions in my Exchange 5.5 Administrator, however the permissions do not take effect until I stop and restart the Exchange services or reboot the machine. Does anyone know a solution for this? In the past this has not been a problem and the changes became immediate. Thanx From what you describe, I suspect you are falling foul of the 2 hour cached permissions issue. See the KB article link below. Note that the article only references the Primary NT Account - it applies to all permissions, though. http://support.microsoft.com/?id=179065 --...

How can I change word spacing in an entire document at once
here is what my word docs do.... They may be looking at the same thing, but they each h ave very different interests. Jenny is studying it closely. She is telling herself that her interest is academic, but that might n ot be the whole story here is what it should look like: thirty five years old with sandy hair that just might be starting to thin at the back and a waist that is just a bit thicker than he would like I want to fix the entire doc at once It looks like you're saying you want to replace one text with an entirely differen...

Microsoft CRM Data Migration Framework could not initialize
Hi, I've got CRM 3.0 installed with roll-ups. I've installed the DMF so I can import a large number of records but each time I try to start it up I get the above error. The detailed information says :- * The Microsoft CRM Server is not responding. A WhoAmI() call did not succeed. * SOAP Server Application Faulted Nothing is showing in the event logs and I've checked that the IIS service is working correctly and the databases is also contactable. I'm not sure how to go about troubleshooting the problem because I can't see how I can trace what its doing. I've ...

Delete based on another table
I can SELECT but I cannot DELETE as follows. DELETE Transcript.*, Transcript.SEM FROM Transcript INNER JOIN YYYYFx ON Transcript.YYYY = YYYYFx.YYYY WHERE (((Transcript.SEM)="3")); "Song Su" <csitnnn@hotmail.com> wrote in message news:OI0xTTSYIHA.5472@TK2MSFTNGP06.phx.gbl... >I can SELECT but I cannot DELETE as follows. > > DELETE Transcript.*, Transcript.SEM > FROM Transcript INNER JOIN YYYYFx ON Transcript.YYYY = YYYYFx.YYYY > WHERE (((Transcript.SEM)="3")); > > In the query design right-click and bring up the query's propert...

Usage data
I am interested in developing an application that monitors data usage. For example, I need to know how many rows that a user accesses from specific tables; maybe also, what columns they access. This data should probably be gathered at the data-access layer because it would be more certain and not make me rely on having to parse ad-hoc queries. Does SQL provide any sort of monitoring tool that can give this data? Suggestions? Thanks, Howard SQL 2008 has a lot of features and built in reports... also maybe performance dash board? (It's a seperate installation package) ...

change opportunity step name filed to custom entry??
we want to remove the workflow process from our opportunity section. to do this we would like to have the step name field being fed by a custom field that i created, and currently being used by the sales staff. any ideas?? crm 3.0 on server 2003 sp2 --- news://freenews.netfront.net/ - complaints: news@netfront.net --- ...

Changing case #4
Is there a way to change case for several cells. In Word, you go to Format, Change case, and then you select all upperlower, lower, Title, etc. Does anyone know if there is a way to do this with Excel 2000? Hi Sandra In Excel you need a macro if you want to change case in the same cell See this webpages http://www.mvps.org/dmcritchie/excel/proper.htm Or http://www.cpearson.com/excel/case.htm Here are three macro's for changing text cells in the selection Sub Uppercase_macro() Dim selectie As Range Dim cel As Range On Error Resume Next Set selectie = Range(ActiveCell.Address &am...