Avoid automatic update when you change the filters in a dinamic table


New Member
Hello all,

first of all sorry if the question has been replied, but I´ve tried to find the solution in the forum and I couldn´t.

I have an excel file with a dinamic table that catch the data from an odc conection in the company server. The dinamic table hav several filters, and I should change some filter in order to have the correct information.

But after every simple change in one filter, the table uptade the data automatically, and I shoud wait some seconds to change other filter, and the wait some seconds and so on...

Is there any option to avoid this automatic updates? I want to change all the filters needed, and then update the table manually.

Thanks in advance!

Some videos you may like

This Week's Hot Topics