This doesnt seem to be an option in Excel 2010. When i right click on the pivot table i get an "options" menu, however change data source is not available???