Hi,

Do the following:
1. On the Tools menu, click Options.
The Options dialog box is displayed.
2. Click the Calculation tab.
3. Under Workbook option, select Update remore reference and Save external
link values check boxes.
4. Click OK

Challa Prabhu

"helphelp" wrote:

I have created a file with numerous work sheet and hyperlinked the values
with the main sheet , i do not know how to put a function for autoupdate in
the the sense that any value changes the main work sheets get automatic
update