I have several pivot tables with a data source of $I:$BF. It should be $A:$BF.

When I select Change Pivot Table Data Source and make the change in the box I get a "The Pivot Table field name is not valid" message.

What am I doing wrong? How can I easily change the data source? Can I make this change for multiple tables or must they be done individually?

Thanks!