I have a 2003 worksheet with Defined Name Ranges. If I run it in 2007, do I have to re-create them? The Named Ranges seem to have been lost when I run 2007. Can it be easily converted?
I no longer see the Named Range. When I launch my workbook in 2007, I go to ---> Formulas ----> Define Name, I don't see any of the Name Ranges. It looks as if I have to re-create them again.
Very interesting.... Yes, I see them now in the Name Manager. But, there are also a bunch of #REF's, so I guess I need to delete or correct them by pointing to where they belong.
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.