Assistance in Solving an Excel Problem that I am Encountering

elo0707 

Within  my workbook, i have about 20 tabs and i like to make each tab unique and reflect what is needed.  My  style is to hide all unnecessary columns and rows only reflecting my analysis within each tab.

..... Do you guys have any best practices in how to bypass or fix this problem?

Others may have other ideas, for sure. I do notice, however, that you've had nearly 50 views and no replies, so decided I'd jump in to ask whether you're open to questioning your "style." That is to say, are you open to re-thinking how you approach the design and working of your workbook?

The reason I ask is that this practice of hiding and revealing various aspects of a spreadsheet seems like an approach almost sure to result in errors over time. My perception or expectation (or "assumption")--whichever word makes most sense--my assumption is that you've chosen to display what I am calling Output (summary data/ status report/etc) and are hiding some of the raw data and processing. Since you introduce the term "best practice" I think it's accurate to say that it's the very procedure you're following that would NOT be considered "best practice" when it comes to design.

Instead, I'd suggest separating the workings or aspects of the worksheet so that there are discrete areas for raw data (Input), Process, and Output.  You could be more certain of integrity and reliability of the resulting report (Output) AND, at the same time, be able to review the Input and Process sections if you kept them visible but "off to the side" in some form or other--on a separate sheet or separate section of the same sheet.

Is it possible for you to post a copy of the actual workbook on OneDrive or GoogleDrive, with a link pasted here that grants edit access? Or post it here..... That would make it easier to look at the full functioning workbook; images have distinct limitations when it comes to understanding what you're working with.