| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Linear Mode
