Lucky, in the master workbook, enclose the link in an if statement, such as:
if(linked cell="","",linked cell). The master workbook cell will appear
blank until something is entered into the linked cell. HTH
--
Sincerely, Michael Colvin


"Lucky_guy2000" wrote:

I am linking several workbooks, cell for cell, into a masterwork. However,
when I link a blank cell into the master workbook, a zero is put into the
master cell. Is there a way to keep the link, in case information is later
entered into the subordinate workbook, but no value is entered to the master?
Thanks for your help.
Johnnie