help needed for disabling inbuilt excel error message...while using dynamic graphs

[JayashreeN]

Respected mam/sir,

i have problem regarding the use of dynamic graphs(i m using offset function for the same)...

the problem i m facing is that i m getting an error message "A formula in this workseet has one or more invalid references"
i have manually checked all the references in the graph and they are valid...and all the other functionality is working perfectly well...what i want to know is that is there a way that i can disable this error msg that automatically pops up this would avoid the extensive rework which might otherwise be required...
in short...i dont want excel to pop up the invalid reference error message...how do i do that...
thanks and regards,
jayashree

 

[Greg Truby]

Run through all of your named ranges and see if there is a busted reference hidden among them. That's a frequent source of ghost ref errors.

 

[JayashreeN]

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->
i have Run through all of the named ranges... deleted the ones that are not used...but still the message present...it shows up everytime i scroll down in that sheet or view that sheet...

 

[Greg Truby]

Have a look at what Aaron wrote here:
http://www.xl-logic.com/modules.php?name=Content&pa=showpage&pid=2

Use IE's FIND to search for the word "ghost" to jump to the appropriate paragraph.

You might also note that if using XL2003 or lower, the named range box only shows names in scope. If you have a name scoped to sheet1 and you have sheet2 active, the name defined on sheet1 does not appear. Unless you are using XL 2007, be sure to call up the name dialog box from each worksheet. (If you have oodles of worksheets you might want to explore using VBA to help.)