| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to correct a "#VALUE!"
I just completed a workbook (two worksheet) with help from some very nice
group members. Now I want to create a master template. In the user input cells,I deleted the data used to create the workbook in the first place. Now where the answers should be I get this "#VALUE!" and one of the cell has a "#DIV/0" and other cells that has the same formula, shows a "0" which I don't mind. Why would I get this answer in some cells and not in other cells. Also I would like to lock this workbook to prevent changes of the formulas by other staff members and still allowing them to use the workbook. Can someone help with my request? Many thanks in advance. Serge |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Running auto correct on startup? | Excel Discussion (Misc queries) | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
Threaded Mode
