Importing from Excel Error

  • Thread starter Thread starter Stacy
  • Start date Start date
S

Stacy

I received an error while importing to Outlook. It said that my spreadsheet
has no name ranges and to use Excel to name the range of data. I tried using
help and am now thouroughly confused. Do I have to name each column? I
tried and it did not work. I also tried creating a name with the name box
next
to the forumla bar.

Thanks!

Stacy
 
Stacy said:
I received an error while importing to Outlook. It said that my
spreadsheet has no name ranges and to use Excel to name the range of
data. I tried using help and am now thouroughly confused. Do I
have to name each column? I tried and it did not work. I also tried
creating a name with the name box next
to the forumla bar.
Click to expand...

Select the entire range containing the data you'll be importing. Then enter
something (anything) in the Name box to the left of the formula bar. Save
and close the spreadsheet. Try your import again using the name you chose.
 
Back
Top