| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy text from word with returns into one cell | Excel Discussion (Misc queries) | |||
| IF function which returns the text from a cell | Excel Worksheet Functions | |||
| How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
| linked objects following and leading returns | Excel Discussion (Misc queries) | |||
| linked objects following and leading returns | Excel Worksheet Functions | |||
Threaded Mode
