Ask Your Question

How do I get filtered data to update [closed]

asked 2014-08-20 22:15:06 +0200

grahamh gravatar image

I have a data table in Calc with an advanced filter. If I change the filter criterion, the table doesn't update. I have to reset the filter and re-enter it which is a PITA.

Is this as good as it gets?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 12:40:47.667521

1 Answer

Sort by » oldest newest most voted

answered 2014-08-20 22:48:27 +0200

m.a.riosv gravatar image

Advanced filter it's not automatic, you always need to run the filter again, but you need to stay in someplace of data range to reuse the filter.

It's possible add a button to the advanced filter in Menu/Tools/Customize

image description

edit flag offensive delete link more


Brilliant, thanks. That saves a few clicks at least!

grahamh gravatar imagegrahamh ( 2014-08-20 23:52:17 +0200 )edit

Question Tools

1 follower


Asked: 2014-08-20 22:15:06 +0200

Seen: 462 times

Last updated: Aug 20 '14