Hi there

I am using Office 2010 and i want to import an excel spreadsheet with dates and events (in the correct format) into a custom calendar.

Each time i try the import, i am only showed the default calendar to save the information in to.. I have tried all the different options that are published and stuff that i know, but to know avail.

Is there anyone out there that has any ideas or who have successfully done this??



Steve

How did you create the custom calendar?

I'm using Outlook 2010 and I've just been able to successfully import from Excel into a second calendar within my profile without issues. If the custom calendar is not showing up in the Import a File dialog then it may have something to do with how the custom calendar is setup.

The calendar is a shared calendar with its own email address etc

Ok I'd say it would be a permission thing then.

Try running a test, create a second calendar on your own Outlook profile by going into your default Calendar, click the Open Calendar button located on the Home ribbon and select Create New Blank Calendar. Give the new calendar a name such as Test and make sure it will be created within your default Calendar. Click OK and it should appear as an option to view. Now repeat the Import process you tried before and see if it appears as an option to import to. If it does then it's an issue with the permission or setup of the custom calendar. If a specific user created the calendar then that user may need to perform this function from their account but it just depends how and who created the custom calendar.

Thanks. I will give it a go and let you know