I have an excel workbook (MSO 2003) that I have converted to an xlsm file in 2010, that contains pivot tables sourced from an access database. I have converted the access database (also 2003) to an accdb file in 2010 and need to update the pivot table connection sources to point to this newly converted db. Everytime I go in to update the pivot table connection source, the pivot table refreshes without the field that should be in the row label section. I can easily add the field back into the table, but I am wondering if anyone can explain why this might be happening? I have performed this conversion and connection updating on other spreadsheets and the pivot tables all seem to be fine. Any ideas??