I have been sent a file with cells that contain formulas that are delimted
with {} and refer to sheets that are not present. If I try to create sheets
with these names I am told that they exist. Hence a hidden sheet. Any help on
hidden sheets and {}?

Maybe

Format|Sheet|Unhide

Or speak to the developer...

surreyjed wrote:

I have been sent a file with cells that contain formulas that are delimted
with {} and refer to sheets that are not present. If I try to create sheets
with these names I am told that they exist. Hence a hidden sheet. Any help on
hidden sheets and {}?

--

Dave Peterson

Click on Format:Sheet:Unhide then select the sheet you want to unhide.

Hope that helps
--
Dave


"surreyjed" wrote:

I have been sent a file with cells that contain formulas that are delimted
with {} and refer to sheets that are not present. If I try to create sheets
with these names I am told that they exist. Hence a hidden sheet. Any help on
hidden sheets and {}?

If the Format | Sheet | Unhide does not reveal them, they may be "very
hidden" which is a setting usually made from within the VB Editor. But you
can unhide them using VB code easily enough:

Sub UnhideEvenVeryHiddenSheets()
Worksheets("Sheet3").Visible = True
End Sub

change the sheet name as needed, repeat the line of code for each sheet you
need to unhide. I would make a copy of the original file before messing with
these sheets, especially if they are very hidden. The developer obviously
didn't want anyone messing around with them because they are critical to
operation of the visible sheets.

Also, formulas enclosed in curley braces as {} are array formulas, the {}
are not typed in, they are placed around the formula when you enter the
formula with [Ctrl]+[Shift]+[Enter] instead of just the [Enter] key. Any
editing of such a formula requires using that key combination to restore the
curley braces.

"surreyjed" wrote:

I have been sent a file with cells that contain formulas that are delimted
with {} and refer to sheets that are not present. If I try to create sheets
with these names I am told that they exist. Hence a hidden sheet. Any help on
hidden sheets and {}?