Hi,

Got a wee problem, hope someone can help!

Please see the attached word file.

I've created a table inside a word doc, which contains two formulas. Both function perfectly. If I change any of the values in the peach coloured cells, all I have to do is right click / 'update fields' on both grey coloured cells containing the formulas, and it will update the values accordingly.

However, I want users to input their own values into the peach coloured cells without having to right click / 'update fields'. Is there any way the formulas in the grey cells can automatically update after user input? I also want to lock/protect the grey cells so users cannot edit the formulas.

Using excel sadly isn't an option.

any help would be much appreciated.



Thanks..

Attached Files

Customer types.docx (13.9 KB, 10 views)