Forum Discussion

bikhod's avatar
bikhod
Copper Contributor
Mar 11, 2021

Excel VBA code to disable slicer refresh during table refresh

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.

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Mar 11, 2021
    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)

Resources