How to stop privacy warning on save in Excel?
If there are some VBA, controls or web components in your Excel file, every time you save the file, it pops out a Privacy warning on the screen as shown as below, and you need to click OK to successfully save the Excel file. Now I can tell you how to stop this Privacy warning popping out in Excel.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
For preventing Privacy warning popping when save every time, let’s go to Options to set a specific option.
1. Open Excel and click File or Office button > Options. See screenshot:
2. Then in the Excel Options dialog, click Trust Center in left pane, and then click Trust Center Setting in right section. See screenshot:
3. Then click Privacy Options from the left pane of Trust Center dialog, then disable the option of Remove personal information from file properties on save. See screenshot:
4. Click OK > OK to close dialogs. Then when you save the Excel file, the Privacy warning dialog will never pops out.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 2 months agoThanks Man...Its working
To post as a guest, your comment is unpublished.· 1 years agoIs there a way to disable this option by default?
With "by default" I mean:
I'm used to right click in Windows Explorer to create new XLSX files. By doing this, these files always have this option enabled and I have to manually disable it for every new file!
Is there also a registry key I can use?
For example I found this:
But it is empty...
Please, need help, this is so annoying!
To post as a guest, your comment is unpublished.· 1 years agoThank its Worked for me :)
To post as a guest, your comment is unpublished.· 1 years agoEvery time i've got a privacy warning, i have been able to remove it, by adding one line of code.
It happens when you create an object in your code, and you dont "erase" it afterwards.
example: I want to add a button in my sheet by using a macro.
btnTemp = ActiveSheet.Buttons.Add(6, 6, 100, 60).Select
This code actually creates an object floating somewhere inside the file, and this is what triggers the warning.
If I add the following code, and runs it agains, the warning is gone.
Set btnTemp = Nothing
So look for any object that have not been erased/reset. That will probably fix it!
To post as a guest, your comment is unpublished.· 2 years agoits working thanks alot :)