Python about Excel Popup-note that part of your document may contain personal information solutions that the Document Inspector cannot delete

Source: Internet
Author: User

Reference https://www.cnblogs.com/Jacklovely/p/6582732.html

This problem occurs because the workbook contains macros, ActiveX controls, and so on.

The dialog box appears when Excel is set to automatically delete personal information from the file properties when the file is saved. If you want to avoid this prompt, you can set the following:

Excel 2003: Click menu " tools → options → security " to cancel "remove personal information from file properties on save" under "Personal Information options".

Excel 2007/2010: Click theOffice Button (or File menu) →excel options (or options) → Trust Center ,

Click the "Trust Center Settings" button, select "Personal Information Options",

Under document specific settings, deselect remove personal information from file properties on save.

This option is valid only for the current workbook.

Also, this option is dimmed when you create a new workbook, and is available only if you have checked the document with the Document Inspector and deleted the personal information.

Solution:

Pro-Test--excel2013, after the following deletion of the personal information in Excel after this option is saved, no more pop-up windows.

Python about Excel Popup-note that part of your document may contain personal information solutions that the Document Inspector cannot delete

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.