Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Persistent "Formula refers to empty cells" error despite cellsevidently NOT being em
On Thursday, 30 January 2014 01:47:41 UTC, EdwardFox wrote:
This error is driving me slightly nuts. Spreadsheet is working fine, but error flags keep popping up and I'm worried it won't be fine for long. Problem is: Persistent "Formula refers to empty cells" error despite cells evidently NOT being empty. Also, when error is traced. Excel traces back to a cell that is: a) not referred to in the formula AT ALL b) NOT empty I have this error running down two columns containing VLOOKUPS. Sheet is working fine. Error alerts are just silly and irritating. Is it ok to ignore these? Or should I worry? -- EdwardFox I'm getting this too, very bizarre! As well as having the problem with Vlookup, i've got the error on a sum calculation too but I can see there is a solid list of numbers :S I'm using excel 08 for mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula refers to empty cells even when cells contains data | Excel Worksheet Functions | |||
Empty a cell if the values equal to "IN" , "MC" or "PP" | Excel Programming | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Access a worksheet level named range with Refers To like "=5". | Excel Programming | |||
Runtime Error Msg: "Cannot empty the Clipboard" | Excel Programming |