Excel Name Manger

[drajack]

Hi I recently upgraded from Excel 2003 to excel 2010 and now references and formulas that I created using the Name Manager in 2003 are not working in 2010, I keep getting a #NAME? error. The strange thing is that the formulas I created in 2003 shows up in the Name Manager list in 2010 and if I recreate the same formula or reference in 2010 it works.
Is there some setting or something I need to check to get the references and formulas working in 2010 without having to recreate them all. I've enabled all the addins and ruled out any sytax issues as I recreated some of them using the same formulas and they worked.

Any assistance wil be greatly appreciated.

DR

 

[jkpieterse]

On what are you getting the #Name errors, can you post some example formula's?
Make sure you use the formula error checking tool to check which cell is the "source" of the error.

 

[drajack]

Okay just to clarify, I created a compound formula called OUTPUT using the Name Manager in 2003. I then proceeded to use this without problems. There are no selections to be made by a user as the formula is built with the appropriate ranges and cell references already selected. If a user clicks on the cell all they would see is "=OUTPUT". When I upgraded to excel 2010 the OUTPUT function shows up in the list in the Name Manager (2010) but now gives a #Name? error in the cells where it is used. Nothing changed, its just the same sheet now opened in a new version of excel. No data on the sheet was changed in any way. Now if I recreate OUTPUT in the name Name Manager in excel 2010 using using the exact same formula (via copy and paste) it works. So what I wanted to know is if there is some setting that needs to be adjusted in 2010 so that my previously created formulas from 2003 can work as there are quite a bit of them.
I am sure that there are no issues with the formulas I am using so it really a matter of getting excel 2010 to recognize the stuff I did in 2003. Hope this makes sense.

DR

 

[jkpieterse]

Please post the formula.
My hunch is that it uses functions that were formerly part of the ATP. Since those are built-in functions in Excel 2010, it chokes on them, unless you re-enter them so Excel is convinced to use the built-in ones.

 

[tgeorges]

I have a spreadsheet that has a lot of named cells in it and several linked worksheets. I am used to the plain cell references and want to convert the spreadsheet back to conventional cell references and remove the names. Is there any easy way to do this? The spreadsheet has hundreds of name references and it would be a real pain to do them one at a time.
This is Excel 2010.

 

[jkpieterse]

Try using my name manager to delete the names, it should replace them in formulas upon request.
http://www.jkp-ads.com/officemarketplacenm-en.asp