name the range of data
 

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

name the range of data
 

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

name the range of data
 

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

name the range of data
 

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