For the most part, an overweight rating indicates less about the literal meaning of giving a stock higher weight than a given benchmark. Instead, it's typically used as Wall Street jargon to indicate a positive attitude about a particular stock.
To set an option to automatically refresh PivotTable data when you open your workbook, do the following: 1  Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. 2  Click Analyze > Options. 3  In the PivotTable Options dialog box, on the Data tab, check the Refresh data when opening the file box.
1 Copy the pivot table. 2  Activate the Office Clipboard by clicking on the expand option on the Home Tab under Clipboard (see below). 3  Now click on the cell where you want to paste the unlinked pivot table and choose the last item copied into the clipboard (which should appear on the left of your screen). Copy the pivot table. 2  Activate the Office Clipboard by clicking on the expand option on the Home Tab under Clipboard (see below). 3  Now click on the cell where you want to paste the unlinked pivot table and choose the last item copied into the clipboard (which should appear on the left of your screen).