Calculated items are listed with other items in the Row or Column area of the pivot table. The buttons were greyed out because the outlook client could not contact the CRM server. I have to sign in with the admin credentials from my first company and it takes me to the "glad you're here" page. That will also allow you to check his permissions within CRM. So when I refilter the sheet with new items to get rid of, the old filtered items come back. In this case, we want to add an item to the Region field, so we’ll select an item in that field. By deault the option for settiing print area, rows to repeat and columns to repeat are greyed out if you display the Page Setup dialog via the Print option. I know in SolidWorks there is a way to create a bomb in the assembly and import it into the drawing and then it auto balloons the drawing based on the BOM and everything is super fast and easy and awesome. Im using PowerPivot and pulling data from PowerQuery. Is it possible to grey out any of