Imports from Excel
in [Calendar]
|
Prev: how to unregister an email from passport linked to calender?
Next: share custom calender from 2007 to 2003 client problems
From: Peter646 on 3 Mar 2010 01:23 I'm trying to import an excel file into an outlook calendar. It goes through the process (without error), yet nothing appears on the calendar. I first exported an appointment from the calendar so I could get the format then I changed a few things and re-imported but nothing appeared. I've tried Excel workbook and csv and all times it appears blank. Outlook is online. In Excel format, the data is in a named range. "Tina" posted a similar query on 18 July 2007; in her case the issue resolved with restarting Outlook. I've also tried this without result.
From: Diane Poremsky [MVP] on 3 Mar 2010 07:14
Is all of the data in the named range? If you didn't re-do the named range after exporting, the range is the size of the export. Or - rather than using a named range, save from excel as CSV format and import it. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dailytips-subscribe-request(a)lists.outlooktips.net EMO - a weekly newsletter about Outlook and Exchange: mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST(a)PEACH.EASE.LSOFT.COM How many email accounts are in your main Outlook profile? http://forums.slipstick.com/showthread.php?t=36602 "Peter646" <Peter646(a)discussions.microsoft.com> wrote in message news:81D001D5-AF44-48BE-907D-1638D4F60B39(a)microsoft.com... > I'm trying to import an excel file into an outlook calendar. It goes > through > the process (without error), yet nothing appears on the calendar. > > I first exported an appointment from the calendar so I could get the > format > then I changed a few things and re-imported but nothing appeared. I've > tried > Excel workbook and csv and all times it appears blank. > > Outlook is online. In Excel format, the data is in a named range. "Tina" > posted a similar query on 18 July 2007; in her case the issue resolved > with > restarting Outlook. I've also tried this without result. |