Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel tables in Word
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? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel tables in Word
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? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel tables in Word
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tables from Excel to Word | Tables | |||
Excel Tables in Word | Tables | |||
Excel Tables in Word | Tables | |||
controlling tables in word linked to excel tables | Tables | |||
excel tables to word | Microsoft Word Help |