All my work has gone

[Sherees]

I was working on more tthan 20 sheets, inserted many "if " formulas, and
tested and everything was ok, now after i close the programme n i open the
formula is no more working, i hide the columns in excel which was connected
to my formula, Is that the reason why the formula is no longer functioning?
how to unhide all of the sheets that i hide in one click?

 

[Niek Otten]

Try Tools>Options>Calculation tab, check Automatic