object inserted from Excel gives too much of the worksheet

[Marie]

Using Access 2000. I am linking part of an Excel
spreadsheet to a PowerPoint slide, but am getting two more
columns than I want. How do I tell PowerPoint/Excel how
much of the worksheet I want in the PowerPoint
presentation. I tried to use Set Print Area.

Thanks so much for your help.

Marie

 

[Bill]

IMHO, I have had problems myself getting just the information I want from
Excel (whether I use copy/paste, copy/paste special, etc.). Therefore I
have found that it is much easier to create a simple Action Button (I
normally use the "Action Button: Custom" from the Autoshapes icon) and then
set it to hyperlink to "Other file". I right-click on the button to add
text (like - "Click here to view Excel data"). This opens Excel. I can go
over whatever data I want, and when I exit Excel I am right back to my
PowerPoint slide show ready to move on.

The only trick to ensuring this link always works is to put the Excel file
in the same folder as your PowerPoint presentation before you insert the
hyperlink, that way as long if you move the two files it will always work
(like burning to a CD).

Hope this helps!

Bill Foley
www.pttinc.com