Shifting Objects

[tmagz]

I'm trying to add a pivot table into an existing worksheet. When the wizard ends, i get "Cannot shift objects off sheet". I saw prior posts about changing the size with cells for the object, but I can't seem to find where to do this for a pivot table. I added a pivot table to a different sheet in the same workbook without any issue.

 

[schielrn]

Are there maybe more than 255 columns that it will not fit on the worksheet you are trying to put it on?

The item in the column field if there is one, are there more than 255 items?

 

[tmagz]

Sorry guys. There was protection turned on that was locking the formatting.