Two common PowerPivot error messages
Here are two error messages I see all the time now, about once per day:
UPDATED: I’ve found a third message that belongs in this same family, with same root cause and same fix, now included below.
Could not add the field "ACV - CURR" to the PivotTable because the formula is invalid.
Slicer Field could not be added. Reason: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND))
The command was canceled. Please press F1 to get the help topicl "Excel Window: PowerPivot Field List" for more details