TechSpot

Excel Link Problem

By arun0580
Apr 7, 2008
  1. 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
     
  2. arun0580

    arun0580 TS Rookie Topic Starter

    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.
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...