Pasting Excel XP data into PPT XP, editing data

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have the following problem with Microsoft Powerpoint XP:
A user creates a simple Excel spreadsheet
(Apples/oranges/bananas, single digit monthly sales, sum
at bottom)
They select the Excel info and paste it into Powerpoint.
They need to edit the data pasted in the Presentation.
When they click to select a cell to change (while in PPT)
a mini version of Excel is started within PPT and the
Excel toolbars showup. All of the information that is
pasted is selected. When they click on one of the cells to
edit, Excel opens.

The problem is they do NOT want excel to open, they just
want to edit the information directly in PPT.

The information is not being pasted as a link, the problem
happens if I Paste-Special Paste+Microsoft Excel Workbook
Object.

Any help would be appreciated.

Thank You!

David
 
When you paste special as a workbook object from Excel into PPT, what you
see is how it's designed to work. Pasting an Excel chart into PPT creates an
OLE instance of the Excel workbook, which is why the mini Excel opens when
the user opens the chart. (And yes, the same behavior occurs if you just
paste into PPT as well.)

I think what your users are really looking for is a way to import data from
Excel into PPT's MS Graph datasheet.

Save your Excel workbook.
Open PPT.
Use a graph slide layout or insert graph placeholder in your usual manner.
Double-click to activate MS Graph in PPT.
Go to Edit/Import File.
Select the appropriate Excel workbook and click Open.
Type in the appropriate range of data (e.g., A1:D4) or select the entire
sheet.
Click OK.
 
Well, that helps but it is not the solution I am looking
for.
The users are not wanting to create a chart, they are
simply
wanting to paste a table into the slide.
This has worked before, in Office 97. But the upgrade works
on some computers but not all.
It seems like there is a configuration somewhere that is
not set, but I have been unsuccessful in finding it.

Thank you for your help!
-----Original Message-----
When you paste special as a workbook object from Excel into PPT, what you
see is how it's designed to work. Pasting an Excel chart into PPT creates an
OLE instance of the Excel workbook, which is why the mini Excel opens when
the user opens the chart. (And yes, the same behavior occurs if you just
paste into PPT as well.)

I think what your users are really looking for is a way to import data from
Excel into PPT's MS Graph datasheet.

Save your Excel workbook.
Open PPT.
Use a graph slide layout or insert graph placeholder in your usual manner.
Double-click to activate MS Graph in PPT.
Go to Edit/Import File.
Select the appropriate Excel workbook and click Open.
Type in the appropriate range of data (e.g., A1:D4) or select the entire
sheet.
Click OK.

--
Echo [MS PPT MVP]

I have the following problem with Microsoft Powerpoint XP:
A user creates a simple Excel spreadsheet
(Apples/oranges/bananas, single digit monthly sales, sum
at bottom)
They select the Excel info and paste it into Powerpoint.
They need to edit the data pasted in the Presentation.
When they click to select a cell to change (while in PPT)
a mini version of Excel is started within PPT and the
Excel toolbars showup. All of the information that is
pasted is selected. When they click on one of the cells to
edit, Excel opens.

The problem is they do NOT want excel to open, they just
want to edit the information directly in PPT.

The information is not being pasted as a link, the problem
happens if I Paste-Special Paste+Microsoft Excel Workbook
Object.

Any help would be appreciated.

Thank You!

David
Click to expand...

.
Click to expand...
 
Ah, sorry, I see the word Excel, and I automatically think of charts.

At any rate, the paste works the same, whether it's cells or actual
charts -- when you paste (or paste special workbook object), you get an OLE
instance of the Excel workbook. PPT's not designed to paste the Excel info
in as a PPT table.

You can ungroup the pasted Excel object, which will enable your users to
edit individual textboxes. Not sure that's going to do what you're really
wanting here, either.

Now, when you say "the upgrade," though...well, now that you've prompted me
to think more about the version, ISTR that the default paste for Office XP's
Excel worksheets pasted into PPT is actually a PPT table-type thing as
opposed to an OLE object. (I distinctly remember that the default paste
behavior changed, but I can't remember whether it was in XP or 2003.)

See if just pasting the range of cells as opposed to using the Paste Special
works. You might also want to turn on your smart tags (I think that's under
Tools/Options -- look for smart paste settings), as that may give your users
more to work with to get the results they're after.

Echo

David said:
Well, that helps but it is not the solution I am looking
for.
The users are not wanting to create a chart, they are
simply
wanting to paste a table into the slide.
This has worked before, in Office 97. But the upgrade works
on some computers but not all.
It seems like there is a configuration somewhere that is
not set, but I have been unsuccessful in finding it.

Thank you for your help!
-----Original Message-----
When you paste special as a workbook object from Excel into PPT, what you
see is how it's designed to work. Pasting an Excel chart into PPT creates an
OLE instance of the Excel workbook, which is why the mini Excel opens when
the user opens the chart. (And yes, the same behavior occurs if you just
paste into PPT as well.)

I think what your users are really looking for is a way to import data from
Excel into PPT's MS Graph datasheet.

Save your Excel workbook.
Open PPT.
Use a graph slide layout or insert graph placeholder in your usual manner.
Double-click to activate MS Graph in PPT.
Go to Edit/Import File.
Select the appropriate Excel workbook and click Open.
Type in the appropriate range of data (e.g., A1:D4) or select the entire
sheet.
Click OK.

--
Echo [MS PPT MVP]

I have the following problem with Microsoft Powerpoint XP:
A user creates a simple Excel spreadsheet
(Apples/oranges/bananas, single digit monthly sales, sum
at bottom)
They select the Excel info and paste it into Powerpoint.
They need to edit the data pasted in the Presentation.
When they click to select a cell to change (while in PPT)
a mini version of Excel is started within PPT and the
Excel toolbars showup. All of the information that is
pasted is selected. When they click on one of the cells to
edit, Excel opens.

The problem is they do NOT want excel to open, they just
want to edit the information directly in PPT.

The information is not being pasted as a link, the problem
happens if I Paste-Special Paste+Microsoft Excel Workbook
Object.

Any help would be appreciated.

Thank You!

David
Click to expand...

.
Click to expand...
Click to expand...
 
PPT XP makes a table just doing a simple copy/cut and paste
with an Excel selection.........TD
 
Thanks, Todd. That's what I was (kinda sorta) remembering.
Echo

Todd Dunn said:
PPT XP makes a table just doing a simple copy/cut and paste
with an Excel selection.........TD

-----Original Message-----
Ah, sorry, I see the word Excel, and I automatically think of charts.

At any rate, the paste works the same, whether it's cells or actual
charts -- when you paste (or paste special workbook object), you get an OLE
instance of the Excel workbook. PPT's not designed to paste the Excel info
in as a PPT table.

You can ungroup the pasted Excel object, which will enable your users to
edit individual textboxes. Not sure that's going to do what you're really
wanting here, either.

Now, when you say "the upgrade," though...well, now that you've prompted me
to think more about the version, ISTR that the default paste for Office XP's
Excel worksheets pasted into PPT is actually a PPT table- type thing as
opposed to an OLE object. (I distinctly remember that the default paste
behavior changed, but I can't remember whether it was in XP or 2003.)

See if just pasting the range of cells as opposed to using the Paste Special
works. You might also want to turn on your smart tags (I think that's under
Tools/Options -- look for smart paste settings), as that may give your users
more to work with to get the results they're after.

Echo

Well, that helps but it is not the solution I am looking
for.
The users are not wanting to create a chart, they are
simply
wanting to paste a table into the slide.
This has worked before, in Office 97. But the upgrade works
on some computers but not all.
It seems like there is a configuration somewhere that is
not set, but I have been unsuccessful in finding it.

Thank you for your help!

-----Original Message-----
When you paste special as a workbook object from Excel
into PPT, what you
see is how it's designed to work. Pasting an Excel chart
into PPT creates an
OLE instance of the Excel workbook, which is why the mini
Excel opens when
the user opens the chart. (And yes, the same behavior
occurs if you just
paste into PPT as well.)

I think what your users are really looking for is a way
to import data from
Excel into PPT's MS Graph datasheet.

Save your Excel workbook.
Open PPT.
Use a graph slide layout or insert graph placeholder in
your usual manner.
Double-click to activate MS Graph in PPT.
Go to Edit/Import File.
Select the appropriate Excel workbook and click Open.
Type in the appropriate range of data (e.g., A1:D4) or
select the entire
sheet.
Click OK.

--
Echo [MS PPT MVP]

message
I have the following problem with Microsoft Powerpoint
XP:
A user creates a simple Excel spreadsheet
(Apples/oranges/bananas, single digit monthly sales, sum
at bottom)
They select the Excel info and paste it into Powerpoint.
They need to edit the data pasted in the Presentation.
When they click to select a cell to change (while in
PPT)
a mini version of Excel is started within PPT and the
Excel toolbars showup. All of the information that is
pasted is selected. When they click on one of the cells
to
edit, Excel opens.

The problem is they do NOT want excel to open, they just
want to edit the information directly in PPT.

The information is not being pasted as a link, the
problem
happens if I Paste-Special Paste+Microsoft Excel
Workbook
Object.

Any help would be appreciated.

Thank You!

David


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top