Calculations in Word table

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Stampie said:
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).

You'd be better off in a WORD group - this is for Windows XP. (NB - Word
is NOT part of Windows XP....)
 
Stampie said:
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?

I don't think it's impossible but you are far more likely to get
a reply if you ask the experts in a Word newsgroup instead
of posting your question in a Windows newsgroup.
 
:

I don't think it's impossible but you are far more likely to get
a reply if you ask the experts in a Word newsgroup instead
of posting your question in a Windows newsgroup.

Thanks. Posted here since I couldn't find the Word specific group... I'm a
bit new to this...

Can you send me the link to it please?

Thanks
 
Stampie said:
:

I don't think it's impossible but you are far more likely to get
a reply if you ask the experts in a Word newsgroup instead
of posting your question in a Windows newsgroup.

Thanks. Posted here since I couldn't find the Word specific group... I'm a
bit new to this...

Can you send me the link to it please?

Thanks

I typed the keywords microsoft windows newsgroup into a Google
search and got some 74,000 hits. Some of them point straight at the
Windows newsgroup.
 
http://www.microsoft.com/office/com...b1e9&catlist=&dglist=&ptlist=&exp=&sloc=en-us
--
Ronald Sommer

:
:
: "Pegasus (MVP)" wrote:
:
: I don't think it's impossible but you are far more likely to get
: a reply if you ask the experts in a Word newsgroup instead
: of posting your question in a Windows newsgroup.
:
: Thanks. Posted here since I couldn't find the Word specific group... I'm
a
: bit new to this...
:
: Can you send me the link to it please?
:
: Thanks
 
Stampie said:
Are there any other methods? Or am I asking the impossible?

Micros~1 is often criticized for simply stealing or marketing things
invented by others. The thing MS DID popularize is integration of disparate
bits into a coherent whole.

In your case, Word can actively link to an Excel spreadsheet and interact
with it. Likewise, a Word document can be sucked up into FrontPage or
Publisher or spilled out to Access.
 
Back
Top