For the past month, all my spreadsheets with pivots lock-up until I refresh
them. This happens every time I view a page with a pivot. I cannot go to
another page etc. without pressing the refresh on the pivot table. This
never used to happen, but occurs on all spreadsheets with pivot tables.

Any ideas?

Thanks