Reverse engineering Excel workbooks — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Reverse engineering Excel workbooks

Get PDF file

by on
in Excel Training

There are many good reasons to reverse engineer an Excel workbook. Let’s take a look at how to decode the structure of a workbook. Then, we’ll see how to demystify tricky formulas. Finally, we’ll take a peek at how to reveal workbook linkage to other workbooks.

Decoding the structure of a workbook

You should take two actions to make sure you see all the worksheets in a workbook. First, right-click any worksheet tab at the bottom, and choose Un­­hide ... if it is active. If it is not active (grayed out), there are no hidden worksheets. Another possible explanation is that workbook structure protection has been turned on. Click on the Review tab and, in the Changes group,  check to see if the Protect Workbook button is highlighted. If it is, try clicking it to turn it off. If a password was set when protection was originally turned on, you’ll need it to unhide worksheets. With all the worksheets unhidden, right-click on the VC...(register to read more)

To read the rest of this article you must first register with your email address.

Email Address:

Leave a Comment

 

Previous post:

Next post: