I created a workbook for others to use.  The first sheet in the Excel 
workbook has general information that I linked to cells on other worksheets.  

However, when cells on the general information sheet are blank, a zero 
appears in the other worksheets.  

What must I do to maintain the link to the general information sheet but 
eliminate the zero?

Either turn off zero values display in Options or trap for blank cell.

I prefer the trap.

=IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben  MS Excel MVP

On Wed, 3 Feb 2010 14:49:02 -0800, --Viewpoint
<Viewpoint@discussions.microsoft.com> wrote:

>I created a workbook for others to use.  The first sheet in the Excel 
>workbook has general information that I linked to cells on other worksheets.  
>
>However, when cells on the general information sheet are blank, a zero 
>appears in the other worksheets.  
>
>What must I do to maintain the link to the general information sheet but 
>eliminate the zero?