Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot table formatting
I have a pivot table that I'd like to format so that it doesn't look like a pivot table. I haven't found a way to do this and I'm hoping someone can help me. I want to prevent the user from making any changes to the structure of the pivot table by dragging/dropping fields. Therefore, I want to hide the drop down arrows that appear next to the field names in the pivot table. I've tried to look for the right PivotTable property that controls this but haven't been successful. I've attached an small Excel file (zipped) that illustrates the pivot table I have and how I would like it to appear. +-------------------------------------------------------------------+ |Filename: Pivot Table Example.zip | |Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=548| +-------------------------------------------------------------------+ -- programmer123 |
#2
|
|||
|
|||
Hi
Regular posters to this newsgroup won't open attachments - we don't know what they might be. I would suggest doing a Edit|Copy and Edit|Paste Special|Values on your pivot table. You can then format it as you like and your users can't alter the dropdown options. -- Andy. "programmer123" wrote in message om... I have a pivot table that I'd like to format so that it doesn't look like a pivot table. I haven't found a way to do this and I'm hoping someone can help me. I want to prevent the user from making any changes to the structure of the pivot table by dragging/dropping fields. Therefore, I want to hide the drop down arrows that appear next to the field names in the pivot table. I've tried to look for the right PivotTable property that controls this but haven't been successful. I've attached an small Excel file (zipped) that illustrates the pivot table I have and how I would like it to appear. +-------------------------------------------------------------------+ |Filename: Pivot Table Example.zip | |Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=548| +-------------------------------------------------------------------+ -- programmer123 |
#3
|
|||
|
|||
There are instructions here for disabling some of the pivot table features:
http://www.contextures.com/xlPivot12.html programmer123 wrote: I have a pivot table that I'd like to format so that it doesn't look like a pivot table. I haven't found a way to do this and I'm hoping someone can help me. I want to prevent the user from making any changes to the structure of the pivot table by dragging/dropping fields. Therefore, I want to hide the drop down arrows that appear next to the field names in the pivot table. I've tried to look for the right PivotTable property that controls this but haven't been successful. I've attached an small Excel file (zipped) that illustrates the pivot table I have and how I would like it to appear. +-------------------------------------------------------------------+ |Filename: Pivot Table Example.zip | |Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=548| +-------------------------------------------------------------------+ -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Hi-
You can also use ToolsProtectionProtect Sheet. It doesn't remove the combo box buttons, but it does deactivate them and makes all else static. HTH |:) "programmer123" wrote: I have a pivot table that I'd like to format so that it doesn't look like a pivot table. I haven't found a way to do this and I'm hoping someone can help me. I want to prevent the user from making any changes to the structure of the pivot table by dragging/dropping fields. Therefore, I want to hide the drop down arrows that appear next to the field names in the pivot table. I've tried to look for the right PivotTable property that controls this but haven't been successful. I've attached an small Excel file (zipped) that illustrates the pivot table I have and how I would like it to appear. +-------------------------------------------------------------------+ |Filename: Pivot Table Example.zip | |Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=548| +-------------------------------------------------------------------+ -- programmer123 |
#5
|
|||
|
|||
I need to opposite problem resolved. Is there anyway to protect the data and
calculations and still allow users to use the pivot drop downs? "CyberTaz" wrote: Hi- You can also use ToolsProtectionProtect Sheet. It doesn't remove the combo box buttons, but it does deactivate them and makes all else static. HTH |:) "programmer123" wrote: I have a pivot table that I'd like to format so that it doesn't look like a pivot table. I haven't found a way to do this and I'm hoping someone can help me. I want to prevent the user from making any changes to the structure of the pivot table by dragging/dropping fields. Therefore, I want to hide the drop down arrows that appear next to the field names in the pivot table. I've tried to look for the right PivotTable property that controls this but haven't been successful. I've attached an small Excel file (zipped) that illustrates the pivot table I have and how I would like it to appear. +-------------------------------------------------------------------+ |Filename: Pivot Table Example.zip | |Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=548| +-------------------------------------------------------------------+ -- programmer123 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Pivot Table - Preserve Formatting | Excel Worksheet Functions | |||
Formatting of Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |