Unable to delete Calculated Field or Calculated Items

[cwelch]

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.

 

[sandy666]

you need to select calculated field from drop down selection on top not from list

 

[cwelch]

you need to select calculated field from drop down selection on top not from list

Oh so simple. thanks much. I was selecting from the list.

 

[sandy666]

You are welcome

 

[Octostone]

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]

try to refresh pivot table but if it doesn't work try to re-created pivot from the beginning

 

[Octostone]

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]

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]

sounds like data grouping needs to be removed
try right clicking from one and Ungroup