Excel Linked Tables and Footnotes

[Dolphin]

My document includes a table that I would like to link to Excel. However I
also need to include the footnote functionality in the table. When I use the
Link to Excel I loose the footnote functionality. I can think of some
complicated solutions but am interested in simple ones.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RG9scGhpbg==?=,

My document includes a table that I would like to link to Excel. However I
also need to include the footnote functionality in the table. When I use the
Link to Excel I loose the footnote functionality. I can think of some
complicated solutions but am interested in simple ones.

I don't think there are any simple ones... When you update a table link, any
editing you've done in the table (it's actually a LINK field) is discarded (the
result is a completely new writing, not just an update of whatever changed).

This means you'd need to use a macro, in some form or other.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail