How complex? What would the pseudo code look like?
Just want to keep this thread alive. I made the recommended changes but am still seeing the error when I add a row to ANY of the tables (ART, Team, Ti...
Hi again - I have what I hope is a quick follow-up on this. I added two properties to the "SlicerFormatSettings" type: CrossFilterType and SortItem...
It was suggested I do so by a moderator. Thanks.
Thanks. I am new to PQ. I will investigate. Thank you!
Thank you, Velouria and Catalin. This is great. I learned a lot. Heree's what I ended up with... Private Sub Worksheet_Activate() On Error Resum...
I wasn't familiar with Chart Templates before, so that was a helpful answer. However, it seems that they are saved as separate files and that's not pr...
Velouria provided the answer: Amend the formula to: =IF(COUNTA(ReportBurndown!$X$2:$X$2)>0, OFFSET(ReportBurndown!$W$2,,,MAX(2,COUNTA(Repor...
Thanks, Riny. Those are good solutions. However, in this scenario, I cannot make the assumption nor require that the table be sorted in any particular...
Thanks, Jessica - I used your idea to craft a slightly different solution. My approach does require that the rows be in any particular sequence. ...
Well, first of... wow. Even though the problem remains, I certainly appreciate the effort you put into hunting it down. I tried some of the same thing...
Hi (again) - I've been trying to figure this out for the last 10+ hours or so... but I'm at a loss. All the formulas look right to me. The XLS is n...