What do you mean by "update"?

In general, macros are the only way to make changes outside the user's
control.

In article ,
DJL wrote:

I need to update a workbook each time the user goes to a new worksheet either
by selecting the tab for that worksheet or by hyperlink. How can I to this
without using a macro? (if a macro is necessary I can live with it..I'm
trying to keep things simple)