Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.

Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...