Formula Referencing another Workbook breaks when edited

[DJBuck11]

I have a simple formula pulling data in from another workbook, that works fine when I select the cell to show, but when I edit the formula to remove the $ locks (so I can drag the formula), the cell doesn't report correctly, showing the formula instead of the data.

Working:
External Reference_Working.PNG

Not working:
External Reference_Not Working.PNG

What am I missing?

[WideBoyDixon]

I've had this before. Check the format of the cell by selecting A4, pressing [Ctrl]+1 and making sure it isn't set to "Text". Change it to "General" if necessary then the formula should work OK.

WBD

[DJBuck11]

Yes this is exactly the problem, I found it while pressing every button and option I could find!