Workbook Filters and Creating Recalc Buttons

Sharperlight Tables that are not on the Active Worksheet are not auto recalculated by design to prevent mistaken updates

Only Tables on the active worksheet get auto updated when their parameter cell references get updated

The way to solve this is to create a Button with a Sharperlight macro that updates all Tables

1) Create a Button using the Developer Ribbon ( If missing add using Excel Options / Customize Ribbon )

2) Right Click on the Button and select Assign Macro

2) Assign Macro Name to the Button called mdRecalcActiveWorkbook

3) Now if you click Click Button and all worksheets and their tables will be updated

To see a full list of Sharperlight Macro commands use Excel Options / Customize Ribbon / Macros