Word - using Ecxel - how to add data from within Word

[Kaypee]

TIA

Have a document which has an excel spreadsheet as a datasource. Is it
possible to add to that datasource from within Word. While working on the
main document - or do I have to manually open the data source.


Kaypee

 

[Peter Jamieson]

On the whole, Word either opens the spreadsheet by using DDE to open Excel,
which opens the spreadsheet, in which case you should probably edit the data
directly in Excel, or by opening Excel using OLEDB, in which case the Edit
button in the Edit recipients dialog box is generally greyed out and you
can't edit directly.

Peter Jamieson

 

[Simon, HK]

How to set it to use DDE to open Excel?

On the whole, Word either opens the spreadsheet by using DDE to open Excel,
which opens the spreadsheet, in which case you should probably edit the data
directly in Excel, or by opening Excel using OLEDB, in which case the Edit
button in the Edit recipients dialog box is generally greyed out and you
can't edit directly.

Peter Jamieson

 

[Peter Jamieson]

Check Word Tools|Options|General|"Confirm conversion at open" then go
through the connection process again and select the DDE option when it is
offered.

Sorry for the late reply.

Peter Jamieson

 

[Simon, HK]

Thanks Peter, it works! ^_^

Check Word Tools|Options|General|"Confirm conversion at open" then go
through the connection process again and select the DDE option when it is
offered.

Sorry for the late reply.

Peter Jamieson