Lars,
I *think* what is happening is that the Excel sheet is embedded in the word
doc. It acts like a picture and so when you need to format it, you have to
treat it like a picture - actually go into it. Therefore it will not respond
to page layout formatting, similar to how a picture acts. Someone else
probably actually knows what's going on, this is my best guess.
When I need to paste information from an excel file, I find the best thing
to do is create an appropriately sized table in word, then copy the
information from excel. When you go back to word, choose the rows and
columns (make sure you don't choose the whole table, JUST the cells) and
"paste cells" from excel into word. (if you right click on the table in word,
this option shoulod come up). You'll know if you've chosen the correct way
because if you select the whole table the black highlight, showing your
choice, also chooses just outside the table margin to the right. If you
choose correctly, only the cells are highlighted. If you choose incorrectly
and paste and get the wrong thing, just use the undo button.
Then I can format the table however I choose and it acts as part of word,
rather than as a picture/embedded text. If I need to recalulate, I find it
best to do this in excel, then copy and paste any changes over to word in the
same manner.
HTH
Fiona
