Excel Why Do The Charting Ribbon Tabs Keep Disappearing?
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Why Do The Charting Ribbon Tabs Keep Disappearing?
Occasionally, new tabs will appear on the right side of the ribbon. These tabs appear when the current selection includes SmartArt graphics, charts, drawings, pictures, pivot tables, pivot charts, worksheet headers, tables, ink, or when you are in the legacy Print Preview mode.
These new tabs will stay visible as long as the object stays selected. If you click outside of your pivot table or chart, the tabs will disappear. If you are looking at an object and cannot find the tools necessary to edit the object, click the object to bring the tools back.