vurbands.blogg.se

When on the formula worksheet from which the pivot table was generated (yes they are all part of one workbook), the following ARE NOT available (are grayed out) under the pivot table menu: Group & Show Detail (all submenu items available)įormulas / calculated field, solver order and list formulas (but not calculated item) Select / entire table or enable selection (but not label, data or label data) Simultaneiously, when on the pivot table worksheet, the following ARE available to me: Order is black but all of its four submenu items are grayed out When on the pivot table worksheet, the following ARE NOT available to me (they are grayed out):ĭata & label submenu items under selections

Here is a list of things unavailable & available to me in the pivot chart menu.

Hi John - Thank you so much for replying to an exSeattlite & Olympian.