Formula refers to empty cells even when cells contains data

M

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

Please help as all my data sheets are going heywire.
 
K

klh84

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

Similar Threads

Persistent "Formula refers to empty cells" error despite cells evidently NOT being em 2
Cells not updated automatically 3
Linked cells not refreshing 2
Keeping cells blank even though formula is input 3
Spurious Formula Omits Adjacent Cells 2
Indirect formula errors if file is closed 0
Paste values all cells in a region which refers to out of region 0
Excel 2013 Pivot Data Range formula reference problem 0

Top