Refresh Data Table And Not Trigger Worksheet_Change

Hi,

I have a data table that is connected to a sharepoint list. I need to find a way to refresh the data table without triggering the Worksheet_Change event.

My Worksheet_Change change event monitors if a cell has been edited in the table and marks that line with an "*". But when I refresh my table, the Worksheet_Change considers all the lines changed and marks every single line with an "*".

Any ideas?

You can set Application.EnableEvents = False while you do the refresh and then set it true after the fact

Yep, what you will want to do is

- Create a global variable that will hold a state "on/off" or "true/false" etc.
- Create a sub to refresh your pivot data table, at the beginning of your sub set the global variable to "On", refresh your data tables and then set the global variable to "Off"
- In your on change event add a check "IF global_variable = "Off" Then", so that the on change event code will not execute when your data table refresh is occuring