missing hidden sheets

[jakwi]

I'm trying to understand an excel sheet that I inherited.

Some of the formulas reference a worksheet that simply doesn't exist in the workbook. I've tried every way I can think of to unhide sheets and the options are always grayed out, in my mind meaning they don't exist.

I tried using the trace precedents which applies an arrow to the icon of a spreadsheet

Below is an example of the a formula that references the non-existing sheet

This formula is on a sheet named Monthly, not that that matters.

= ((23 * ((Calcus!f56+1)-(Calcus!O2+1)) / (1.2-(Calcus!f56+1))) * ((Calcus!O2+1) / 0.8))/100

I've even tried typing the cell id Calcus!F56 in the cell box, not sure what the actual name for this is, to take me there, but that doesn't work at all.

I'd like to look at the sheet to see how these cells are calculated, but worse I don't understand how the formula works at all if it references a worksheet that doesn't exist.

Is this a VBA thing that I am missing?

thanks for the help

 

[Joe4]

Sounds like the sheet is "very hidden".
See: https://www.ablebits.com/office-addins-blog/2017/12/20/very-hidden-sheets-excel/

 

[jakwi]

Sounds like the sheet is "very hidden".
See: https://www.ablebits.com/office-addins-blog/2017/12/20/very-hidden-sheets-excel/

See I knew you guys would be able to tell me the answer!

So I see the very hidden sheets, but when I try to change the visible property I get the following error.


"Unable to set the Visible property of the Worksheet class"

Is there a way to overcome this?

Thanks for the help!

 

[Joe4]

As it says in the link, they can only be unhidden by using VBA.
Did you follow the instructions in the "How to unhide very hidden sheets in Excel" section of that link?
Hopefully, they did not password protect the VBA code, or else you may be out of luck!

 

[jakwi]

At this point it looks like the workbook is protected, so I'm trying to figure out how to get pass the password, is that even possible in Excel 2016?

 

[jakwi]

Got it. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; white-space: inherit;"></code>