Debra Dalgleish, if I understand correctly, suggests recording a small macro
to allow refreshing a protected pivot table.

But what is the point of the 'Tools, protect sheet, Use pivot table
reports' ? It seem to allow nothing.

How is it supposed to work or is my Excel faulty?