Unable to delete Calculated Field or Calculated Items

cwelch

New Member
Joined
Mar 2, 2019
Messages
5
I am unable to delete calculated fields OR calculated items in a pivot table.
The DELETE button is simply greyed out; when selecting the calculated field or item.

Workbook has no macros, is not protected in anyway.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,774
you need to select calculated field from drop down selection on top not from list
 

Octostone

New Member
Joined
Jun 22, 2020
Messages
2
Office Version
  1. 365
Platform
  1. MacOS

ADVERTISEMENT

you need to select calculated field from drop down selection on top not from list
Hey Sandy666,
You solved that issue so easily, here is a hyper similar one that has me stuck

Office 365 on OSX.
I have a multitab workbook with several pivot tables (I copied them from tab to tab, which I am realizing wasn't best practice, but i digress...)
I had used the GROUP function inside one of my Pivot's to group dates into chunks (Week 1, Week 2, Etc) but something went oddly and it was mi-ordering some of the dates. I tried to get rid of it, but it has created what I assume to be a calculated field in my pivot list for all the tables. OK, so just go to PIVOT TABLE ANALYZE>FIELDS, ITEMS AND SETS>CALCULATED FIELDS and then from the drop down at the top of the pop up choose my field and then delete it right....but what if it's not there?

It appears in every pivot table field list (as "Date2") of the pivots that I copied and pasted, on every tab in the workbook. And at no point (unless I fat fingered a KB shortcut) did I actually choose to make this a calculated Field, I was just working with Groups, so I don't know how it got there in the first place.

I have closed/reopened the doc. I have closed and reopened Excel.

I am lost as to what to do. And redoing this is, for me, hours of work to recreate all these pivot tables.

Any advice?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,774
try to refresh pivot table but if it doesn't work try to re-created pivot from the beginning
 

Octostone

New Member
Joined
Jun 22, 2020
Messages
2
Office Version
  1. 365
Platform
  1. MacOS

ADVERTISEMENT

try to refresh pivot table but if it doesn't work try to re-created pivot from the beginning
I've refreshed all of them repeatedly to no effect.

So you have no idea why a calculated field would not appear in the drop down list of calculated fields?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,774
My idea is create pivots from the beginning with fresh cache
I really don't know what you did there before you got "calculated field which doesn't exist"
I prefer theory in practice what is not possible now
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
sounds like data grouping needs to be removed
try right clicking from one and Ungroup
 

Watch MrExcel Video

Forum statistics

Threads
1,109,165
Messages
5,527,187
Members
409,749
Latest member
BorisYeltsin

This Week's Hot Topics

Top