Mac OSX Exporting Excel Sheets to PowerPoint

[Jim]

I am using the latest version of Mac OSX and Microsoft Office X.

I need to import a multi page spread sheet with headers into a
PowerPoint presentations.

Currently I have to eliminate the header and creat a seperate page
(with header) for each PowerPoint page.

Is there a way to import the selected print area of the total
spredsheet and have PowerPoint recognize the headers and page breaks?

 

[Jim Gordon]

Hi

I'm not quite sure I understand what you want to do, but what they heck,
I'll give this a shot anyway.

In Excel I am guessing you have used Page Setup to create header and/or
footer. Then you select a range of cells. With the range selected you use
File Print (or Apple+P). In the printer's dialog box you choose to "Print
Selection" and then instead of printing you click Save As PDF, which creates
a PDF file.

Switch to PowerPoint and use Insert > Picture > From File. The result should
be what you asked about.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Jim]

Jim,

Thank you for your response. It works with the PDF page like you said
but it only imports the first page of my spread sheet. When I save to
PDF I have multi pages. Do I have to save each page as a seperate PDF
file or is there a way to import all of the pages at one time from a
multi page PDF file.

Thank you again,

Jim

 

[Jim Gordon]

Hi again,

If you want to display pictures of your pages including headers and footers
you will need to create an individual PDF file for each sheet in the
workbook using Print's Save As PDF.

If you want people to be able to actually use the workbook you can embed the
entire workbook into a single slide. From PowerPoint's menu choose Insert >
Object. Click the box "from file" then navigate to the Excel workbook and
select it. Wait a few moments for Excel to rev up. The Excel workbook will
open. From Excel's File menu choose to close and return to PowerPoint. Now a
copy of your workbook is embedded in your presentation. Now anyone can
double-click the placeholder, which will open the workbook in Excel (this
only works if they have Excel) and while in Excel they work within the
workbook and can print it from within Excel. Excel will then print the
workbook with your headers and footers independently of the presentation.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------