Screenshot.pdf While creating pivot table in excel, I do not see ‘Drop page fields here’; ‘Drop row fields here’; ‘Drop column fields here’ & ‘Drop data items here’ in the spreadsheet. I only see ‘To build a report, choose fields from the Pivot Table Field List’, this also does not allow me to drag items from Pivot Table Field List directly on to the spreadsheet.
This is happening only in a specific sheet and not in all the excel sheets. Any idea what could be causing this?
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.