I have been trying to import data saved to an excel workbook but when
I go through the normal import process this is what I get as an error
message. Does anyone have the answer as to how to name the data range
in excel??


An error has occurred in the Microsoft excel 97-2003 translator while
getting the contents of a file system.
The microsoft Excel 97-2003 file C:\User\Terry Daw|documents
\Morelsoftware\Sales Force\contact.xls
Has no maned ranges. Use Microsoft 97-2003 to name the range of data
you want to import.

The error message tells you exactly what is wrong - you have no named ranges.

--�
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
How to ask a question:
http://support.microsoft.com/KB/555375


After furious head scratching, asked:

| I have been trying to import data saved to an excel workbook but when
| I go through the normal import process this is what I get as an error
| message. Does anyone have the answer as to how to name the data range
| in excel??
|
|
| An error has occurred in the Microsoft excel 97-2003 translator while
| getting the contents of a file system.
| The microsoft Excel 97-2003 file C:\User\Terry Daw|documents
| \Morelsoftware\Sales Force\contact.xls
| Has no maned ranges. Use Microsoft 97-2003 to name the range of data
| you want to import.

You need a named range. See
http://www.slipstick.com/Tutorials/import/import.htm for the steps.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


wrote in message
...
I have been trying to import data saved to an excel workbook but when
I go through the normal import process this is what I get as an error
message. Does anyone have the answer as to how to name the data range
in excel??


An error has occurred in the Microsoft excel 97-2003 translator while
getting the contents of a file system.
The microsoft Excel 97-2003 file C:\User\Terry Daw|documents
\Morelsoftware\Sales Force\contact.xls
Has no maned ranges. Use Microsoft 97-2003 to name the range of data
you want to import.