Share via

Can't Select Fields For a PivotTable

Anonymous
2012-06-15T13:17:04+00:00

I have three columns of data that I want to make a pivottable from. If I do this on my computer, it works. I try to do it on another computer and it doesn't allow me to select the fields to be added to the pivottable and the background is completely white in the area that i put the pivottable. Is there a setting in Excel that will cause this to happen on one machine and not another? The user that can't add fields to the pivottable has windows 7. Not sure if that may have something to do with it.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 101.9K Reputation points Volunteer Moderator
2012-06-16T02:15:08+00:00

Hi,

Try this

  1. Right click on any one cell within the pivot table and select Pivot Table Options > Display > Classic Pivot Table Layout
  2. Now try to drag the columns inside the pivot table

Was this answer helpful?

6 people found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest