Unknown Error Message

T

Tony7659

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.
 
F

FSt1

hi
how are you receiving this error. small green triangle in upper left of cell?
if so try this
on the menu bar....
tools>options>error checking>uncheck "fomulas referring to empty cells"

regards
FSt1
 
T

Tony7659

Thanks FSt1. That solved my problem.

FSt1 said:
hi
how are you receiving this error. small green triangle in upper left of cell?
if so try this
on the menu bar....
tools>options>error checking>uncheck "fomulas referring to empty cells"

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top