Refining Tushar's post, put a textbox in the sheet that says "Click
anywhere in the PT, then click the refresh button (the one with the
exclamation mark) on the PT toolbar." If this is insufficient for any
user, have their manager contact human resources.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Tushar Mehta wrote:
I know you know your task better than I. That said...

You are kidding, right?

Zero XL knowledge and they know how to update a list used for
validating data entry in a column, how to propagate cells with formulas
as new fruit types are added, how to use a drop-down for data entry,
and how to enter a number in the correct adjacent column.

If you know this is easy with a Pivottable, why not use one? After
all, if this is not a homework assignment, it is not rocket science to
tell someone "click anywhere in the PT, then click the refresh button
(the one with the exclamation mark) on the PT toolbar."

And, if they cannot figure how to click a button, you have bigger
organizational problems than automagically updated pretty pictures.