3) B. Using the name manager could also be really helpful depending upon what is causing your defined name error.

On Monday, November 5, 2012 2:00:00 PM UTC-8, wrote:
You guys have been really helpful, I was able to figure out a 4500+ occurrence problem within a workbook containing 100+ sheets :)



1) File - check compatibility - paste into new sheet



2) Formulas ribbon - defined names region, select use in formula - paste names - paste list.



3) If this is what is causing your problem, you will now see see all of these names along with their locations. Now, select all tabs (ctrl + click) and go to home - general - number - format as raw text



4) Now search workbook for these names and either replace them or delete them.



I hope this helps,



rk



On Saturday, October 20, 2012 8:14:33 PM UTC-7, wrote:

On Monday, August 27, 2012 12:31:05 AM UTC-4, wrote:



You may please try the following:















Undder the formula bar, click name manager and delete the names and then give try.







I hope it will work.







Thanks for the tip -- I tried delete names and the links went away!