Document Inspector

broken image


Hey Guys,
I have been working with Excel 2013 for a while and am a bit perplexed by a pop-up I am getting and why I am getting it.
I am using a macro capable workbook so that I can use some macros.
Everytime I save my workbook I get the following error:
'Be careful. Parts of your document may include personal information that can't be removed by the Document Inspector.'
This is followed by the normal 'OK' and 'Cancel' buttons.
This seems to be the only workbook that has this that I know of, but I can't seem to figure out what to google in order to learn about it. I seem to get things matching Document or Upload Inspector.
All help is appreciated.
later
Ty
  1. Potential solutions to the 'Be careful!Parts of your document may include personal information that can't be removed by the Document Inspector.' Warning message. To remove Document Inspector warning in Excel 2016 or Excel 2013 you can check two things.
  2. May 23, 2019 You can use the Document Inspector to remove this information before sharing a workbook with others. Here are the steps: 1. Click the File tab to access Backstage view. From the Info pane, click Check for Issues, then select Inspect Document from the drop-down menu. You may be prompted to save your file before running the Document Inspector.
Document inspector word

The Document Inspector in Word: Overview The Document Inspector in Word lets you remove hidden document data. Accepting or rejecting tracked changes in a document most often removes all tracked changes. However, the Document Inspector in Word lets you review and inspect legal documents for hidden data and hidden tracked changes. The Document Inspector dialog box appears, shown on the left. It lists items you might have overlooked or forgotten about. You can add or remove check marks to direct the inspector to find or ignore specific items. Click the Inspect button. Word scours the document, checking for those items you selected in the Document Inspector dialog box. Select Inspect Document. The Document Inspector dialog box opens. This lists all of the kinds of hidden data you can find in a document. Comments, versions, and revision marks; Document properties and personal information; Task pane add-ins; Embedded documents; Macros, forms, and ActiveX controls; Collapsed headings; Custom XML data.

Lesson 26: Inspecting and Protecting Workbooks

Document inspector ppt

/en/excel2016/track-changes-and-comments/content/

Introduction

Before sharing a workbook, you'll want to make sure it doesn't include any spelling errors or information you want to keep private. Fortunately, Excel includes several tools to help finalize and protect your workbook, including DocumentInspector and the Protect Workbook feature.

Optional: Download our practice workbook.

Watch the video below to learn more about inspecting and protecting workbooks.

Document Inspector

Whenever you create or edit a workbook, certain personal information may be added to the file automatically. You can use Document Inspector to remove this information before sharing a workbook with others.

Because some changes may be permanent, it's a good idea to save an additional copy of your workbook before using the Document Inspector to remove information.

To use Document Inspector:

  1. Click the File tab to access Backstage view.
  2. From the Info pane, click Check for Issues, then select InspectDocument from the drop-down menu.
  3. You may be prompted to save your file before running Document Inspector.
  4. Document Inspector will appear. Check or uncheck boxes, depending on the content you want to review, then click Inspect. In our example, we'll leave everything selected.
  5. The inspectionresults will appear. In our example, we can see that our workbook contains comments and some personal information, so we'll click Remove All on both items to remove this information from the workbook.
  6. When you're done, click Close.

Protecting your workbook

By default, anyone with access to your workbook will be able to open, copy, and edit its content unless you protect it. There are many different ways to protect a workbook, depending on your needs.

To protect your workbook:

Document inspector pdf

Document Inspector Word 2016

  1. Click the File tab to access Backstage view.
  2. From the Info pane, click the Protect Workbook command.
  3. In the drop-down menu, choose the option that best suits your needs. In our example, we'll select Markas Final. Marking your workbook as final is a good way to discourage others from editing the workbook, while the other options give you even more control if needed.
  4. A dialog box will appear, prompting you to save. Click OK.
  5. Another dialog box will appear. Click OK.
  6. The workbook will be marked as final.
Document Inspector

The Document Inspector in Word: Overview The Document Inspector in Word lets you remove hidden document data. Accepting or rejecting tracked changes in a document most often removes all tracked changes. However, the Document Inspector in Word lets you review and inspect legal documents for hidden data and hidden tracked changes. The Document Inspector dialog box appears, shown on the left. It lists items you might have overlooked or forgotten about. You can add or remove check marks to direct the inspector to find or ignore specific items. Click the Inspect button. Word scours the document, checking for those items you selected in the Document Inspector dialog box. Select Inspect Document. The Document Inspector dialog box opens. This lists all of the kinds of hidden data you can find in a document. Comments, versions, and revision marks; Document properties and personal information; Task pane add-ins; Embedded documents; Macros, forms, and ActiveX controls; Collapsed headings; Custom XML data.

Lesson 26: Inspecting and Protecting Workbooks

/en/excel2016/track-changes-and-comments/content/

Introduction

Before sharing a workbook, you'll want to make sure it doesn't include any spelling errors or information you want to keep private. Fortunately, Excel includes several tools to help finalize and protect your workbook, including DocumentInspector and the Protect Workbook feature.

Optional: Download our practice workbook.

Watch the video below to learn more about inspecting and protecting workbooks.

Document Inspector

Whenever you create or edit a workbook, certain personal information may be added to the file automatically. You can use Document Inspector to remove this information before sharing a workbook with others.

Because some changes may be permanent, it's a good idea to save an additional copy of your workbook before using the Document Inspector to remove information.

To use Document Inspector:

  1. Click the File tab to access Backstage view.
  2. From the Info pane, click Check for Issues, then select InspectDocument from the drop-down menu.
  3. You may be prompted to save your file before running Document Inspector.
  4. Document Inspector will appear. Check or uncheck boxes, depending on the content you want to review, then click Inspect. In our example, we'll leave everything selected.
  5. The inspectionresults will appear. In our example, we can see that our workbook contains comments and some personal information, so we'll click Remove All on both items to remove this information from the workbook.
  6. When you're done, click Close.

Protecting your workbook

By default, anyone with access to your workbook will be able to open, copy, and edit its content unless you protect it. There are many different ways to protect a workbook, depending on your needs.

To protect your workbook:

Document Inspector Word 2016

  1. Click the File tab to access Backstage view.
  2. From the Info pane, click the Protect Workbook command.
  3. In the drop-down menu, choose the option that best suits your needs. In our example, we'll select Markas Final. Marking your workbook as final is a good way to discourage others from editing the workbook, while the other options give you even more control if needed.
  4. A dialog box will appear, prompting you to save. Click OK.
  5. Another dialog box will appear. Click OK.
  6. The workbook will be marked as final.

Marking a workbook as final will not prevent others from editing it. If you want to prevent people from editing it, you can use the Restrict Access option instead.

Challenge!

Document Inspector Find And Remove

  1. Open our practice workbook.
  2. Use Document Inspector to check the workbook and remove anything it finds.
  3. Protect the workbook by Marking As Final.
  4. When you're finished, your workbook should look something like this:

Document Inspector Excel

/en/excel2016/intro-to-pivottables/content/





broken image