When trying to pull info. from a pivot table rec'd. following message: "This action will overlap the pivot table "pivot table 11" with data already in the sheet "schedule" . Make space and try again. How do I fix this?
When trying to pull info. from a pivot table: "This action will overlap the pivot table "pivot table 11" with data already in the sheet "schedule" . Make space and try again. How do I fix this?
This error message occurs when data overlaps with a pivot table. To fix this issue, you need to make space for the data by moving the pivot table to a different location on the worksheet.
To do this, you can follow these steps:
1. Click on the pivot table to select it.
2. Find the [pivot table11] and drag it to a new location on the worksheet where there is enough space for the data you want to paste.
Here is the PovitTable name.
Question Info
Last updated February 5, 2025 Views 2,305 Applies to: