Formula refers to empty cells even when cells contains data


Monica Rustogi

I have a worksheet with link to external data source. The option is enabled
to ask me to enable auto refresh or disable auto refresh.

I have used 'Sumif' and 'vlookup' function to calculate certain values. Now,
even when the data is available in cells, the error checking option shows me
a little green flag with error as 'Formula refers to empty cells'.

I do not understand why the error is coming.

There is another problem in the worksheet that is even when i disable auto
refresh i still change my values that was there when i saved the worksheet
last time though the worksheets that receive data from datasource do not

Please help as all my data sheets are going heywire.




It is most likely due to a formatting error. The item you are looking up is
not able to be read in the format you are currently in. Try clicking on the
green flag, click the exclamation point, and try changing the cell to number.

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