Forum

Thank you Velouria - that was the simple hack I was looking for and it was under my nose the whole time! That is going to save a heap of tears. And it...

So.. the way I format the table at the moment (which seems rather clumsy..) is to highlight as much of the table as I can by selecting a row, hovering...

Yes there was a filter on - but the pivot table has large number of rows without filters and there are a variety of filter combinations for different ...

I cannot get the solutions above to work for me. I have created a simple set of 3 queries in the workbook, the first two take about 5 seconds to refre...