If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
How can I import Excel file to Calendar
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 ..xls Please help |
Ads |
#2
|
|||
|
|||
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 .xls Please help Did you look up Named Range in Excel Help? |
#3
|
|||
|
|||
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 .xls 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: http://office.microsoft.com/en-us/ou...102499821033#4 -- Brian Tillman [MVP-Outlook] |
#4
|
|||
|
|||
How can I import Excel file to Calendar
See http://www.slipstick.com/Tutorials/import/import.htm for help with named
ranges. Seee http://www.slipstick.com/calendar/holidays.htm for other options if you will need to install this holiday list in many mailboxes. -- -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: EMO - a weekly newsletter about Outlook and Exchange: Poll: What version of Outlook do you use? http://forums.slipstick.com/showthread.php?t=27072 "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 .xls Please help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HOW TO IMPORT EXCEL FILE INTO OUTLOOK 2003 CALENDAR | CHRIS | Outlook - Calandaring | 1 | July 24th 08 04:09 PM |
How do I import an excel file into Outlook Calendar? | Friarrico | Outlook - Calandaring | 1 | June 21st 06 05:05 PM |
How do I import an excel file into Calendar? | Kent McLellan | Outlook - Calandaring | 2 | June 7th 06 07:37 PM |
excel file type missing from import a file window in outlook | xanadufl | Outlook - Using Contacts | 9 | February 28th 06 09:55 AM |
Import an Excel file into Calendar | Bobmeister | Outlook - Calandaring | 0 | January 12th 06 07:36 PM |