Pulling data from one workbook to a second one not working

[pongmeister]

I need to pull values from one workbook to another in excel 2003.

I tried the following code [code]='[Tournament Register.xls]Signup'!$A$1[code/]


This doesn't work please let me know if the syntax need to change or another method to do the task.

[Pepe Le Mokko]

Is the other wbk open?

What does not work?

[pongmeister]

Yes, the other workbook is open but the formula is all that shows in the destination cell - no data from the source workbook.

Thanks for your help

[Pepe Le Mokko]

Are calculations set to automatic ?
If yes, cell is probably formatted as text - Format as general- Hit F2 then Enter

[Debraj Roy]

or you may try..
Ctrl + ~
for set cell display value instead of formula..

[pongmeister]

Thanks Pepe, My calculations are set to automatic and the F2 did the trick.

Thanks for your help!!!

I will mark thread closed

[pongmeister]

Thanks Debraj, The F2 Pepe recommended work great, thanks for your input also. I am marking this thread closed

[Pepe Le Mokko]

You're welcome and thanks for the rep