How to get the right few with a big excel spreadsheet in PowerPoint

[wiesbaden]

I have an excel spreadsheet that creates a workflow chart with defined formats. The spreadsheet has many small columns. If I copy that spreadsheet into a PowerPoint presentation it works generally fine but the clip I want to show will be changed by PowerPoint automatically. I can rearrange it with a double click but afterwards it snaps back to the old view.
Does anyone has an hind how to manage it without pasting it as a bitmap? I need to work permanently with the spreadsheet just have to show different parts.
Many thanks
Michael

 

[xlhelp]

Before copying reduce the font size, column widths, and row heights etc. This will reduce the overall size of the worksheet.

You can enlarge the size of the PowerPoint slide: Go to File,Page Setup; use the UP ARROW keys to change the width and height of the slide. At the bottom, choose which slide number to apply to and click OK.

If the above fails, then you may have to paste the range of cells in multiple sections.


HTH

Indu

 

[wiesbaden]

Thanks Indu for your fast reply. Unfortunately neither the reduction of the excel cells nor the enlargement of the PowerPoint slide helps. I tried to split the excel spreadsheet as you mentioned but it takes to much time to get the right size to make it fit together in PowerPoint. Therefore I can’t do it that way.
Do you know the reason for my problem? Can PowerPoint only handle a certain range of cells?
Is there a way to paste the spreadsheet in PowerPoint without losing the ability to change the shown cells via excel?
In desperate need
Regards Michael

 

[xlhelp]

There is definitely going to be a limitation of how much you can display on a powerpoint slide.

The are a lot of different ways that you can embed Excel. Probably the best approach is:

On a blank slide, go to Insert Object, Micrsoft Excel Worksheet and expand the worksheet object as much as you can. Follow some of the instructions in the previous post and you will see your limitations of how much info you can put in.

If you wish to send me your Spreadsheet, I can take a look at it much later tonight and sort of semi, quasi, pseudo guide you as to what might be feasible.

Please send me just the worksheet in a sparate workbook just in case it's a large workbook. ishukla@yahoo.com

Thanks.

Indu