One guess.

In masterfile, don't format the cell as text.

--
Regards,
Tom Ogilvy

"Todd Huttenstine" wrote in message
...
I am using formulas.


-----Original Message-----

How are you referencing Todd back to the MasterSheet

Is it in your VBA code

or

is it via formulas in Todd "A1:a10"

eg ='D:\My Documents\[MasterSheet.xls]Sheet1'!$A$1


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.