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

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

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

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

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

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

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