DashboardNovice
Member
I am refreshing a pivot table. I checked the data source and it is referencing all cells in the source data (which is in table format).
But when I do the refresh, I get a message saying "There is already data in [Workbook].Worksheet. Do you want to replace it?"
The sheet I am working on is not the same worksheet referenced in the error message so I have no idea what this message means.
I have to say, the Excel file has many tabs, each with a pivot table. Is there some upper limit as to how many pivot tables one Excel file can contain? Is this the source of the problem?
But when I do the refresh, I get a message saying "There is already data in [Workbook].Worksheet. Do you want to replace it?"
The sheet I am working on is not the same worksheet referenced in the error message so I have no idea what this message means.
I have to say, the Excel file has many tabs, each with a pivot table. Is there some upper limit as to how many pivot tables one Excel file can contain? Is this the source of the problem?