Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Calandaring (http://www.outlookbanter.com/outlook-calandaring/)
-   -   How can I import Excel file to Calendar (http://www.outlookbanter.com/outlook-calandaring/97343-how-can-i-import-excel.html)

Hunsa November 24th 09 05:11 AM

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

Gordon[_6_] November 24th 09 10:13 AM

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?


Brian Tillman [MVP - Outlook] November 24th 09 02:28 PM

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]


Diane Poremsky [MVP] November 24th 09 08:41 PM

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




All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com