Two possibilities. First, you can embed the link inside a formula to detect
a blank cell and replace it with a blank rather than bring back a 0: instead
of =SheetB!A1, use =if(isblank(SheetB!A1),"",SheetB!A1).
Second, you could simply use a filter. Select the table on sheet A. From
the menu bar, Data Filter Autofilter. Use the drop-down in the
appropriate column and select 'Custom'. Use the drop-downs in that dialog to
select 'does not equal' 0. When you click OK, those rows that had 0 in the
selected column will be hidden.
Is that what you're looking for? --Bruce

"Therese" wrote:

I have some data linked from spreadsheet B to spreadsheet A in the same
workbook. Sometimes the numbers show, sometimes they don't depending on the
results on spreadsheet B. Now I'd like to hide the rows automatically on
spreadsheet A if the result is "0". Is this possible at all, and if so - how.
Thanks in advance
--
Therese