Documentation for Force Recalculation macro

• Right click on any worksheet cell and select "SMF" at the bottom of the context menu. Then select "Recalculate Worksheet".
  
  
• You can use the keyboard shortcut alt-F8 to bring up EXCEL's macro dialog window.
  Unfortunately, this window does NOT list macros that are part of an add-in.
  That means you need to type in "smfForceRecalculation" for the macro name. When you complete entering the macro name, you should see the various buttons activate. Then click "Run".
  
  
• You can run the macro using a keyboard shortcut. You assign a keyboard shortcut in the macro dialog window (done from the "Options..." button, which is located several buttons below the "Run" button used above).
  
  
• You can also add a button to the Quick Access Toolbar in EXCEL that runs the macro. This is the easiest way to run the macro once you set up the button.
  
  To add a button:
  
  
  1. Go to the Quick Access Toolbar at the top of the spreadsheet and select the down arrow to bring up the "Quick Access Toolbar Customize" window.
     
  2. Go to the bottom and select "More Commands ...".
     
  3. In the next window under "Choose Commands from:" select "Macros".
     
  4. Select "smfForceRecalculation" from the list and click the "Add >>" button between the two boxes. Click OK.
     
     

• What is the smfForceRecalculation macro and how do I use it?
  
  
• What do I need in addtion to smfForceRecalculation to get my data to refresh?
  
  
• How to Add a Macro to Excel's Quick Access Toolbar?