Selected Answer
You can remove the Pivot Table menu from the Ribbon's Insert tab.
- From the Ribbon's File tab, select Options.
- Choose Customize Ribbon.
- On the right side of the dialog box that opens, find the Insert tab and expand it.
- Select the Tables item. Take a look at which buttons are in that menu.
- Right-click and choose Remove.
- Click OK. This will remove the button from the menu.
I believe the change will affect Excel as a whole, meaning the button will remain invisible for all workbooks of all users.
To restore the button I suggest the following steps.
- From the Ribbon's File tab, select Options.
- Choose Customize Ribbon.
- On the right side of the dialog box that opens, find the Insert tab and select it.
- Near the bottom of the dialog box, click the Reset button.
- Select Reset only selected Ribbon tab.
- Press OK.
I realise that the above is a far way from what you imagined. Please look at this site to get a better understanding of the complexity of what you ask.
However, there may be other methods you might employ to achieve your aim, if you can re-define it. For example, you might argue that you don't care how many pivot tables someone creates in your workbook so long as the file isn't altered. This thought would enable you to seek solutions either preventing changes from being saved or by only distributing copies while the original remains in your possession.