Excel Link Problem

[arun0580]

Dear All,

I am using an Excel 2003 workbook((Book2),which contains link to another workbook(Book1). If there is no data in the workbook(Book1) the data in the workbook(Book2) appears as 0.00 .I need to display it as blank.

If anyone know the solution pls quote it....


Regards
Arun

 

[arun0580]

On the Tools menu, click Options, and then click the View tab.
Do one of the following:

To display zero (0) values in cells, select the Zero values check box.

To display zero values as blank cells, clear the check box.