[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 insertname
that has changed to formuladefine names

Regards
FSt1

"Marilyn" wrote:

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

[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/Dumm...s.id-4861.html

http://www.homeandlearn.co.uk/excel2...l2007s7p6.html

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Marilyn" wrote in message
...
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

[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?

"Bernard Liengme" wrote:

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/Dumm...s.id-4861.html

http://www.homeandlearn.co.uk/excel2...l2007s7p6.html

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Marilyn" wrote in message
...
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