---
title: "What to Look for in Another User’s Excel Workbooks - Get a Free Network Security Consultation in South Florida"
description: "Microsoft Excel is the most popular spreadsheet program in the world. Learning the best ways to use it can be beneficial to you company and for individuals alike."
url: "https://www.l7solutions.com/blog/what-to-look-for-in-another-user-s-excel-workbooks"
date: "2026-06-20T02:34:44+00:00"
language: "en-GB"
---
## Get a Free Network Security Consultation in South Florida
Get a free network security consultation today from L7 Solutions. We are your partner for managed services & IT support in South Florida and beyond. Call today.
[ Categories ](https://www.l7solutions.com/blog/categories "Categories")
[ Tags ](https://www.l7solutions.com/blog/tags "Tags")
[ Categories: All Categories ](https://www.l7solutions.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://www.l7solutions.com/javascript:void(0);)
# What to Look for in Another User’s Excel Workbooks
[IT Blog](https://www.l7solutions.com/blog/categories/it-blog)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
Wednesday, 26 June 2013
[ 0 Comments ](https://www.l7solutions.com/blog/what-to-look-for-in-another-user-s-excel-workbooks#comments)
[](https://www.l7solutions.com/images/easyblog_images/4072/Excel400.png "Excel400.png")Collaborating with a team to complete a project helps everything go smoothly. Although, poor communication and mistakes can actually make the project drag on. Passing on a Microsoft Excel workbook from one employee to another is an example where communicating all the details can help. Here are three important steps to take when inheriting an Excel workbook
**Unhide Everything**
Different people have different ways that they will go about making a workbook. The first thing you will want to do when inheriting a workbook is to unhide everything to see if the previous owner has hidden any vital data. Unhiding an Excel sheet is as easy as **right clicking any tab** and choosing **Unhide**. You can also unhide all columns and rows in a sheet by **selecting the entire sheet**, clicking on the **cell selector**, then right-click **any column header** and choosing **Unhide**.
**Remove Hidden Formats**
Excel has a Hidden format protection scheme that hides the formula in the Formula bar while keeping the cell visible. To view this Hidden format, you will want to unhide any hidden cells by **unprotecting the sheet** to view formulas. It's important to keep in mind that some users will attempt to hide the text in a cell by making their text the same color as the background. You will want to check on this by **selecting the entire sheet** and then **applying a new font color**. This should expose any hidden text; be sure to hit the **Undo button** if you wish to hide everything in the way you found it. Hiding text with this way is not a best practice, if your colleague is doing this be sure to tell him to stop.
**Spot Formula Inconsistencies**
Be sure to pour over the formulas of your workbook and be on the lookout for inconsistencies. For example, if column K is the sum value in rows 1-10, and you see a formula that looks out of place in K5, then you will want to do some investigating to find out why. Also, be sure to look at the formulas below the data range. The contiguous formulas should all be similar in purpose.
One last thing you can do to help ensure that the formulas in place are correct, is to run a few tests with known results. For example, total up recent invoices to see if the totals you know to be correct, and the totals in the inherited Excel project, are lining up.
By looking for inaccuracies of your inherited Excel workbook, you can save yourself and everyone involved on the project a lot of time and headache from having to build off the mistakes of others.
[ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);)
Tags:
[Quick Tips](https://www.l7solutions.com/blog/tags/quick-tips) [Microsoft Office](https://www.l7solutions.com/blog/tags/microsoft-office) [Excel](https://www.l7solutions.com/blog/tags/excel)
[ Use Rhythm for Better Sleep ](https://www.l7solutions.com/blog/use-rhythm-for-better-sleep)
[ Hot Off The Press: The Remember Ring ](https://www.l7solutions.com/blog/hot-off-the-press-the-remember-ring)
About the author
[  ](https://www.l7solutions.com/blog/blogger/l7-admin)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
[ ](https://www.l7solutions.com/javascript:void(0); "Subscribe to updates from author") [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/blog/blogger/l7-admin)
Welcome to LSeven's Blog! Here we will share useful tips and tricks for Computers and Information on Our IT Services!
Author's recent posts
[More posts from author](https://www.l7solutions.com/blog/blogger/l7-admin)
[ Tuesday, 30 June 2026 Stop Managing Metal, Start Managing People: A Guide to Hybrid IT ](https://www.l7solutions.com/blog/stop-managing-metal-start-managing-people-a-guide-to-hybrid-it)
[ Saturday, 27 June 2026 Free AI is Not Free: Why Public Tools Are a Security Risk ](https://www.l7solutions.com/blog/free-ai-is-not-free-why-public-tools-are-a-security-risk)
[ Thursday, 25 June 2026 Phishing is Getting Sophisticated: The New Threats Businesses Face ](https://www.l7solutions.com/blog/phishing-is-getting-sophisticated-the-new-threats-businesses-face)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://www.l7solutions.com/component/users/login?return=aHR0cHM6Ly93d3cubDdzb2x1dGlvbnMuY29tL2Jsb2cvd2hhdC10by1sb29rLWZvci1pbi1hbm90aGVyLXVzZXItcy1leGNlbC13b3JrYm9va3M=&Itemid=101)
Saturday, 20 June 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**
## Schema
```json
{
"@context": "https://schema.org",
"@type": "BreadcrumbList",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"name": "Home",
"item": "https://www.l7solutions.com"
},
{
"@type": "ListItem",
"position": 2,
"name": "Blog",
"item": "https://www.l7solutions.com/blog"
},
{
"@type": "ListItem",
"position": 3,
"name": "LSeven Solutions Admin",
"item": "https://www.l7solutions.com/blog/blogger/l7-admin"
},
{
"@type": "ListItem",
"position": 4,
"name": "What to Look for in Another User’s Excel Workbooks",
"item": "https://www.l7solutions.com/blog/what-to-look-for-in-another-user-s-excel-workbooks"
}
]
}
```