paste special does it bloat a file?

[MJ]

Hello

When doing a paste special from Excel into Power Point does that bloat the
file? We need to have our PPT files clean so that they can be compressed down
for emailing purposes.

I understand that all pictures should be inserted properly and Excel pages
should be brought in a certain way also.

I have stated that we should NOT be using the paste special option from
Excel. Some of the spread sheets we take information we need only a portion
of that sheet. I have suggested that we just make a new table and input the
data by doing it this way there is a better chance of keeping the file clean
and compression will be easier. (but hey what do I know, so I come to you and
ask the experts)

File size is critical to us we need a print file and a small one for
emailing. We do use the Optimizer program. Sometimes no matter how we have
tried to compress the file it won't go down in size.

Here is the basic question is using the paste special option going to make
it harder to compress the file down in the end?

I appreciate your time and am desperately in need an answer.

Thank you
MJ

 

[Brian Reilly, MVP]

MJ,
In PPT 2003, copying a range from Excel and pasting it into PPT
(regular paste, not paste special) will convert the object to a PPT
table object and no longer an Excel object. The good news is that
object will be smaller in size than if pasted as an Excel OLE object.
The bad news is it is only editable in PPT as individual cells and
formulas are converted to the actual value. So if you need the ability
to update the object in Excel then you are out of luck.

You can also look back a few messages to a thread called Macros in
PowerPoint for a detailed answer on the best way to copy and paste XL
objects into PPT to minimize file size.

Brian Reilly, MVP