Hi Bill,

Any formula referencing an empty cell returns 0 from that cell. If you need to suppress the 0s, you'll need to either set the
worksheet to suppress the ) value display (which will affect all cells displaying 0) or add an IF test to the formula to test the
value and suppress it if the source cell is empty. For the latter:
=IF('T:\Storage\1.Reporting\DB\RAID log\[RAID Log.xls]Issues'!P10="","",'T:\Storage\1.Reporting\DB\RAID log\[RAID
Log.xls]Issues'!P10)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"ragtopcaddy via OfficeKB.com" <u9289@uwe wrote in message news:81bdabf357e11@uwe...
The contents of cell P10 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID
logs\RAID log.xls is empty.

The contenst of cell P8 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID
log.xls reads "='T:\Storage\1.Reporting\DB\RAID log\[RAID Log.xls]Issues'!
P10",
but is returning a value of 0. The contents of cells P4 and P5 in the source
wrkbk are also empty, but the links to those cells are also, correctly, empty.
It's only after 5 rows of correctly returned text that the 0s pop up. Any
idea what's happening here?

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via http://www.officekb.com