Linking cell to different workbook

[Guest]

Just had a quick question... I have several different worksheets and books
linked to one master workbook. However, if the contents of the cell in the
original workbook is blank, it displays a '0' on the master workbook until a
value is entered.

Is it possible to get the master workbook to appear blank as well until a
value is entered and it is updated?

Thank you for any help!

 

[Guest]

2 work arounds...

1 - Change the formula that you have pointing to the target workbook to an
if formula. If the value in the target book is blank ("") then make the value
in the master blank, else return the value from the target book.

2 - Tools -> Options -> View tab -> uncheck Zero Values

 

[Guest]

Worked perfectly, Thanks Jim

2 work arounds...

1 - Change the formula that you have pointing to the target workbook to an
if formula. If the value in the target book is blank ("") then make the value
in the master blank, else return the value from the target book.

2 - Tools -> Options -> View tab -> uncheck Zero Values