How to update the link within the separate worksheet in excel?
I have 5 different worksheet and I wonder if it can update automatically? thank you for your help.
Do you mean you have 5 worksheets that have linked data between them, i.e. Wrksheet 1 gets data from a cell in Wrksheet 2 and 3, something like that?
Right now does it ask if you want to update the links whenever you open a worksheet? You can set it so that that it automatically updates, but without the pop-up message; Here's how:
From the Tools menu, select Options, and then select the Edit tab. now Deselect "Ask to Update Automatic Links"
This will update your links automatically, but without the message.
June 27th, 2009 at 9:30 pm
I assume you have data in Sheet1 For example
A1 A2(Per day)
Basic Salary $30
To update Sheet2 For salary calculation
A1(No Of Days Worked) A2(Total Salary)
20 =Sheet1!A2*A1
above is formula for cell A2 in Sheet2
and 20 is number of days worked. Formula portion in A2 starts with '=' sign.
so whenever there is chnage in salary in Sheet1 Formaula will automitically chnage the value in cell A2 in Sheet2.
Hope this will help.
References :
June 27th, 2009 at 9:58 pm
Do you mean you have 5 worksheets that have linked data between them, i.e. Wrksheet 1 gets data from a cell in Wrksheet 2 and 3, something like that?
Right now does it ask if you want to update the links whenever you open a worksheet? You can set it so that that it automatically updates, but without the pop-up message; Here's how:
From the Tools menu, select Options, and then select the Edit tab. now Deselect "Ask to Update Automatic Links"
This will update your links automatically, but without the message.
References :