Problems copying and pasting from Excel into Powerpoint

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

pileyrei

Thread Starter
Joined
Sep 16, 2003
Messages
594
Hello

I'm hoping there is a saviour out there for me.
I'd be grateful for any suggestion or advice.

I have two identical laptops (IBM Thinkpad T22). They are identical in build. They both have Windows 2000 and Office 2000 installed on them.

I have an Excel spreadsheet and Powerpoint presentation.

I highlight data from cells A1 to H15 in excel and click edit>copy.
On a new slide in Powerpoint I click edit>paste special>microsoft excel worksheet object.

On the one laptop it pastes all the data in perfectly. On the other laptop only cells A1 to C15 are pasted in.

I have attached a screen dump from both pc's so you can better understand what I mean.

The only thing I have a hunch on is the settings. On both pc's, on the pasted data, I right click and select "format object". On the size tab I noticed that on the "good pc" the units are in cm but on the "bad pc" its on Inches ("). I changed the regional settings on the "bad pc" to English UK (Im in the UK!) and this changed the settings to cm's. I tried changing the size of the object on the "bad pc" to the same size of the object on the "good pc" but it didnt work. The settings dont hold. I change them but when I go back in they are back to where they were before.

Can anyone help me?
I am baffled how two identical pc's have this difference.
I have compared all settings (Tools>options etc) and they are all the same.


Anyone? :confused:

Many thanks

Pileyrei:confused:
 

Attachments

Joined
Feb 14, 1999
Messages
11,746
First Name
Anne
Well, you won't believe it, no one does.
Print settings have TONS to do with it.
Make sure the same printer and driver are selected as the default on both PCs...

Better yet, don't use the method you're using.
Select the cells in Excel.
Hit the View % dropdown and choose Selected area.
Save the file.
Now, go to PPT.
Insert-Object from file. Choose the Excel file.
I HOPE you'll get better results, but I don't swear to nuthin when it comes to copying/pasteing from excel
Also, pasting special as a picture often brings more desirable results, but won't be updateable.
 

pileyrei

Thread Starter
Joined
Sep 16, 2003
Messages
594
Originally posted by Dreamboat:
Well, you won't believe it, no one does.
Print settings have TONS to do with it.
Make sure the same printer and driver are selected as the default on both PCs...

Better yet, don't use the method you're using.
Select the cells in Excel.
Hit the View % dropdown and choose Selected area.
Save the file.
Now, go to PPT.
Insert-Object from file. Choose the Excel file.
I HOPE you'll get better results, but I don't swear to nuthin when it comes to copying/pasteing from excel
Also, pasting special as a picture often brings more desirable results, but won't be updateable.
Hi Dreamboat

Thanks very much for your help and suggestions. I've had issues in the past where printers drivers were to blame. Good suggestion, I missed that! Didn't work though. Ah well, always worth a try.

It's really strange, two identical pc's with identicals builds. Yet, copying and pasting produces different results.

I'm going to carry on as best as I can. Interestingly if I paste the excel data as a picture it works fine on both! The data needs to be editable so this option is not desirable. Maybe its something to do with the clipboard? Maybe not if it pastes fine as a picture.

So why does it not paste editable data properly??


Anyway, thanks for your help and ideas.


Pileyrei:confused:
 
Joined
Feb 14, 1999
Messages
11,746
First Name
Anne
>>So why does it not paste editable data properly??

Why? I have no idea.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top