Protected Sheet doesn't update linked information

[Guest]

I am currently using Excel 2002 SP3, and have created a worksheet with linked
information to a source sheet. If I protect this worksheet, allowing users
to modify only certain cells, the protected cells (which have linked
information) do not update from the source with any user changes.

How can I allow user's to make a change in one area, and their input will
update the linked - protected area? (Trying to prevent users from adding /
deleting rows or messing with the formulae).

 

[geniusideas]

I am currently using Excel 2002 SP3, and have created a worksheet with linked
information to a source sheet. If I protect this worksheet, allowing users
to modify only certain cells, the protected cells (which have linked
information) do not update from the source with any user changes.

How can I allow user's to make a change in one area, and their input will
update the linked - protected area? (Trying to prevent users from adding /
deleting rows or messing with the formulae).

Before you protect your sheet,Select Cells you want to allow user to
change,right click
format cells--under protection untick locked. Then protect your sheet.

http://microsoft-excel-macro.blogspot.com

 

[Guest]

Before you protect your sheet,Select Cells you want to allow user to
change,right click
format cells--under protection untick locked. Then protect your sheet.

http://microsoft-excel-macro.blogspot.com

Not quite what I was asking... if I want to permit a user to change cell
A1, then whatever they put in, will update cell H1, which will then in turn
look to the linked source and return a new value. If I protect the sheet,
the user can make a change in cell A1, but the link in H1 does not update.
How can I get the link to update? While the sheet is protected,
Edit-Links-Update is not permitted. Thanks for your thoughts & help, it is
appreciated.

 

[Gord Dibben]

Train

Not typical behavior.

Locked cells should update if they have formulas, just can't be edited.

That's why we lock them, so users can't destroy or change the formulas.

If you can change A1 and H1 refers to A1 then H1 will update.

Maybe you have calculation set to Manual at Tools>Options>Calculation.

Also, where is the "linked source" referred to in H1?


Gord Dibben MS Excel MVP