object inserted from Excel gives too much of the worksheet

  • Thread starter Thread starter Marie
  • Start date Start date
M

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
 
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
 
Don't use Set Print Range, Marie. Instead:

SELECT what you want in Excel, choose Edit, Copy
Switch to PPT
Choose Edit, Paste Special, put a checkmark next to LINK and click OK

You can later ungroup then regroup to break the link if you like.
 
Back
Top