CODEWITHSUNDEEP
excelexcel-formula
Mark Tait
Mark Tait

Reputation: 643

Can't find data referred to in an Excel formula

I've inherited a spreadsheet with no instructions.

There is a formula in one of the cells:

=IFERROR(ROUND((SUM('RawData'!C:C)/K21)*24*60*60,0),0)

There are no hidden tabs - so I'm guessing 'RawData' is a named reference of some sort.

Is there any way for me to find out where the data is referred to in 'RawData'?

Thanks for any help, Mark

Upvotes: 0

Views: 452

Answers (2)

cybernetic.nomad
cybernetic.nomad

Reputation: 6398

Running the following VBA will also unhide all sheets:

For Each Sht In Application.Worksheets
    Sht.Visible = True
Next Sht

Upvotes: 2

Scott Craner
Scott Craner

Reputation: 152555

The worksheet RawData will be a Very Hidden sheet. That means it will not show up in the the normal hide/unhide dialog in Excel.

You will need to use the VBE(Alt-F11) Then Ctr-r if the project Exploreer is not already visible.

Find the sheet in the list click it and change the hidden aspect in the properties of that sheet.

enter image description here

Upvotes: 3

Related Questions