Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unknown Error Message
I am getting the below error in every spreadsheet I open and in many cells.
After checking the formulas in the cells, the message does not make any sense. Did I press a button or selection by mistake? It is happening in too many cells. Any help? Error Message: "The formula in this cell referes to cells that are currently empty" Thanks, Tony. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unknown Error Message
hi
how are you receiving this error. small green triangle in upper left of cell? if so try this on the menu bar.... toolsoptionserror checkinguncheck "fomulas referring to empty cells" regards FSt1 "Tony7659" wrote: I am getting the below error in every spreadsheet I open and in many cells. After checking the formulas in the cells, the message does not make any sense. Did I press a button or selection by mistake? It is happening in too many cells. Any help? Error Message: "The formula in this cell referes to cells that are currently empty" Thanks, Tony. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unknown Error Message
Thanks FSt1. That solved my problem.
"FSt1" wrote: hi how are you receiving this error. small green triangle in upper left of cell? if so try this on the menu bar.... toolsoptionserror checkinguncheck "fomulas referring to empty cells" regards FSt1 "Tony7659" wrote: I am getting the below error in every spreadsheet I open and in many cells. After checking the formulas in the cells, the message does not make any sense. Did I press a button or selection by mistake? It is happening in too many cells. Any help? Error Message: "The formula in this cell referes to cells that are currently empty" Thanks, Tony. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unknown error in function, and how to return value? | Excel Worksheet Functions | |||
Unknown Formula Error | Excel Worksheet Functions | |||
unknown #value error | Excel Discussion (Misc queries) | |||
Unknown Error | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions |