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.

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.

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.