Excel VBA code to disable slicer refresh during table refresh

%3CLINGO-SUB%20id%3D%22lingo-sub-2202196%22%20slang%3D%22en-US%22%3EExcel%20VBA%20code%20to%20disable%20slicer%20refresh%20during%20table%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2202196%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20large%20table%20with%20thousands%20of%20rows%20of%20data.%20The%20tables%20has%20multiple%20slicers%20attached%20to%20it%20to%20make%20it%20easy%20to%20slice%20and%20dice%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20stop%20the%20slicers%20constantly%20refreshing%20when%20my%20VBA%20code%20is%20updating%20the%20tables%20(update%20%3D%20adding%20new%20rows%20or%20modifying%20existing%20rows)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20psudoe-code%2C%20I%20need%20somethnig%20that%20helps%20me%20do%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3Esub%20UpdateTable()%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20DisableAllSlicers%26nbsp%3B%20%3CSTRONG%3E%26lt%3B%3D%20How%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20DoUpdate%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20EnableAllSlicers%26nbsp%3B%20%26nbsp%3B%3CSTRONG%3E%26lt%3B%3D%20How%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eend%20sub%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2202196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2202339%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20VBA%20code%20to%20disable%20slicer%20refresh%20during%20table%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2202339%22%20slang%3D%22de-DE%22%3EAs%20far%20as%20I%20know%2C%20suppressing%20via%20VBA%20does%20not%20work.%3CBR%20%2F%3EBut%20under%20Edit%20%2F%20Links%20you%20can%20set%20what%20should%20happen%20when%20the%20file%20is%20opened.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20since%20I%20am%20not%20sure%20whether%20this%20might%20be%20possible%20in%20the%20end%2C%20%3CBR%20%2F%3E%20I%20am%20waiting%20with%20you%20for%20the%20next%20comments%20%2F%20suggestions%20for%20solutions.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I have a large table with thousands of rows of data. The tables has multiple slicers attached to it to make it easy to slice and dice the data.

 

How can I stop the slicers constantly refreshing when my VBA code is updating the tables (update = adding new rows or modifying existing rows)?

 

In psudoe-code, I need somethnig that helps me do this:

sub UpdateTable()

    DisableAllSlicers  <= How?

    DoUpdate

    EnableAllSlicers   <= How?

end sub

 

Thanks in advance.

1 Reply
As far as I know, suppressing via VBA does not work.
But under Edit / Links you can set what should happen when the file is opened.

But since I am not sure whether this might be possible in the end,
I am waiting with you for the next comments / suggestions for solutions.

Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)