Problem with formula when inserting a new column

[Ruth]

Hi

I have a spreadsheet similar to the below which is updated weekly

A B C D
NAME WEEKLY SCORE WEEKLY SCORE MEETING HELD
John Smith 250 230
01/11/2009
Jane Smith 105 10
07/12/2009

I insert a new column at the beginning of every week to enter in the new
score so we have a continual track. I want to create seperate spreadsheets
for the team managers for their employees which will update with Column D I
started by simply putting =(spreadsheetname!d2) which is fine until I insert
a new column. Is there a formula that will take into acount the insertion of
a new column each week and still provide me the date from "MEETING HELD"?

Hope this all makes sense
Thanks

Ruth

 

[Jim Thomlinson]

Your formula
=(spreadsheetname!d2)
is relative referenced so when you insert a new column it will increment the
D to an E and your reference to Meeting Held should stay in tact...

 

[Arceedee]

Try making the cell reference a constant.
=(spreadsheetname!$d$2)

 

[Ruth]

Hi

I have tried this and it is still not working do I need to have all excel
work books open at the same time for it to update?