Named Cell Using =Setup

Copper Contributor

I am trying to edit a spreadsheet created by a previous employee.  There are named cells where the formula is shown like this as an example.  =Setup!A53  I have done named cells from specific cells on a worksheet but have not seen this and there is no worksheet called Setup.  Any suggestions?

1 Reply

@pgander 

It looks like there is a worksheet named Setup, but it has been hidden.

Right-click any of the sheet tabs. Is the Unhide... item in the context menu enabled? If so, click it, select Setup and click OK.

If that doesn't work:

Press Alt+F11 to activate the Visual Basic Editor.

If necessary, expand Microsoft Excel Objects in the Project Explorer pane on the left.

If you see Setup there, select it.

Change the Visible property in the Properties pane on the left to -1 - xlSheetVisible.

Then switch back to Excel.