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.
MS Excel 2013: Refresh multiple pivot tables with a button. This Excel tutorial explains how to refresh multiple pivot tables with the click on a button in Excel 2013 (with screenshots and step-by-step instructions). See solution in other versions of Excel: Excel 2013. Excel 2011 for Mac. Excel 2010.