ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i name a range of data in excel (https://www.excelbanter.com/excel-worksheet-functions/189332-how-do-i-name-range-data-excel.html)

Scooter

How do i name a range of data in excel
 
I am trying to import contact information from an excel 2003 spreadsheet to
outlook. When I go to outlook to import the information it says "an error
has occured in the microsoft excel translator while getting the contents of
file system. The excel file has no named ranges. Use excel to name the
range of data you want to import"

I do not know how to name the range of data in exel, no matter what I try to
do.

Can someone please tell me how to do that?

Thanks

Peo Sjoblom

How do i name a range of data in excel
 
It's better to save the Excel file as *.CSV, then import as a comma
separated value (windows) file.

--


Regards,


Peo Sjoblom


"scooter" wrote in message
...
I am trying to import contact information from an excel 2003 spreadsheet to
outlook. When I go to outlook to import the information it says "an error
has occured in the microsoft excel translator while getting the contents
of
file system. The excel file has no named ranges. Use excel to name the
range of data you want to import"

I do not know how to name the range of data in exel, no matter what I try
to
do.

Can someone please tell me how to do that?

Thanks





All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com