Thread: Importing Excel data into Outlook Calendar

Hi,

I have searched quite a bit for a solution to this problem and found lots of information, but I'm still having a problem.

I'm using Excel 2007 and Outlook 2003 BUT I'am saving the excel workbook as compatible with Excel 97-2003.

I have an Excel sheet with shipping-dates from different suppliers. I want this data to be collected and made into reminders on my Outlook Calendar. The data is contained in a range I created called DataforCalendar. The range looks like this.. =Forecast!$O$5:$T$104 (forecast is the worksheet within the workbook).

So after I save the excel document (.xls) I close the program, open Outlook, go to File>Import and Export>Import from another program or file>Microsoft Excel 97-2003

Then I select the document (waterplantproduction2012.xls), hit Next>Calendar.... Then I get the error saying that the document I selected has no Named Ranges... Even though I just saved it with a named range.

What am I doing wrong here?

Any help is appreciated!
Thank you

So you highlighted the area right clicked and named the range? Could you post the workbook or a sample workbook.

Yes, that's what I did. To check, I went to Formulas>Name Manager, and there it was.

Ill post an example for you.

Anyone have an idea?

bump.

Please help