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

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

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

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

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