I have a workbook with a data sheet being pulled from a server, and then have another worksheet using VLOOKUP to bring through certain parts of the data. The VLOOKUP table has filters on it (Slicer).
The problem is that when using the table it needs to be refreshed often and when doing this with filters on the refresh leaves the same rows visible but these don't necessarily align with the actual filters anymore. I am wondering if this is something I have unintentionally done or alternatively if there is a way to trigger a reapply filters after a Refresh All is completed.
Thanks
The problem is that when using the table it needs to be refreshed often and when doing this with filters on the refresh leaves the same rows visible but these don't necessarily align with the actual filters anymore. I am wondering if this is something I have unintentionally done or alternatively if there is a way to trigger a reapply filters after a Refresh All is completed.
Thanks