Forum

Thank you, Phil.

After much experimentation, I found a solution, and I'm posting this to help others. When you have multiple Pivot Tables with external connections ...

I tried to duplicate this situation in a different blank workbook. I created a bunch of Pivot Tables with the same external connections to the same so...

There is an unexpected complication: I have many Pivot Tables in my Excel model, but only two tables in source file from which they all derive. I crea...

I wanted to follow up on this for the benefit of others. It turns out that the issue was caused by using the .xlsb (binary) file format. I use this...

Thanks for this. I did run into some problems with the source file Excel table, however. I opened a new file and loaded the data with an external c...

Thanks, Velouria. I didn't see your post before replying, above. I didn't know the GETPIVOTDATA formula behaves similarly to SUMIFS. This makes it ver...

No, I didn't try GETPIVOTDATA because I think it is only a lookup for a single value, not a sum.

Catalin, I wanted to get back to you on this. I'm greatly encouraged there's a way to do this, but I couldn't get past the custom column, above, wi...

Thanks, Frans. That worked.