Excel VBA code to disable slicer refresh during table refresh

[bikhod]

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.

[#2]

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)