Formula containing tab that is not there?

[EXCEL40294]

Hello..

Simple question. I was tasked to take over a project from someone else and their Excel spreadsheet was sent to me for modifications, updates, etc.

The person who created this file used "COUNTIFS" that referenced tabs that are not there (yes, I tried "unhiding"). It does not look like it is referencing a completely different worksheet because it looks like, "COUNTIFS('ABC1'!$A:$A,"Apple",'ABC1'!,$B:$B,"Orange"..." etc.

I looked at the visible and for any hidden tabs called "ABC1", but it is not there. However, the data still seems to populate as it should. Am I missing something?

[Jonmo1]

Sounds like it's a 'Very Hidden' sheet (yes there is such a thing)

Right click on any tab, and choose 'View Code'
In the Top Left area of the VBA window, there is a list of all the sheets in the book.
Find and select the one named ABC1
Now on the Bottom Left there is a list of all the properties of the sheet (if it's not there, click View - Properites Window)
At the bottom there is the 'Visible' property.
Set it to xlSheetVisible

[EXCEL40294]

Sir, you are absolutely right. I would never have thought to look at the code properties, but yes, you are right!

I also tried to "Google" this issue, but I had no idea where to start or how to enter such an inquiry. Thank you very much for your help!

[Jonmo1]

You're welcome.