Frank Bacchus
Member
In a Pivot table, we can change the Data Source by pressing the Analyze tab, then Change Data Source (twice) and we will see something like this "general_report!$A$1:$AK$1315". This is the name of my table. I have to constantly change this field to accommodate the increased size of the table. Is there a way to represent this so that I do not have to constantly make this change? I read someplace that "general_report" will work, but it hasn't worked for me. Your suggestion will be very much appreciated. Thanks.
frank
frank