Linking Worksheets

[Guest]

I am having problems getting linked sheets to update. For example, if I insert a row or column, how do I get it to insert on the linked sheet?

 

[Mark W.]

On 2002-02-20 06:45, Anonymous wrote:
I am having problems getting linked sheets to update. For example, if I insert a row or column, how do I get it to insert on the linked sheet?

You must have linked sheets open when you insert a row into the source worksheet. I recommend that you create named ranges on the source sheet and use them in the linked sheets. That way the linked sheet's formulas are unaffected by row and column changes on the source worksheets.
This message was edited by Mark W. on 2002-02-20 07:01