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 wrote:
> 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" <(E-Mail Removed)> wrote in message
news:855DDA37-5D92-4A51-BA23-(E-Mail Removed)...
> 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.

"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" <(E-Mail Removed)> wrote in message
news:5B3172E9-F5F6-476B-98B5-(E-Mail Removed)...
>
>
> "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

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/comm...xp=&sloc=en-us
--
Ronald Sommer

"Stampie" <(E-Mail Removed)> wrote in message
news:5B3172E9-F5F6-476B-98B5-(E-Mail Removed)...
:
:
: "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

Link,
http://www.microsoft.com/office/comm...&lang=en&cr=US (copy and paste)

"Stampie" wrote:

> 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 wrote:
>
> 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.

Open Word, Click Help, Look up Calculations, click link.

Stampie wrote:

> 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?
>