MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Worksheet in PowerPoint

Posted by Kevin on May 01, 2001 10:47 AM

I've created a worksheet with 54 columns and 67 rows. It prints on a single sheet of paper oriented to landscape. The problem is when I insert it as an object (either copy/paste or Insert/Object), PowerPoint cuts it off at column 45. I've sized and shaped the inserted worksheet over and over again to no avail - when I update and return to PowerPoint the width snaps back to column 45. On one occasion, I did get the visual object to stay at 54 columns - but when I printed, it only printed to column 45. Any suggestions? Thanks.

Posted by Kevin James on May 01, 2001 12:06 PM

Hi Kevin,

When I come across persnickety problems like this, I take a snapshot of the print-preview and then drop the picture into the presentation.

I know its probably not what you're looking for, but it is a viable solution.

Posted by Kevin on May 01, 2001 12:21 PM

Hi Kevin,

Yea - that works - but the image isn't as clear and crisp as inserting the worksheet object - but I guess it'll have to do for now. Thanks again.

Posted by Roger on May 03, 2001 7:29 AM

I've dealt with the same problem by selecting and copying my columns or charts from the Excel spreadsheet and doing a 'paste special' as a picture in Powerpoint. Again you may lose some clarity, but I have not seen a terrible degradation.