Hi All,
I'm working in Excel 2007 in Excel 2003 compatibility mode in order to share with others using Office 2003 on a long set of pivot tables in a worksheet tab labeled "PTable" that as created off another worksheet labeled "Source Data" for days and all was good.
I open the workbook today and the PTable sheet is formatted like the pivots I had, but now they don't act like pivots tables. When I click on a table, the field list is grayed out. If I right-click on a table, I get no pivot table options, just text formatting options.
I'm in big trouble here and I've search for solutions but came up empty.
Does anyone have some pointers before I start all over again? If I inadvertently did something, I'll be darned if I know what I did. If this is a problem with Excel 2007 saving down to Excel 2003, I'd like to know and I'll keep it in native 2009 format and save a final copy down to 2003 if others have seen similar problems in the past. I'm new to office 2007 but a long time user of Excel since Excel 97 days and this is the first time something like this has ever happened.
Thanks very much!
-Ben
I'm working in Excel 2007 in Excel 2003 compatibility mode in order to share with others using Office 2003 on a long set of pivot tables in a worksheet tab labeled "PTable" that as created off another worksheet labeled "Source Data" for days and all was good.
I open the workbook today and the PTable sheet is formatted like the pivots I had, but now they don't act like pivots tables. When I click on a table, the field list is grayed out. If I right-click on a table, I get no pivot table options, just text formatting options.
I'm in big trouble here and I've search for solutions but came up empty.
Does anyone have some pointers before I start all over again? If I inadvertently did something, I'll be darned if I know what I did. If this is a problem with Excel 2007 saving down to Excel 2003, I'd like to know and I'll keep it in native 2009 format and save a final copy down to 2003 if others have seen similar problems in the past. I'm new to office 2007 but a long time user of Excel since Excel 97 days and this is the first time something like this has ever happened.
Thanks very much!
-Ben
