changes to pivot table labels

Hi
I have a pivot table that reads data from an OLAP cube, is it possible
to prevent users from changing the row labels
Regards, AQ
0
2/6/2012 8:44:28 AM
excel 39879 articles. 2 followers. Follow

0 Replies
411 Views

Similar Articles

[PageSpeed] 27

Reply:

Similar Artilces:

How do I change the default color of the tag for insert c... #2
This issue has me perplexed. I don't enjoy the default red color tag while doing an insert comment. Does anyone know how to change the default color? Thanks in advance. You can't change the color. You could use the Drawing Tools to draw a tiny little triangle over it (or them) and then give it a fill color. See http://www.contextures.com/xlcomments01.html for more on comments. tj "ntwrkengnr@hotmail.com" wrote: > This issue has me perplexed. I don't enjoy the default red color tag while > doing an insert comment. Does anyone know how to change the default c...

Help with labels and lines in chart
Hi all i am tracking a few things and i wanted to make some objects in the my chart reposition dynamicly as i change the scale i dont care if i have to do a little clean up but just that the postions stay correct i have attached a picture any suggestion would be greatly appreshated +-------------------------------------------------------------------+ |Filename: Unti.png | |Download: http://www.excelforum.com/attachment.php?postid=5056 | +-------------------------------------------------------------------+ -- crash893 ---------------...

Outlook 2007
All of a sudden today when I hit reply to messages in my inbox, or forward messages in my inbox, they are automatically removed from my inbox. Of course they remain in my sent box, but I prefer to keep the original message in my inbox as well. I have not changed settings at all on this but for some reason it started to do this today. I cannot find any reference to this in the help file online. I do NOT have it set to view unread messages only. Sounds like you're looking at a view or search folder that's filtered to = show only unread items.=20 --=20 Sue Mosher, Outlook MVP ...

PivotChart data labels
Is it possible to have data labels as a percentage on a pivotchart ? Hi, What kind of chart are you making - pie, line, bar, ....? What version of Excel are you using? You can add data labels to pivot chart by choose Chart, Chart Option, Data Labels. You can add a custom label by calculating the percent in the data range of the spreadsheet and then using the free download form http://www.appspro.com/Utilities/ChartLabeler.htm. However, everytime you refresh the pivot table the data labels will return to their defaults. This problem can be avoided by using a Pie chart. In which case ...

Tables to PDF
Hi there, I'm working with a table in Publisher at the moment & have formatted all my column / row gridlines to 0.25pt. However, when I convert to Adobe PDF, some of the lines appear much thicker than the others. Any Suggestions? Ian Have you tried printing the .pdf file? I've seen lines that look thicker but print just fine. -- JoAnn Paules MVP Microsoft [Publisher] "ianp" <ianp@discussions.microsoft.com> wrote in message news:402A32B6-8157-4D23-907A-9C437BD4FE35@microsoft.com... > Hi there, > > I'm working with a table in Publisher at...

Changing individual characters in a cell to a different character
I am trying to write a bit of code that will look at a cell and covert what's in the cell to some sort of code. e.g. Hello Goodbye Yes No The above words are in different cells, and need converting to a different code, for example H is 1, e is 2, l is 3 and 0 is 4, so Hello would be 12334 The entries to the cells will be different, so I can't just do a select case and have Hello as one of them. Is there any way of doing a select case type statement, but for it to look at individual characters in a cell and cycle through until it's finished and then move onto the next c...

How do I show summary totals from a pivot table on a bar chart
I created a pivot table which shows the both individual and grand totals based on the fields I selected. I then created a bar chart based on this pivot table. What I would like to do is show the grand totals as well as the individual totals. Is this possible, if so how do I do it? When I try this (link to the pivot table's summary total) I get an error saying not a valid function. The function line contains =GETPIVOTDATA("Personnel no.",'P2'!$A$3) "Jon Peltier" wrote: > Colleen - > > You can add textboxes to the chart, which are linked to works...

how can i change a linked sound file to become an embedded
i am trying to package up a powerpoint presenatation that contains an audio track - which is an mp4 file. Within the presentation the sound file is currently a linked file. I've tried using the 'package to cd' function but I can still not get the sound to work when i then put the cd into other computers. so how can i embed it instead? i've tried deleting the track, raising the 'sound size limit' to 6000 kb and resinserting it-but that doesnt work. the file is 5.3MB. My plan is to ultimately email the presentation - but it's vital that the s...

How to change a single page orientation in one documet?
I have one set document with 10 pages inside. But I need only two pages (i.e page 6&7) display as landscape format. The rest let it be potrait. How to do it? "Trisya247" <Trisya247@discussions.microsoft.com> wrote in message news:29DD3074-1BE6-4CB8-BD57-72EAA4181AEF@microsoft.com... > I have one set document with 10 pages inside. But I need only two pages > (i.e > page 6&7) display as landscape format. The rest let it be potrait. How to > do > it? Create a section break before and after each page you want to be landscape.... htt...

Change FROM email
We are looking at a web fax servcie and would like to have some of our automated emails use a common email address when sending a fax so that all go into a common user inbox. Is that possible? Thanks. -- David Yes, it's possible, but the details depend on the Outlook version and whether the common inbox is in an Exchange mailbox. You should always include information like that when posting on an Outlook forum. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/arti...

How do I stop Excel from changing simple numbers to their 1/100th.
I'm working with the latest service pack of Excel 2000. Every number I enter into any blank cell becomes that number's 100th decimal value. For example, typing "2" in a cell results in "0.02" when I leave the cell. This did not used to happen, but I don't know what I did to make it happen, nor what to do to stop it from happening. CC hi goto 'Tools - Options - Edit' and uncheck 'Fixed decimals' -- Regards Frank Kabel Frankfurt, Germany Chris C wrote: > I'm working with the latest service pack of Excel 2000. > Every number I ente...

How do I change x-axis in an Excel Radar Chart?
I would like to plot a radar chart with 360 points however the excel radar assigns a line for each point, I would like to reduce this to 1 line every 10 degrees. Is this possible? Ideally I would like a polar plot graph where I can enter any angle and magnitude. Does such a thing exist? Hi, For polar plot you can use the xy scatter. I have an addin that may help. http://www.andypope.info/charts/polarplot.htm Cheers Andy Dr. J.White wrote: > I would like to plot a radar chart with 360 points however the excel radar > assigns a line for each point, I would like to reduce this...

How to change from OTA to Cable Clear QAM in WMC7
When I installed my tuner, I set up Live TV for OTA DTV. Got terrible reception, so I am trying to re-setup the live TV for digital cable clear QAM. I can't seem to find the menu to change the way TV signals are acquired. When I tried to change the TV signal menu, it entered the setup process after the point that OTA DTV is selected. I really just want to erase everything I did for live TV and start over. Is there a way to do this, without re-installing windows? ...

Changing default format for http references.
Microsoft Office Publisher 2003. How can I set the default for http references in a publication so that it is not a hyperlink? It is a nuisance to have every usage of http://something converted to hyperlink format and then to have to go back through the document and clear each one (and likely overlook several). Try, edit, find... replace -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.msauer.mvps.org/ news://msnews.microsoft.com "James Hahn" <JamesHahn@hotmail.com> wrote in message news:OrYtBHyqEHA.708@tk2msftngp13.phx.gbl... > Microsoft Office Publi...

Sales transactions Tables activity
I have Great Plains 9.0 with Service Pack 3 and am looking for a quick explanation on Sales Transactions table entries. Is there any way someone can quickly go over what exactly happens on a Sales Order during the Sales Transaction process. From placing an order, to picking it, to fulfilling it, to invoicing and creating a back order. My issue is that we have moved from printing Pick Tickets at time of order entry, to having our Warehouse print the pick tickets once an hour. The problem is that some Pick tickets don't print, and we cannot determine why. The reps who have entered the o...

MS Access Copy record to another table based on a form input 10-08-07
Hello. I have 6 Tables, all with identical fields. I want to copy a record from one table into another table, which table depends on what table is selected in a form. So if the table names are One, Two, Three, Four, Five, Six, and the record that I want to copy and insert into another table has been selected by a query in a form. I want the form to direct where to insert the table. So if the form has table Two selected (from the drop down list) then it should insert the record into table Two. If the form has table Four selected then it should insert it into table Four. The table the record is...

Using a sub procedure to change a subform property
I am currently using the following code to change the AllowEdits property on any form. The form calls the Sub procedure through a button's OnClick event. Sub UnlockForm(strFormName As String) On Error GoTo Err_unlockform If Forms(strFormName).AllowEdits = False Then Forms(strFormName).AllowEdits = True MsgBox "Form is now unlocked for editing." End If Exit_unlockform: Exit Sub Err_unlockform: MsgBox Err.Description Resume Exit_unlockform End Sub I am trying to call this Sub procedure from a button on a subform. I was going to us...

Changing the name part of a From address in outbound emails
When emails are sent from one of our pcs, the name of the pc (APC017) is being displayed to the email's recipient as part of the 'From:' field (ie. the From field shows APC017<mail@mycompany.com>). How do we change the APC017 part? We have changed the Display Name and other properties but it has not made any difference. We don't want to change all of our email addresses - just customise this specific one. We are using Small Business Server 2003 with Exchange 2003 SP2 and Outlook 2003. Apologies if this is something really simple! Many thanks Graham You will most l...

i want to allow users to edit changes afetr password protect of c
Please use the body of the message to describe what you want. Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 01:15:02 -0700, mamta raul <mamta raul@discussions.microsoft.com> wrote: ...

how to change stub height on statement?
The default stub height on the statement.xml is 3 inches. I want to change this to 3.5 inches, but when I change the StubHeight value in the xml file to 3.5, it moves the stub border down to 3.5" correctly, but messes up the rest of the statement below the payment stub. The variable I changed must affect other parts of the statement. How can I avoid this? Thanks, kevin never mind, i re-printed a few times and was unable to repeat the printing error, could have just been a fluke. on the first print after changing the stubheight property, the account summary and account receivab...

Automatic changes in cell entries
How does one shut off the abjectly rediculous habit of Excel insisting on knowing better what I want for cell entries than I do? EG If I type AKs I want AKs not Aks... :mad: I have reviewed all the options in Tools|Options as well as other places to no avail. TIA tools-option-edit and the last item <enable autocomplete cell values> uncheck this doco <perdedor@centurytel.net> wrote in message news:#LhMjTA4EHA.3472@TK2MSFTNGP09.phx.gbl... > How does one shut off the abjectly rediculous habit of Excel insisting on > knowing better what I want for cell entries than I ...

Ability to Change PO Number When Generating PO From Sales Order
When generating a Purchase Order using the SOP to POP link (from Sales Transaction Entry) would like the ability to change the next PO Number. ...

Error message with security roles changes
Hi Gary, Thank you to mention me make copies before I change the security roles. I tried to change the security roles in three ways: 1. Make changes to the original security roles, then save; 2. Make copies of the original security roles; 3. Make changes to the copies of the original roles, then save. All come up with an error message after a long time waiting. Can you please give me some ideas about what's the possible cause? By the way, in the event logs, it says that security descriptors have been changed successfully. Also, I can see that all the commands are excuted on SQ...

am trying to make my own fun wine bottle labels
And your question is.........................? -- JoAnn Paules MVP Microsoft [Publisher] "marksbrady" <marksbrady@discussions.microsoft.com> wrote in message news:F9DDB383-386E-4DD0-96BF-7B7DF479DFF2@microsoft.com... > Go to your local office supply store and look around for an appropriate label and design a fun label. Clipart. http://office.microsoft.com/clipart/results.aspx?lc=en-us&Scope=MC%2CMM%2CMP%2CMS&Query=wine -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "marksbrady" <ma...

Pivot Tables
When a pivot table has 2 indices, the values of the first index ar left blank on the 2nd and subsequent lines of the 2nd index. Can thes index values be automatically duplicated? Thanks ANdrew Middleto -- Message posted from http://www.ExcelForum.com Andrew, Send me your email address and I'll PM you a small add-in I put together to do this.. Cheers, Dave >-----Original Message----- >When a pivot table has 2 indices, the values of the first index are >left blank on the 2nd and subsequent lines of the 2nd index. Can these >index values be automatically duplicated?...