linking the pagepreview of an excel file in word.

[duck]

I would like it that i can paste some sort of image in word. The image must
be the same as the page preview of the excel file. At the same time I need
the image to be linked at the excel file. So when I change anything in the
excel file, it changes to in the image in the word file. I already tried with
insert object and paste special but i dont really get the result i want.

I hope my question is clear and I hope to have an answer soon

 

[Graham Mayor]

Turn off the gridline display in Excel
Copy the range to the clipboard
Edit Paste Special as Picture with the link option checked.

 

[duck]

I tried it but the result wasn't like i want it. The range I am copying from
excel to word is exactly 1 page or a little less. When I do it your way, not
the whole range is displayed on 1 page. The bottom part is missing

 

[Beth Melton]

What result do you want? Are you saying you don't want to see the gridlines?
If that's the case you need to turn them off in Excel. The "View Gridlines"
option can be found in Excel options. (Office button/Excel Options for Excel
2007 and Tools/Options for previous versions.) If this isn't what you are
looking for then can you provide us with some additonal details?

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx

 

[duck]

I solved the problem doing what Graham said and changing some other values.