Yeah sorry

Sheet1 Has been named Contacts and is being used as a database of
contacts so i want to pull the names out to use in other spreadsheets

when i type =Contacts!F3 (for example) either manually entered or by
clicking to the relevant cell it sometimes pulls the name into the
other spreadsheet and sometimes it simply displays =Contacts!F3 as if
the entry were not a reference but an entry in its own right.

i dont think i'm missing anything obvious


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=504959