Thanks ksemmer for helping us debug that problem! Thanks for the updated XLS that addresses the PivotTable problem. I'd respectfully suggest that you update the XLS with one row to tell people how to refresh it (just right-click and hit "refresh data"). I noticed the bug was fixed in Apri...