All my work has gone
 

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?
--
Life isa journey not a destination

All my work has gone
 

Try ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sherees" wrote in message
...
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?
--
Life isa journey not a destination