A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Formula refers to empty cells even when cells contains data



 
 
Thread Tools Display Modes
  #1  
Old February 25th 10, 08:14 AM posted to microsoft.public.excel.worksheet.functions
Monica Rustogi
external usenet poster
 
Posts: 1
Default 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.
Ads
  #2  
Old February 25th 10, 06:56 PM posted to microsoft.public.excel.worksheet.functions
klh84
external usenet poster
 
Posts: 6
Default 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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Valid - refers to the values of 2 cells ash3154 New Users to Excel 5 September 17th 09 04:11 PM
Conditional format refers to two cells DOUG Excel Worksheet Functions 1 June 17th 09 07:29 PM
Count Only Empty Cells AFTER Cells with Data David Excel Worksheet Functions 2 September 15th 06 06:05 PM
Where is the Data Tools group Help refers to when splitting cells AndreaW Excel Worksheet Functions 2 November 30th 05 06:02 PM
data in empty cells samsmimi Excel Worksheet Functions 3 April 1st 05 12:22 AM


All times are GMT +1. The time now is 04:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.