View Single Post
Old November 24th 09, 01:28 PM posted to microsoft.public.outlook.calendaring
Brian Tillman [MVP - Outlook]
external usenet poster
Posts: 4,874
Default How can I import Excel file to Calendar

"Hunsa" wrote in message

I want to import excel file to calendar, which contain our company holiday,
but after I import and select file, it shown " Has no named range in
Microsolf 2003", what I'm wrong, and what it's meaning? This file saved as

To name a range in Excel, select all the rows and columns containing the data
you want (that's the range), then enter some name into the Name field to the
left of the formula bar (where you usually see the cell name when you have a
single cell selected. Save the sheet. You've now named the range.

An alternative to this is to create a holiday file with the company holidays
in it. See this:
Brian Tillman [MVP-Outlook]