May 08, 2020 · For example use a formula like =INDEX(D:D,MATCH("MSFT",B:B,0)) to get the Price for MSFT. MSN Money Stock Quote Add-in. The old way to work with stock quotes in Excel was the free MSN Money Stock Quote Add-in for Excel versions 2002 and 2003 (and 2007). But, that add-in no longer works. We need to refresh the pivot tables to see the changes. And if you send an updated file without refreshing the pivot tables, you may feel embarrassment. So in this article, we will learn how to auto refresh a pivot table using VBA. This way is easier than you imagined. This is the simple syntax to automatically refresh pivot tables in the workbook. F2 – select any cell then press F2 key and hit enter to refresh formulas. F9 – recalculates all sheets in workbooks; SHIFT+F9 – recalculates all formulas in the active sheet; CTRL+ALT+F9 – force calculate open worksheets in all open workbooks including cells that have not been changed; CTRL+ALT+SHIFT+F9 – recalculates all sheets in all open workbooks Excel Pivot Tables: Insert Calculated Fields & Calculated Items, Create Formulas Excel Pivot Tables: Filter Data, Items, Values & Dates Excel Pivot Table Report - Sort Data in Row & Column Labels & in Values Area, use Custom Lists Excel Pivot Table Design & Layout, Pivot Table Styles Apr 25, 2013 · In my earlier post, I had written about VLookUp in Excel. It was a massive post of around 2500 words, it explains most of the things about vertical look up function in excel. Today’s post is an extension to that post and here we will understand how to apply a VLookUp in VBA .