Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS PROTECTION IN EXCEL WORKSHEET
Please can you let me know if I can protect and hide several formulas in a
worksheet, yet allow the user to still input data and modify data once the formulas have been protected? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS PROTECTION IN EXCEL WORKSHEET
Tools Options Spelling AutoCorrect Autocorrect and remove the
correction If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Please can you let me know if I can protect and hide several formulas in a worksheet, yet allow the user to still input data and modify data once the formulas have been protected? Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS PROTECTION IN EXCEL WORKSHEET
Oops..The below is a wrong post.. To your question.......try the below..
Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Tools Options Spelling AutoCorrect Autocorrect and remove the correction If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Please can you let me know if I can protect and hide several formulas in a worksheet, yet allow the user to still input data and modify data once the formulas have been protected? Thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS PROTECTION IN EXCEL WORKSHEET
Jacob
Thank you so much. That is perfect. Please can I ask you one other question: I have the following situation: E5 has todays date F5 = E5+10 When I enter E6 as say tomoroow's date, F6 does not automatically update not until 4 rows have been entered. I hope this makes sense. How can I get F6 to automatically update? Many thanks once again. "Jacob Skaria" wrote: Oops..The below is a wrong post.. To your question.......try the below.. Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Tools Options Spelling AutoCorrect Autocorrect and remove the correction If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Please can you let me know if I can protect and hide several formulas in a worksheet, yet allow the user to still input data and modify data once the formulas have been protected? Thank you |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS PROTECTION IN EXCEL WORKSHEET
It should work. Check whether Tools|Calculation is set to Automatic....
If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Jacob Thank you so much. That is perfect. Please can I ask you one other question: I have the following situation: E5 has todays date F5 = E5+10 When I enter E6 as say tomoroow's date, F6 does not automatically update not until 4 rows have been entered. I hope this makes sense. How can I get F6 to automatically update? Many thanks once again. "Jacob Skaria" wrote: Oops..The below is a wrong post.. To your question.......try the below.. Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Tools Options Spelling AutoCorrect Autocorrect and remove the correction If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Please can you let me know if I can protect and hide several formulas in a worksheet, yet allow the user to still input data and modify data once the formulas have been protected? Thank you |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS PROTECTION IN EXCEL WORKSHEET
Jacob
It is set to automatic, however, it does not update automatically. Any ideas? "Jacob Skaria" wrote: It should work. Check whether Tools|Calculation is set to Automatic.... If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Jacob Thank you so much. That is perfect. Please can I ask you one other question: I have the following situation: E5 has todays date F5 = E5+10 When I enter E6 as say tomoroow's date, F6 does not automatically update not until 4 rows have been entered. I hope this makes sense. How can I get F6 to automatically update? Many thanks once again. "Jacob Skaria" wrote: Oops..The below is a wrong post.. To your question.......try the below.. Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Tools Options Spelling AutoCorrect Autocorrect and remove the correction If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Please can you let me know if I can protect and hide several formulas in a worksheet, yet allow the user to still input data and modify data once the formulas have been protected? Thank you |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS PROTECTION IN EXCEL WORKSHEET
Check for the cell formats....OR..Try this in a fresh sheet...
-- If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Jacob It is set to automatic, however, it does not update automatically. Any ideas? "Jacob Skaria" wrote: It should work. Check whether Tools|Calculation is set to Automatic.... If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Jacob Thank you so much. That is perfect. Please can I ask you one other question: I have the following situation: E5 has todays date F5 = E5+10 When I enter E6 as say tomoroow's date, F6 does not automatically update not until 4 rows have been entered. I hope this makes sense. How can I get F6 to automatically update? Many thanks once again. "Jacob Skaria" wrote: Oops..The below is a wrong post.. To your question.......try the below.. Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Tools Options Spelling AutoCorrect Autocorrect and remove the correction If this post helps click Yes --------------- Jacob Skaria "Ra" wrote: Please can you let me know if I can protect and hide several formulas in a worksheet, yet allow the user to still input data and modify data once the formulas have been protected? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Worksheet Password Protection | Excel Worksheet Functions | |||
EXCEl worksheet protection | Excel Discussion (Misc queries) | |||
Excel Worksheet protection | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) |