GETPIVOTDATA - advice on how to use

Ok. I’m glad you are achieving your goals.

On the date issue, I haven’t noticed any date problems myself. If there were date issues, a lot of things would break. I guess I wouldn’t worry about this myself.

30 seconds or longer delays does sound like a problem. My hunch is it could be the pivot table but I can’t be sure. Here’s some tips on how to improve sheet performance in general:

You might want to take a peek at the hidden formulas in the Yearly Budget and Year to Date sheets to see if they give you any ideas. Those sheets handle the calculations pretty quickly and only use formulas.

Jon