T
Tom Nesbitt
Would anyone have direct experience with linking lots of
Excel tables into complicated Word reports - say 100
tables into a 100 page document?
I tried this years ago shortly after OLE came out, but the
document's links got confused, with Excel occasionally
getting confused about which worksheet tab and range
belonged in which Word table. This was not a case of my
error, nor of corrupted files due to crashes, but was
confirmed as a problem with Excel by a person knowledgable
of its codes and bugs back then.
Needless to say, I stopped aiming at having these live
links in my documents, and opted to do static "picture"
pastes - more work, especially at the end of a report when
one change rippled through many tables, but reliable.
AM I OUT OF DATE? DO NUMBEROUS LINKS WORK RELIABLY IN
EXCEL 2002 OR 2003. My same Microsoft friend doubts that
code has been revisited since, but a small test set of
links tseems to work. HAS ANYONE USED THIS FEATURE HEAVY
DUTY? ANY CAUTIONS THAT MAKE IT WORK, LIKE LIMITING THE
LINKS TO ONE RANGE LINKED PER WORKSHEET, ETC? Thanks!!
Excel tables into complicated Word reports - say 100
tables into a 100 page document?
I tried this years ago shortly after OLE came out, but the
document's links got confused, with Excel occasionally
getting confused about which worksheet tab and range
belonged in which Word table. This was not a case of my
error, nor of corrupted files due to crashes, but was
confirmed as a problem with Excel by a person knowledgable
of its codes and bugs back then.
Needless to say, I stopped aiming at having these live
links in my documents, and opted to do static "picture"
pastes - more work, especially at the end of a report when
one change rippled through many tables, but reliable.
AM I OUT OF DATE? DO NUMBEROUS LINKS WORK RELIABLY IN
EXCEL 2002 OR 2003. My same Microsoft friend doubts that
code has been revisited since, but a small test set of
links tseems to work. HAS ANYONE USED THIS FEATURE HEAVY
DUTY? ANY CAUTIONS THAT MAKE IT WORK, LIKE LIMITING THE
LINKS TO ONE RANGE LINKED PER WORKSHEET, ETC? Thanks!!