Thread: Linked cell returns a 0 where there is no text (sometimes)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
ragtopcaddy via OfficeKB.com ragtopcaddy via OfficeKB.com is offline
external usenet poster
  
Posts: 22
Default Linked cell returns a 0 where there is no text (sometimes)
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

Reply With QuoteReply With Quote