<div>
Excel 2007/2010?<br />
Go to you Formulas tab, and on the &quot;Formula Auditing&quot; group, you have an option for &quot;Error Checking&quot;. Open this and you &quot;Trace Error&quot; option there that should lead you to the formula that has the problem.<br />
<br />
jppinto
</div>


<div>
it does not show any error, i've done it for the whole sheet many times, but no error
</div>


<div>
There is a reference to an external reference which has errored out. <br />
<br />
Try searching for a [ sign in the entire workbook and get rid of that reference. <br />
<br />
If you dont find it try cycling through all graph elements.
</div>


<div>
is there any way which can stop this reference thing, i've already tried everything, as i told u my workbook contains alot of N/A, intentional ones to avoid blank data to get plotted. i guess that is the reason, how can i avoid it?
</div>


<div>
No it has got nothing to do with the #NA<br />
<br />
search for a <b>[</b> &nbsp;or for <b>ref</b> and get rid of it
</div>


<div>
this is not working, there's a vba code application.displayalerts = false<br />
can i associate it with worksheet_calculate? and also at the time of saving the file,<br />
this code must work somehow to avoid displayalerts, can someone assisst, is it actually possible?
</div>


<div>
Is it possible for you to post the file here?
</div>


<div>
Can you, if found, post the culprit for the benefit of others?
</div>


<div>
I actually found the solution of it way before your reply, but since your reply contains similar answers,dats y i rated you as the solution.<br />
This msg appears because of;<br />
A)<b>(THE MAIN ROUTE CAUSE OF THE ERROR MSG, IF YOUR WORKBOOK CONTAINS CHARTS,THEN FOR SURE THIS IS THE REASON OF THIS MSG)</b>The charts that are built from dynamic name ranges and when the name range becomes blank, because of no data. Also to note that the chart that become victim of this error msg are the line charts with lots of blanks/NA#(to avoid plotting zero's on chart). I didn't see this error on the bar charts, may be the reason is that instead of blanks/NA# the range of bar charts contained Dash(-). Once the blank chart is deleted, the error disappears, so the solution is to delete the chart(which nonody would be wanting to do,because its a dynamic one,somtimes no data and sometimes lots of data).<br />
B)the named ranges that contain #REF, once they are deleted, the msg dont appear.
</div>


<div>
Thanks for the feedback and thanks for the grade.<br />
<br />
Saqib
</div>


<div>
<div class="content wysiwyg-content">
I've workbook which contains graphs and a lot of formulas, the graphs are dynamic, the data range contains a lot of #N/A, to avoid plotting blanks on charts.<br />
I'm getting a msg time and again in my excel 2007 that <b>a formula in this sheet contains one or more invalid references. Verify that formula has valid path,workbook,range name and cell reference.</b><br />
<br />
I want to get rid of this msg.<br />
<br />
Any quick and working help in this regard shall be highly appreciated
</div>
</div>


I've workbook which contains graphs and a lot of formulas, the graphs are dynamic, the data range contains a lot of #N/A, to avoid plotting blanks on charts.
I'm getting a msg time and again in my excel 2007 that a formula in this sheet contains one or more invalid references. Verify that formula has valid path,workbook,range name and cell reference.

I want to get rid of this msg.

Any quick and working help in this regard shall be highly appreciated

A Formula in this sheet contains one or more invalid references

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.