There is an excel file created in a compatible mode created in excel 2007 which has lots of range names created . some of the names are DEL001 , MAH001 , UP001 etc.
Now the file has run out of rows and columns hence the need to transfer it to a newer version say 2010 . When a save as to the new version workbook is done an error like 'The name you entered is not Valid' the reasons The name conflicts with an excel built-in-name or tha name of another object in the workflow is thrown up.
It asks whether you want to rename the range to a new name (which when done works fine) . However the name say 'UP001' etc is used a lot in the formulas and it would mean a lot of effort to find where all it is used and change the same to a new range name etc.
A thought why it throws this is , a name conflict 'UP001' gets converted into UP1 for reasons unknown. I am using the Formula/Define names/ Name manager box for defining names and when I type 'UP001' and point it to a range and try to save it throughs a name conflict error. Somehow I feel that UP001 is looked upon as UP1 which is a cell address and hence the conflict.
The old version did not have a column named 'UP' hence it worked very well.
Is there any way I could handle this without having to change the Range Name to something else other than UP001?
Please help.
Now the file has run out of rows and columns hence the need to transfer it to a newer version say 2010 . When a save as to the new version workbook is done an error like 'The name you entered is not Valid' the reasons The name conflicts with an excel built-in-name or tha name of another object in the workflow is thrown up.
It asks whether you want to rename the range to a new name (which when done works fine) . However the name say 'UP001' etc is used a lot in the formulas and it would mean a lot of effort to find where all it is used and change the same to a new range name etc.
A thought why it throws this is , a name conflict 'UP001' gets converted into UP1 for reasons unknown. I am using the Formula/Define names/ Name manager box for defining names and when I type 'UP001' and point it to a range and try to save it throughs a name conflict error. Somehow I feel that UP001 is looked upon as UP1 which is a cell address and hence the conflict.
The old version did not have a column named 'UP' hence it worked very well.
Is there any way I could handle this without having to change the Range Name to something else other than UP001?
Please help.