Since QB22 is now 64bit it doesn't seem that the template works anymore, tried replacing / rebooting and no dice. The BigRed template will not give you the error anymore about the pivot tables or damaged data but it now seems it just doesn't fetch the correct data from the QB file. :(

I have used the BR template for many year versions of QB.

I switched to 64bit excel as well in hopes that would resolve but nope...