Embedded Excel worksheet in PowerPoint

[Guest]

I'm working with an embedded excel worksheet in powerponit. The doc is sent
to me and if I have to edit the worksheet, I find that some cells have
missing characters once I open the worksheet to edit it. It appears that
characters beyond some length (256?) are being truncated off. How do I
resolve this so I don't have this problem again?

Thanks,
Barb Reinhardt

 

[Guest]

This kind of problem may occur if the material was inserted into the embedded
worksheet via copy/paste from an external sheet. A reliable approach is to
open the embedded sheet first, and from that sheet do:

File > Open... to open the external sheet

At this point cell-wise copy/paste should not drop characters

 

[Guest]

Thanks. It makes no sense, but it works.

This kind of problem may occur if the material was inserted into the embedded
worksheet via copy/paste from an external sheet. A reliable approach is to
open the embedded sheet first, and from that sheet do:

File > Open... to open the external sheet

At this point cell-wise copy/paste should not drop characters

 

[Guest]

I think the reason it works is that it insures that only one instance of
Excel is open. Somehow this uses a different Clipboard, which permits more
material in the copy paste