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.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
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.
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.· 10 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.· 2 years agoThank its Worked for me :)
To post as a guest, your comment is unpublished.· 2 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 :)