Excel 2007 Pivot Tables - Page Field Row Height; Disable Select MultItems
 

Hi all,

Hoping for a bit of help with pivot tables in Excel 2007.

1. Is there a way to keep the page field row heights constant? As it
is now, as you select different options, the row height shrinks or
grows - looks a bit unprofessional.

2. Within the page fields, there is an option to "Select Multiple
Items." Is there a way to disable this option? My pivot tables will be
going to folks with very limited Excel skills, and I don't want them
accidentally selection multiple options.

Thank you!!

Jill