[frustrated]

Using formula in Word is not an option cause people in a hurry forget to
update total when they have made a change. So right now using Excel tables
throughout the document where the user inputs the values and it sums for
them. However, I haven't figured out yet have to have each total
automatically update specific cell in the summary page Excel spreadsheet.
Any ideas?

[Suzanne S. Barnhill]

Fields in Word are normally updated at print time. I don't understand the
rest of your question.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Frustrated" wrote in message
...
Using formula in Word is not an option cause people in a hurry forget to
update total when they have made a change. So right now using Excel
tables
throughout the document where the user inputs the values and it sums for
them. However, I haven't figured out yet have to have each total
automatically update specific cell in the summary page Excel spreadsheet.
Any ideas?

[macropod[_2_]]

Hi Frustrated,

If I understand your problem correctly, I seems you want to link two or more embedded Excel Workbooks. To do that, basically all one
needs to do is to:
.. activate the source worksheet
.. copy the source cell
.. close the source worksheet
.. activate the target worksheet
.. use Edit|Paste Special, click on 'Link' and choose the Excel file format.
This is best done after the document has been saved with the required name and in the required folder - otherwise the link may fail.


--
Cheers
macropod
[MVP - Microsoft Word]


"Frustrated" wrote in message ...
Using formula in Word is not an option cause people in a hurry forget to
update total when they have made a change. So right now using Excel tables
throughout the document where the user inputs the values and it sums for
them. However, I haven't figured out yet have to have each total
automatically update specific cell in the summary page Excel spreadsheet.
Any ideas?