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

JayashreeN

New Member
Joined
Jul 16, 2008
Messages
2
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
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

New Member
Joined
Jul 16, 2008
Messages
2
<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

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
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.)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,847
Messages
5,627,239
Members
416,232
Latest member
Ash1432

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top