Forum Discussion
How to copy a sheet and keep all its properties
Hello dear all, I made an EXCEL sheet (named Sheet1) in which I fill up a table manually. This table is the data source of several pivot tables and charts, also located in Sheet1. I would like t...
You might run the macro listed in Copy worksheet with embedded pivot tables and have pvito tables point to data in new tab not original tab
Dear HansVogelaar
Thanks a lot for your anwer. Unfortunately the VBA macro describes in this post is obsolete, it is not working. However I will keep looking in that direction.
Regards,