name the range of data

[Marilyn]

I am trying to import an Excel spreadsheet into an Outlook Contact folder.
After I choose the destination folder, I get an error saying "the file has no
named ranges. Use Microsoft Excel 97-2003 to name the range of data you want
to import". I am currently using a trial version of Excel 2007 and do not
find in help how to name the ranges. Can you tell me how to do this?
Thanks, Marilyn

 

[FSt1]

hi
if it would help, check this site out.
it show the menu conversion of xl2003 to xl2007.
http://www.rondebruin.nl/0307commands.htm

per his site, the old command was insert>name
that has changed to formula>define names

Regards
FSt1

 

[Bernard Liengme]

Go back to help and seach with: Define and use name
The first item in the results is for you

And here are links I found with Google
http://www.dummies.com/WileyCDA/Dum...ating-Names-for-Cells-and-Ranges.id-4861.html

http://www.homeandlearn.co.uk/excel2007/excel2007s7p6.html

best wishes

 

[Marilyn]

I've followed the steps noted in your links as well as the help area of Excel
and am still getting the same error when trying to import????? what the heck
am I missing?