![]() Thank you for any and all advice you can give me. 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: ![]() After clicking 'Page Layout' in the Workbook Views section, which converts the spreadsheet to a print ribbon grayed out in word. In the default Normal view mode, this option is checked but grayed out. Group & Show Detail (all submenu items available)įormulas / calculated field, solver order and list formulas (but not calculated item) Excel Details: Excel Details: Display the Rulers Click the ' View ' tab to see the Ruler check box in the Show group. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |