A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Calandaring
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I import Excel file to Calendar



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 24th 09, 04:11 AM posted to microsoft.public.outlook.calendaring
Hunsa
external usenet poster
 
Posts: 1
Default 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  
Old November 24th 09, 09:13 AM posted to microsoft.public.outlook.calendaring
Gordon[_6_]
external usenet poster
 
Posts: 896
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
.xls
Please help


Did you look up Named Range in Excel Help?

  #3  
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
.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  
Old November 24th 09, 07:41 PM posted to microsoft.public.outlook.calendaring
Diane Poremsky [MVP]
external usenet poster
 
Posts: 12,991
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.