G
Guest
Been asked by a user who is looking to create a table in Word to find a way
to get some of the cells to become (like Excel) calculatable (if there is
such a word).
I first thought that copying the cells from a worksheet (with formulae in)
and do a Edit > Paste Special > MS Excel worksheet object...
It looked like it worked ok, but that was not what the user wanted since
they only wanted one cell to input a figure in, another one to input a
percentage and a third (all in seperate cells in the Word table) which would
display the outcome of the formula (=A1*A2%)...
Also tried a Nested Table, but that is just a copy and paste of the single
cell with no formula or border and so doesn't change when the other cells are
altered.
Are there any other methods? Or am I asking the impossible?
to get some of the cells to become (like Excel) calculatable (if there is
such a word).
I first thought that copying the cells from a worksheet (with formulae in)
and do a Edit > Paste Special > MS Excel worksheet object...
It looked like it worked ok, but that was not what the user wanted since
they only wanted one cell to input a figure in, another one to input a
percentage and a third (all in seperate cells in the Word table) which would
display the outcome of the formula (=A1*A2%)...
Also tried a Nested Table, but that is just a copy and paste of the single
cell with no formula or border and so doesn't change when the other cells are
altered.
Are there any other methods? Or am I asking the impossible?