LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Remove Pivot Field

I have several pivot tables that I maintain, and have recently noticed a
minor problem with some of them. It would appear that somehow a couple of
the pivot fields have been duplicated and/or renamed. I can rename the
fields without any problems, but how do I delete the duplicated field? I
tried to do this programmatically, but kept running into a 1004 error, and I
didn't see anything in the UI to remove a field. How does someone create a
copy, and then there isn't any way to remove that erroneous field from the
pivot field list??

TIA,
Chris
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I remove #DIV/0! in a pivot table calculation field ? fabre jerome Excel Discussion (Misc queries) 2 September 7th 09 02:36 PM
remove a calculated field from a pivot table in Excel 2003 NEvans009 Excel Discussion (Misc queries) 3 February 6th 07 10:13 PM
Remove outdated checkboxes from Excel Pivot Table field pulldown? IrishPatNJ Excel Discussion (Misc queries) 1 August 4th 06 04:20 PM
Pivot Table: Remove old field cell value RhysPieces Excel Discussion (Misc queries) 1 July 15th 06 01:02 AM
Pivot Table - Remove "sum of" in data field abgmclt Excel Discussion (Misc queries) 2 May 26th 06 08:22 PM


All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"