Problems importing Excel files into Powerpoint ...

  • Thread starter Thread starter Greg_Del_Pilar
  • Start date Start date
G

Greg_Del_Pilar

Hi!

I am automatically generating nicely-formatted Excel worksheets that contain
some graphs and some tabulated data. I have also divided each workheet into
2 sections ---- the "main section" where I put all the items I want to be
able to print on a page (and I use Excel's "Set Printarea" menu to specify
which cels fall in this region), and the "calculation area" which I use as a
"scratch pad" (where I put all my calculation formulas and raw numbers used
to populate the graphs and tables shown in the main section). The main
section consists of the first 10 columns and top 60 rows, while the
calculation area extends too far to the right (sometimes up to column "DZ").

My problem is, when these worksheets are imported into Powerpoint,
everything gets imported and shown on screen, including the calc area. Thus,
powerpoint automatically reduces the size of the initial object to
accommodate the entire width of my spreadsheets. I have to manually activate
the OLE link in order to resize the object and only show the main section.
Also, when I do this, I notice that my graphs are usually "distorted" and
reduced in size (relative to the rest of main page). This presents a big
manual overhead for me which I'm trying to avoid as I want to automate the
entire process.

Has anyone ever dealt with this problem? Is there an option in Powerpoint
that I can set to make it import my Excel spreadsheets without resizing the
objects? In other words, if I designate a main section in the Excel
worksheet, can Powerpoint just show this area (and preserve its original
font size and the placement of the objects in it)?

Thanks for any help on this.

Greg
 
Greg:

Try pushing your charts and tables out from Excel instead of pulling them
into PPT. In Excel VBA, after referencing the proper PPT Object libraries
and calling forth your presentation, use something like this:

Sheet15.Range("Table4").Copy ' Table4 is a named range in Excel
Set Pasted =
PPTApp.ActivePresentation.Slides(4).Shapes.PasteSpecial(Link:=msoTrue)
With Pasted
.Width = 614.25
.Left = (792 - .Width) / 2 ' center on 8.5" x 11" slide size
.Top = 434.25
End With

Sheet17.ChartObjects("chart 4").CopyPicture ' (I get errors trying to
link a chart properly)
Set Pasted = PPTApp.ActivePresentation.Slides(9).Shapes.Paste
With Pasted
.Width = 220.5
.Height = 179.25
.Left = 109.5
.Top = 370
End With

A fast way to find out the chart number on a worksheet: click on the chart
and run this:
MsgBox "Chart " & ActiveChart.Name

Bruce Cooley
~~~~~~~~~~~~~~~~~~~

: Hi!
:
: I am automatically generating nicely-formatted Excel worksheets that
contain
: some graphs and some tabulated data. I have also divided each workheet
into
: 2 sections ---- the "main section" where I put all the items I want to be
: able to print on a page (and I use Excel's "Set Printarea" menu to specify
: which cels fall in this region), and the "calculation area" which I use as
a
: "scratch pad" (where I put all my calculation formulas and raw numbers
used
: to populate the graphs and tables shown in the main section). The main
: section consists of the first 10 columns and top 60 rows, while the
: calculation area extends too far to the right (sometimes up to column
"DZ").
:
: My problem is, when these worksheets are imported into Powerpoint,
: everything gets imported and shown on screen, including the calc area.
Thus,
: powerpoint automatically reduces the size of the initial object to
: accommodate the entire width of my spreadsheets. I have to manually
activate
: the OLE link in order to resize the object and only show the main section.
: Also, when I do this, I notice that my graphs are usually "distorted" and
: reduced in size (relative to the rest of main page). This presents a big
: manual overhead for me which I'm trying to avoid as I want to automate the
: entire process.
:
: Has anyone ever dealt with this problem? Is there an option in Powerpoint
: that I can set to make it import my Excel spreadsheets without resizing
the
: objects? In other words, if I designate a main section in the Excel
: worksheet, can Powerpoint just show this area (and preserve its original
: font size and the placement of the objects in it)?
:
: Thanks for any help on this.
:
: Greg
:
:
:
 
Greg,

I think I am doing a similar thing to what you describe. I have a large
spreadsheet that creates nicely formatted tables and charts that are pasted
into a presentation as links. The data changes; the charts and tables and
presentation format stay the same.

Your approach of using PPT VBA to import the data may be more frustrating
than it is worth. I had good luck using Excel VBA to export the tables
(named ranges) into PPT using PasteSpecial as links. I could not get the
charts to paste properly as links using VBA, so I just developed another
approach to this problem, and it works beautifully. After getting one
presentation right, with all the tables and charts pasted special as links,
I put a macro in it that allows me to browse and select a different file to
link to, and then it changes and then updates all the links. No resizing
issues, font changes, or extra cells. Just the same charts and tables in
the same formats but with new data. The presentation text just needs to be
modified to match the new data.

Bruce Cooley



----- Original Message -----
From:
Newsgroups: microsoft.public.powerpoint
Sent: Monday, August 04, 2003 11:30 PM
Subject: Problems importing Excel files into Powerpoint ...


: Hi!
:
: I am automatically generating nicely-formatted Excel worksheets that
contain
: some graphs and some tabulated data. I have also divided each workheet
into
: 2 sections ---- the "main section" where I put all the items I want to be
: able to print on a page (and I use Excel's "Set Printarea" menu to specify
: which cels fall in this region), and the "calculation area" which I use as
a
: "scratch pad" (where I put all my calculation formulas and raw numbers
used
: to populate the graphs and tables shown in the main section). The main
: section consists of the first 10 columns and top 60 rows, while the
: calculation area extends too far to the right (sometimes up to column
"DZ").
:
: My problem is, when these worksheets are imported into Powerpoint,
: everything gets imported and shown on screen, including the calc area.
Thus,
: powerpoint automatically reduces the size of the initial object to
: accommodate the entire width of my spreadsheets. I have to manually
activate
: the OLE link in order to resize the object and only show the main section.
: Also, when I do this, I notice that my graphs are usually "distorted" and
: reduced in size (relative to the rest of main page). This presents a big
: manual overhead for me which I'm trying to avoid as I want to automate the
: entire process.
:
: Has anyone ever dealt with this problem? Is there an option in Powerpoint
: that I can set to make it import my Excel spreadsheets without resizing
the
: objects? In other words, if I designate a main section in the Excel
: worksheet, can Powerpoint just show this area (and preserve its original
: font size and the placement of the objects in it)?
:
: Thanks for any help on this.
:
: Greg
 
Back
Top