Prev: Thank you
Next: Comment Edit
From: Monica Rustogi Monica on 25 Feb 2010 03:14
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.
From: klh84 on 25 Feb 2010 13:56
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.
 | 
Pages: 1
Prev: Thank you
Next: Comment Edit