Hidden data in Excel files: what a workbook holds that you cannot see
Comments, hidden sheets, document properties, links, pivot caches and more can travel inside an Excel workbook. This guide lists where to look, what the built-in inspector misses, and how to check a file before it leaves your hands.
A spreadsheet looks like a grid, but an Excel workbook is a container. It can hold sheets you cannot see, notes attached to cells, the name of the person who last saved it, links to files on your network, and the stored data behind a pivot table. Any of these can carry information you did not mean to share.
Key terms
- Workbook
- an Excel file, which can hold many sheets.
- Hidden and "very hidden" sheet
- a hidden sheet is hidden from view but can be shown from a menu. A very hidden sheet does not appear in that menu at all.
- Document properties (metadata)
- information about the file rather than in its cells, such as author, company, title, and the last person to save it.
- Pivot cache
- a copy of the source data that a pivot table keeps so that it can be refreshed and rearranged.
- External link
- a reference from a cell, chart, or name to another workbook or data source, stored with a file path.
- Defined name
- a label for a cell or range, used in formulas, which can point to cells you do not see.
Has hidden data caused real trouble?
Yes. In September 2008, Barclays Capital agreed to buy part of Lehman Brothers' business. A lawyer for Barclays converted a spreadsheet to a PDF to file it with the bankruptcy court before a deadline. The spreadsheet had rows that Barclays had hidden because it did not want those contracts in the deal. The conversion ignored the hiding. As a result the filing listed 179 additional contracts that Barclays had not meant to take on. It later asked the court to correct the agreement.
The lesson is not about PDFs. A hidden row is a presentation setting. The data is still in the file, and any tool that reads the file rather than the screen can read it.
Where should you look?
| Where | What it can hold | How to check |
|---|---|---|
| Comments and notes | Remarks about people, prices, internal opinions; the commenter's name | Review tab, show all comments |
| Hidden rows and columns | Anything, including whole data tables | Select all, then unhide rows and columns; look for gaps in the row and column numbers |
| Hidden sheets | Source data, lookups, personal lists | Right-click a tab and choose Unhide |
| Very hidden sheets | The same, with no menu entry | Only by the Visual Basic editor or a macro. See the deep dive |
| Data far from the visible area | A stray value in row 10,000 or column 1,000 | Press Ctrl+End to jump to the last used cell |
| White text, tiny text, shapes covering cells | Text the eye does not see | Select all and change the font color; move shapes aside |
| Document properties | Author, company, manager, last saved by, file paths, template names | File, Info, then Properties |
| Defined names | References to cells and external files | Formulas tab, Name Manager |
| External links and data connections | File paths and server names; a connection string can include a user name and other details | Data tab, Queries and Connections, Edit Links |
| Pivot tables and their caches | A copy of the source data, which can remain after the table is deleted | Check the PivotTable options for saving source data with the file |
| Filters and sort states | Values that were filtered out | Clear all filters |
| Charts and embedded objects | A stored copy of the data behind the chart; pasted objects keep their source data | Open the chart's data; remove embedded objects |
| Headers, footers, print settings | Names, paths, printer names | Page Layout, Page Setup |
| Macros | Code and comments inside it | Save as a macro-free workbook |
What is inside an .xlsx file
A modern Excel file with the extension .xlsx is a ZIP archive of XML files, defined by the Office Open XML standard. If you make a copy and change its extension to .zip, you can open it and see the parts. Names you will meet include:
xl/workbook.xml: the list of sheets and whether each is visible, hidden, or very hidden, and the defined names;xl/worksheets/: one file per sheet, with the cells, including those in hidden rows;xl/sharedStrings.xml: the text strings used in cells;docProps/core.xmlanddocProps/app.xml: author, company, last saved by, and similar properties;xl/commentsand related parts: notes and comments;xl/externalLinks/: links to other workbooks;xl/pivotCache/: the stored data of pivot tables;xl/connections.xml: data connections.
Reading these is a good way to see what is really in a file. It is also how other programs and AI services read your workbook: they read the parts, not the screen.
Does Excel's own inspector catch all of it?
Excel has a Document Inspector (File, Info, Check for Issues) that finds and can remove comments, document properties and personal information, headers and footers, hidden text, custom XML data, and invisible content. Microsoft recommends running it on a copy, because removed data may not be restorable and may not be undoable.
It does not catch everything. Microsoft's own guidance lists what it misses. The list includes white text on a white background, shapes covered by other shapes, and data in distant rows or columns. It also includes pivot table caches that remain after the pivot table is deleted, database connection strings with user names and paths, file names and file paths, VBA code and comments, and hyperlinks in ordinary cells.
Can very hidden sheets be seen?
Hidden and very hidden sheets
Microsoft documents two levels. A hidden sheet is hidden from the tabs but listed in the Unhide dialog. A very hidden sheet is set through a macro or the Visual Basic editor, and it is not listed in the Unhide dialog at all. Anyone who opens the workbook's structure, in a spreadsheet library, in a script, or in an AI service that parses the file, sees both, along with their cells. A very hidden sheet protects nothing: it only keeps the sheet off the menu.
How do you remove hidden data?
Work on a copy, and use more than one method.
What does DataAttendant do with a workbook?
DataAttendant reads an Excel file in your browser and treats each sheet as a part of the file, including hidden sheets, which are labeled as hidden. Some parts of a workbook cannot be examined value by value, such as links to other workbooks, images and embedded objects. DataAttendant lists them in the review and lets you choose to remove them or keep them after looking at them. For charts, it lets you keep the chart and remove its stored values, or remove the chart. Where a removed column is referred to by formulas or names, it keeps the column empty instead of risking a damaged file, and says so. It does not read your mind: check the result in your own spreadsheet program before you share it.
Sources
- The Register, "Lehman buyout Excel confusion," 15 October 2008, and related reports on Barclays Capital's court filing of 18 September 2008 (a spreadsheet with hidden rows converted to PDF; 179 contracts listed in error). Read 19 October 2026.
- Microsoft Support, "Remove hidden data and personal information by inspecting documents, presentations or workbooks," and the Microsoft Office Resource Kit blog, "What Document Inspector doesn't catch." Read 19 October 2026.
- Microsoft, "Hide sheets and use the xlVeryHidden constant in a macro," Microsoft Learn. Read 19 October 2026.
- Microsoft Support, "Save a workbook to text format (.txt or .csv)": only the active sheet is saved, and formatting is removed. Read 19 October 2026.
- ECMA-376 / ISO/IEC 29500, Office Open XML: the file format of
.xlsx.