Can't copy and paste from Excel to Powerpoint b/c of merged cells!

[aeroguy]

Running windows xp and office xp (also tried on NT and office 2000)

I have a group of cells that I want to copy from Excel to Powerpoint but when I try to paste I get the "Microsoft PowerPoint has encountered a problem and needs to close. We are sorry for the inconvenience" error message. I figured out that it's because of merged cells. When I unmerge all the cells it will paste.

Does anyone have any experience with this or any solutions? This is for work and the cells need to be merged the way they are. Check the link.

http://www.knology.net/~nkeunen/test.xls

Thanks,
Nick

 

[aeroguy]

Hmmm, either I stumped everyone or no one cares.

 

[TSDible]

The same thing happened to me when I tried to paste your spreadsheet directly into word.

I pasted the table into Word first, copied that and then pasted it to powerpoint. The formatting wasn't perfect, but it seemed to work. I think Word transforms it into a table that PowerPoint likes.

I hope that helps. I will see if I can find a better solution.

 

[TSDible]

Here is your solution

Insert --> Object --> Microsoft Excel Worksheet --> OK

Then paste your table into the embedded spreadsheet. Resize, click outside the area and there you go. You can make changes to it by clicking on it.

Or, you can just download the finished product
here.

Hope that helps.

 

[aeroguy]

You are awesome!

Insert Object... I never would've thought of that.

Thanks a million.

 

[TSDible]

NP, happy to help.