Hi guys, please help me. I need to expand my Excel pivot table without overwriting the other pivot table below. Is it possible to do this using VBA? Would anyone have the code? I need that when I click the button to expand the data, the other table below is "pushed" so that it doesn't overwrite. Currently, if I click the table button to expand or collapse, I will get an error saying "A pivot table cannot overwrite another pivot table". I need to fix this.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Expand Excel PivotTable without overlaying another PivotTable (VBA)
- Thread starter rairls
- Start date
-
- Tags
- pivo- table pivot table vba
Hi guys, please help me. I need to expand my Excel pivot table without overwriting the other pivot table below. Is it possible to do this using VBA? Would anyone have the code? I need that when I click the button to expand the data, the other table below is "pushed" so that it doesn't overwrite. Currently, if I click the table button to expand or collapse, I will get an error saying "A pivot table cannot overwrite another pivot table". I need to fix this.
Excel Facts
Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Similar threads
- Question
