I have a problem with “create Pivot Table”.
When I tried to create a pivot table, it always came an error that “could not create Pivot table with the specified name”. At first, I thought I might use it a wrong way or gave a wrong variable name as the pivot table name.
However, I downloaded the official example of “create pivot table” and the first run it seems everything alright. Then I just tried to change its pivot name with adding a number like “ExamplePivot → ExamplePivot2”, the error comes again.
I changed it back to the original variable name, and the error still appeared.
Could anyone point out my mistake or how to solve this issue?
Thanks in advance.