Personal Computer by Jobs // PerfectXL Spreadsheet Validation

Excel Risk Inspections

Hidden Information

Hiding “unimportant information” from other users may seem like a good idea to make complex spreadsheets more user friendly. But in reality that’s not the case. Hidden information can be altered by a user, without him even realizing what he’s doing, resulting in potential negative results.

Hidden information in spreadsheets is risky business. When you are working with a spreadsheet while ignoring possible hidden information, you are risking major problems later on.

Hidden formulas

When a cell is formatted to hide its formula in a protected sheet, it’s ambiguous to the user what will happen in the spreadsheet when he changes values, formulas or the structure. It’s better to unhide the formula, by right-clicking the cell range and choose ‘Format Cells’. Then clear the ‘Hidden’ checkbox under the ‘Protection’ tab.

 

Hidden formulas in Excel files // PerfectXL Risk Eliminator

Hidden rows / columns

As with hidden formulas, hidden rows and columns potentially obscure the way a spreadsheet works. Contrary to hidden formulas, columns and rows can be hidden even when the sheet is not protected. You can always unhide rows and columns by right-clicking on the column/row and selecting ‘unhide’.

 

Hidden rows in Excel files // PerfectXL Risk Eliminator

 

Hidden columns in Excel files // PerfectXL Risk Eliminator

Hidden References

While hidden info obscures potentially important information, it is especially risky to add formula or cell references to this hidden information. Hidden information is easily overwritten or forgotten!

 

Hidden references in Excel files // PerfectXL Risk Eliminator

Hidden worksheets

Worksheets that are hidden potentially conceal important information to understand the working of the spreadsheet. To unhide a worksheet, right-click any worksheet and choose ‘Unhide Sheet’. A popup will open, where you can select the sheets you wish to unhide.

 

Hidden worksheets in Excel files // PerfectXL Risk Eliminator

Very Hidden Worksheets

A sheet that is ‘Very Hidden’ gives the impression that it is secure, because users don’t see it when they look for hidden sheets. It can however be modified without any additional authentication! A ‘Very Hidden’ worksheet is considered a high risk by default. PerfectXL reveals any ‘Very Hidden’ worksheets immediately. To unhide ‘Very Hidden’ sheets, you need to open VBA with Alt F11, then go to ‘Properties’, go to ‘Visible’ and choose option “-1 xlSheetVisible”.

 

Very hidden worksheets in Excel files // PerfectXL Risk Eliminator