Hello, I am using the export to spreadsheet for a Calendar List by going to Actions > Export to Spreadsheet. See screengrab: http://i31.tinypic.com/2d0hnr5.jpg On this July view of my list (All Events) there are 16 items displaying, but there are hundreds of items in this list across the months. When I export to spreadsheet, i get prompted for a login/password, which i provide. I get a little owssrr.iqy file that queries the SharePoint server and i get a spreadsheet that looks like the following: http://i29.tinypic.com/2i0ww5.jpg There are 21 items in the spreadsheet, not 16 as i might expect. Is there a way to specifiy all the items in the the Calendar list across months or some other way to specify? Thank you for any info you might be able to provide. Will

Hi, I think you can filter the calendar and then export it. And the following are the steps to filter: 1. Create two calculated fields (value as integer): month of start time (formula: =month([start time])), year of start time(formula: =year([start time])). 2. Go to list settings > all event view > filter section > set your filter condition using both of two new fields. Hope it is helpful!Seven