Your Excel file is secretly sharing greater than you assume. Here is verify
You in all probability do not assume a lot about privateness if you’re sending somebody an Excel file. After all, it is only a spreadsheet, and you’ll see what’s on the sheets earlier than you ship it. The factor is, a workbook can really comprise greater than the cells you possibly can see. It would possibly nonetheless have your identify in its metadata, a hidden worksheet you forgot about, or a file path pointing to a folder in your pc.
Excel has a built-in privateness verify
Document Inspector reveals what’s inside your workbook
Excel for Windows has a built-in Document Inspector that checks your workbook for probably hidden, private, or in any other case non-obvious content material. To discover it, go to File > Info > Check for Issues > Inspect Document.
The classes Document Inspector checks range between Excel variations. In my present model, they embody feedback, private data, hidden worksheets and rows, exterior hyperlinks, embedded paperwork, the Data Model, macros, and a number of other much less widespread options.
You can run the inspection with out altering something in your workbook. Excel merely studies what it finds. However, some classes include a Remove All button, and that is the place it is advisable to watch out.
Finding one thing does not routinely imply it’s best to take away it. Some objects are innocent metadata, whereas others could also be important to how your workbook works. Think of Document Inspector as a means of reminding you what is inside your file earlier than you share it.
Before making any modifications, save a duplicate that you should use as your working model. Running Document Inspector itself will not alter your workbook, however a few of its removing actions cannot simply be undone. Make certain you are working within the copy earlier than eradicating something—it is easy to by chance use the unique.
See what Excel shops about you
Your workbook can bear in mind who created it
These are the primary issues I verify when I’m getting ready an Excel file to share. When I publish a workbook alongside a HTG Excel tutorial, I do not need it to nonetheless comprise my identify or different private data, so I take advantage of Document Inspector to seek out and take away it.
Document Properties and Personal Information can embody data such because the creator’s identify, firm, and different metadata. This is among the clearest instances the place I take advantage of Remove All.
I additionally verify Comments, which may comprise usernames and timestamps in addition to the textual content of the remark. Custom Worksheet Properties, Headers and Footers, and Ink can even comprise data chances are you’ll not need to cross alongside.
But you would possibly really need to maintain a few of these objects. A header would possibly comprise helpful branding, for instance, whereas a remark would possibly comprise directions the recipient wants.
Check all the things you have hidden
Hidden doesn’t suggest non-public
Hidden Excel content may be simple to neglect about, particularly in the event you’ve tucked one thing away since you did not need it cluttering up the worksheet. But hidden content material stays a part of the workbook, so it could nonetheless be related if you’re sharing the file. Document Inspector can discover Hidden Worksheets, Hidden Rows and Columns, Hidden Names, Invisible Content, and Active Filters.
A hidden calculation sheet is an efficient instance. You won’t need somebody to see it, however utilizing Remove All deletes the worksheet altogether, which might break formulation that rely on it. Hidden rows or columns can comprise helper calculations, too, and utilizing Remove All can take away their contents.
So when Document Inspector finds hidden content material, take it as a reminder to have a look at what’s there, quite than an instruction to delete it.
Look past the seen worksheets
Some Excel content material lives exterior the grid
Some of the knowledge in your workbook is not seen on any worksheet.
The Data Model can comprise imported knowledge that you simply will not see by scrolling by means of your sheets. PivotTables, PivotCharts, Cube Formulas, Slicers and Timelines can be related to knowledge that is not instantly seen.
Then there’s Embedded Documents, which may comprise whole Word paperwork, PDFs, or different recordsdata with their very own content material and metadata.
These are good examples of why Document Inspector is principally a reminder of what is inside your workbook. If your workbook depends on a Data Model, for instance, figuring out that it is there issues as a result of eradicating it could break relationships, measures, PivotTables, and different performance. Where a class has a More Info button, Excel is providing extra element quite than asking you to take away something.
Check what your workbook connects to
Your spreadsheet can level exterior itself
Document Inspector can discover Links to Other Files, Real Time Data Functions, Long External References, and Custom XML Data.
Links to Other Files are value checking as a result of a file path can reveal greater than you count on, together with folder names, usernames, or details about the place the workbook was saved. If you determine you do not want a hyperlink, go to Data > Workbook Links (or Edit Links in older variations), the place you possibly can change its supply or break the hyperlink.
Long External References are a selected kind of exterior reference with a file path longer than 218 characters, whereas Real Time Data Functions can pull knowledge from exterior the workbook.
These aren’t routinely issues. If your workbook wants an exterior connection, eradicating it might be worse than leaving it in place.
Don’t overlook the code and extras
Some of those options maintain your workbook working
The remaining classes embody Macros, Forms, and ActiveX Controls, together with Content Add-ins, Task Pane Add-ins, Defined Scenarios, and Excel Surveys.
Some of those could also be utterly irrelevant to you. Others could also be basic to a selected workbook. For instance, eradicating a VBA venture as a result of Document Inspector discovered a macro would additionally take away the code that makes that macro work. A situation would possibly comprise modeling data you need to maintain, too.
Before eradicating something right here, be sure you know what position it performs within the workbook. It’s as much as you to determine whether or not it belongs within the model you are sharing.
Prepare the copy you are going to share
Remove what you do not need to ship
After reviewing the Inspector outcomes, make any mandatory modifications to the copy you created in the beginning. Keep the unique someplace protected, so if eradicating a hidden sheet, exterior hyperlink, embedded doc, or different function has an surprising impact, you continue to have the untouched workbook to fall again on.
Then manually verify the seen worksheets, too. Document Inspector will not essentially discover delicate textual content formatted in white, objects lined by different objects, or private data contained inside a picture.
Once you have completed, reopen the cleaned copy and ensure the formulation, PivotTables, charts, macros, hyperlinks, and different options you want nonetheless work. If all the things seems to be good, that cleaned copy is the one you share. You needn’t repeat the modifications on the unique.
Know what you are really sharing
That’s the workflow I take advantage of earlier than sharing an Excel file: I examine a duplicate, overview what Excel finds, take away something I do not need to share, after which verify the completed workbook myself. The level is to grasp what’s really contained in the file earlier than I ship it.
