Embedded Excel Spreadsheet Tables

[Paul]

I am trying to embedded several pages from the same
spreadsheet into a MSWord 2000 document. However, the
document seems to want to automatically update all the
embedded tables so that they are all the same table --
which ever table I had open last.

I have locked links to prevent this, but sometimes when I
print documents it updates the table and shows the wrong
one.

How do I link to a particular sheet in a particular Excel
document and not have it swap to the most recently opened
sheet?

Thanks,
Paul

 

[Cindy M -WordMVP-]

Hi Paul,

I've heard of the problem before, but I don't know of a
tried-and-true solution. I do have a question, however:

how did you create the additional links? Did you copy/paste
what you already had and modify it? Use Insert/Object for
each one? Copy/Paste from Excel for each one?

I am trying to embedded several pages from the same
spreadsheet into a MSWord 2000 document. However, the
document seems to want to automatically update all the
embedded tables so that they are all the same table --
which ever table I had open last.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

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

 

[Paul]

Dear Cindy:

Thank you for taking a moment to reply. I used the insert
object method. To "solve" the issue I have locked the
links (under edit); but this is not a satisfactory
solution.

Paul

 

[Cindy M -WordMVP-]

Hi Paul,

I used the insert
object method. To "solve" the issue I have locked the
links (under edit); but this is not a satisfactory
solution.

Understood, and i agree. Whether I'll be able to help at all
is another question, entirely...

See if this makes any difference, at all:

1. Rename Normal.dot to NormalOLD.dot
2. Start Word
3. Open your document, and generate a blank, new document
(default, don't choose a template)
4. Copy some text from the "problem" document to the new one
(don't include any section breaks, the last paragraph mark or
any of the Excel stuff)
5. Insert a a couple of Excel sheets. Make sure that you move
the cursor to different paragraphs for each separate
insertion.

Does this stay stable? If it does, we can be fairly certain
that document corruption is causing the problem in your
document, and look for the best way to recreate it.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

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