Formatted Excel Range Cuts off when copied to PPT & Word

[Floyd]

Hi...

I have been trying to copy an Excel Spreadsheet into PPT, but have had
problems. In order to solve it, I created new .xls and .ppt files to
create a test, but got the same problems...

The following steps recreate the problem:

1) In a blank spreadsheet, I placed a single number in each cell,
starting at A1 and going across to AS, until there are 1 through 45
across. Format them in some way... say Red text with an underline.

2) Set the width of all the columns to 2.00 (0.11 inches).

3) Select A1:AS

4) Copy (or Add to Scrapbook) -- The result is the same with both.

5) From Scrapbook, Paste as Picture, right there in Excel, or in PPT or
in Word

---- You will see that everything is fine. It pasted it just as is
should, with a picture of the formated row, numbers 1 through 45

---- Now, go back and change the width of cells A1:AS to 4.29 (.17
inches), and repeat steps 3, 4 & 5.

This time, the numbers are cut off... The pasted area is the correct
width, but only up to 27 is visible, with the rest just blank.

If you click Paste in scrapbook, it pastes all the data, but it is
unformatted. But Paste as Picture cuts it off.

From the Edit/Paste Special menu, the results are the same. -- And if

you widen the columns further, even fewer numbers are visible.

I am running a PB G4, 17" with 1GB RAM, latest OS, Updated Office 2004.

It makes no sense that the Metafile would be so small. Needless to say,
this is very annoying... Any help figuring this out would be greatly
appreciated.

Rgds,
Floyd

 

[CyberTaz]

Hi Floyd-

I can't honestly address the problem, but there is another approach
which may help avoid it altogether.

In your Ppt file use the Insert>Object command to insert a copy of the
spreadsheet or a link to it instead of the copy & paste.
Hope this helps|:>)

 

[Floyd]

Thanks...

Unfortunately, I get the same results... This one stumps me so far...
Rgds,
Floyd

 

[Daiya Mitchell]

I just skimmed your original problem, but I do know that Word will not
accept any object or picture greater than 1 page in Word. I think it sounds
like that is what is happening--widening the columns makes the picture
bigger.

 

[paolo]

hi Floyd,

I have found the same problem also using italian version: when I copy
in excel and past in power point as a picture, only few colums are
copied correctly on the left side of the picture. On the right side
only white.. The same thing happen if you try to copy a lot of rows:
the first are copied, but the other only white.
I have reinstalled office with no success. Then I have installed
Office X and everithing has gone well. Probably is a Office 2004 bug.

The only thing I can say is that I find a solution I will send you. I
hope you will do the same.

Ok,

Ciao

paolo

 

[paolo]

hi Floyd,

I have found the same problem also using italian version: when I copy
in excel and past in power point as a picture, only few colums are
copied correctly on the left side of the picture. On the right side
only white.. The same thing happen if you try to copy a lot of rows:
the first are copied, but the other only white.
I have reinstalled office with no success. Then I have installed
Office X and everithing has gone well. Probably is a Office 2004 bug.

The only thing I can say is that I find a solution I will send you. I
hope you will do the same.

Ok,

Ciao

paolo