Remember to save this workbook under another name otherwise you will lose all the information that you removed from your original Workbook. Once you click the remove all you can also Reinspect the document by clicking Reinspect, or you can close the dialog box. To concatenate the values in A1, B1, and C1, you can use a range like this: However, the CONCAT does not. The main benefit of CONCAT over the older CONCATENATION function is the ability to concatenate ranges. You will have a Remove All button next to the sections that have found information in them. Use the TEXT function to apply formatting during concatenation: CONCAT('The date is ',TEXT( A1,'mmmm d')) // 'The date is July 1'. This will give you the opportunity to decide if you want to remove certain sections. This will remove them for you if you want.Īfter you have run the inspection you will get a second dialog box that appears. These are invisible object that you may have no one can see them because they have been formatted to be invisible. Much like the hidden rows and columns, although this will delete hidden Worksheets.Ī. In Excel, we are unable to print the hidden information that is removed by Document Inspector. If you have hidden Rows or Columns that no one should see if you are sharing the information in this Workbook this will remove these hidden items.Ī. The Document Inspector displays different sets of Inspectors in Office Word 2007, Office Excel 2007, and Office PowerPoint 2007 to enable you to find and remove hidden data and personal information that is specific to each of these programs. Information saved in the Header and Footer Sections you can remove here.Ī. It serves to decrease the file size and reduce the possibility of corruption of the newer files that are created.) There are some portions of this that the file does not really need for the operation of the file and it can be removed without degrading the file in any way.Ī.
Where is document inspector in excel code#
XML (Extensible Markup Language, a form of code that the newer versions of Microsoft Office use that is Human readable and Machine readable. Such as the Author of the document, the date that the document was created, and the location on a computer or network that the document was created).Ī. Document properties also known as Metadata (Data about data. If you have used any collaboration tools (we will talk about these later) it will check for this information. Once pasted, crop the image to only keep the table’s picture, and you’re good to go.A. This can easily be done by capturing an image of the table using the PrtScr key on the keyboard, and then pasting it in PowerPoint. Microsoft suggests that you save the picture of the table, and show the picture instead of using the actual table. The Document Inspector helps you find and remove data that is intentionally or mistakenly hidden.
In Office 2010 or 2013, you should be able to find similar options under the Info tab under the File menu. Open PowerPoint and click File on the ribbon toolbar.Ĭlick the Inspect Presentation button in PowerPoint 2013 You can use a tool built into PowerPoint called the document inspector tool to tell you what you’re sharing with others along with the PowerPoint file.
Where is document inspector in excel how to#
How to Know About All the Data Included in the PowerPoint File? You can risk exposing important data behind the calculations. Copying basically embeds the Excel data in PowerPoint. This happens quite often because people commonly use the simple copy and paste method to get data from one place to another. When you copy a table or sheet from Excel to PowerPoint, you are also copying the meta data that made these calculations possible. How Does This Excel Data Get Into PowerPoint? Here, we will talk about using the PowerPoint document inspector to find hidden data in PowerPoint slides that, in many cases, can get you in trouble. This happens when you normally copy it from Excel. All the numbers behind the calculations are also embedded in the PowerPoint presentation. People in many organizations use Excel data without realizing an important fact. Often, these PowerPoint presentation files are also emailed to prospective clients. A vast majority of all PowerPoint presentations include data from Excel sheets.