Hi all, hope someone can help, cause im going mad here!!

I'm trying to link some data in two excel workbooks. . . Simple yea! afraid not!
So i click on the cell where i want to put in my info, press the = sign and then search in the other workbook for the info i want to put in. No brian surgery here! The info comes in fine.

However when the info comes in it should read something like this

='[09-02-28 Grouped Management Accounts.xls]Balance Sheets'!AG5

the problem i have is automatically, excel is pressing the f4 key for me so the info is coming in like this.

='[09-02-28 Grouped Management Accounts.xls]Balance Sheets'!$AG$5

it means i cant drag down the formula.

Im pretty sure this shouldnt happen automatically, and Im also pretty sure i had actually done it earlier on and it was fine.

Hope im clear in my point and i really hope someone can help me fix this problem.

Thanks a mill

Steve