Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refers to empty cells even when cells contains data
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula refers to empty cells even when cells contains data
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. "Monica Rustogi" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Valid - refers to the values of 2 cells | New Users to Excel | |||
Conditional format refers to two cells | Excel Worksheet Functions | |||
Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
Where is the Data Tools group Help refers to when splitting cells | Excel Worksheet Functions | |||
data in empty cells | Excel Worksheet Functions |