Fonts in Excel Worksheet Object don't display correctly

[Guest]

Can anyone explain and offer possible solution to this problem -- after I
paste in an Excel worksheet object in PPT, the spacing of the font (I use
Arial) is off, meaning some letters look bunched together and some far apart.
Sometimes the font looks like it's been stretched even though I have not
resized the table. Also, when I come out of editing the data in the table,
the entire object displays larger than when I initially pasted iin as.

 

[Steve Rindsberg]

Can anyone explain and offer possible solution to this problem -- after I
paste in an Excel worksheet object in PPT, the spacing of the font (I use
Arial) is off, meaning some letters look bunched together and some far apart.
Sometimes the font looks like it's been stretched even though I have not
resized the table. Also, when I come out of editing the data in the table,
the entire object displays larger than when I initially pasted iin as.

Instead of copy/pasting from Excel, use Paste Special and choose Link.
See if that helps.

 

[Guest]

My client has specified they did not want it to be linked to an Excel file.
They have had problems with missing links and wanted to avoid that if
possible. I currently do paste special, paste. Is this a graphic display
problem?

 

[Echo S]

I can't remember for certain, so I'm hoping someone else will --

Isn't there something about 8pt Arial in pasted Excel workbooks?

--
Echo [MS PPT MVP]
http://www.echosvoice.com

My client has specified they did not want it to be linked to an Excel file.
They have had problems with missing links and wanted to avoid that if
possible. I currently do paste special, paste. Is this a graphic display
problem?

 

[Steve Rindsberg]

My client has specified they did not want it to be linked to an Excel file.
They have had problems with missing links and wanted to avoid that if
possible. I currently do paste special, paste. Is this a graphic display
problem?

If you were resizing the pasted Excel objects I'd say no, that it's just a side
effect of the way pasted stuff works. Or doesn't work so well in that case.

Since you specifically mentioned that no resizing is involved, we can skip that.

When you do Paste Special, Paste, what type of object is it pasting as?

 

[Guest]

Just had a thought as I was responding here. I went in to Format Object and
checked the scale on the table and it was not 100%. The tables are pasting in
at 105%h x105%w (some 104%x104%, others 106%x106%) -- seems to be completely
arbritrary. When I fixed to display at 100%, the text displays correctly. So,
new question -- how do fix it so that the tables paste in exactly at 100%
scale?

Note: The automatic latyout for inserted objects is turned off.

 

[Steve Rindsberg]

Just had a thought as I was responding here. I went in to Format Object and
checked the scale on the table and it was not 100%. The tables are pasting in
at 105%h x105%w (some 104%x104%, others 106%x106%) -- seems to be completely
arbritrary. When I fixed to display at 100%, the text displays correctly. So,
new question -- how do fix it so that the tables paste in exactly at 100%
scale?

Note: The automatic latyout for inserted objects is turned off.

Good detective work!

If I can replicate this, I'd like to look at this further but need to know what
version of PowerPoint you're using (and what service packs if any) and also what
version/SP of Windows.

Thanks

 

[Guest]

I'm running PowerPoint 2003 SP1 and Windows XP Professional SP1.
Thanks for your help.

 

[Steve Rindsberg]

Can anyone explain and offer possible solution to this problem -- after I
paste in an Excel worksheet object in PPT, the spacing of the font (I use
Arial) is off, meaning some letters look bunched together and some far apart.
Sometimes the font looks like it's been stretched even though I have not
resized the table. Also, when I come out of editing the data in the table,
the entire object displays larger than when I initially pasted iin as.

Just had a thought as I was responding here. I went in to Format Object and
checked the scale on the table and it was not 100%. The tables are pasting in
at 105%h x105%w (some 104%x104%, others 106%x106%) -- seems to be completely
arbritrary. When I fixed to display at 100%, the text displays correctly. So,
new question -- how do fix it so that the tables paste in exactly at 100%
scale?

Note: The automatic latyout for inserted objects is turned off.

I'm running PowerPoint 2003 SP1 and Windows XP Professional SP1.
Thanks for your help.

I've pasted your original question back in; let's keep it together with any
further msgs so someone coming in on the discussion doesn't have to piece it
all together.

I tried this in PPT2003/Excel2003 but under Windows XP SP2. I can't get pasted
worksheets from Excel to come in at anything but 100%. Can you see any pattern
to when it comes in at other percentages on your computer?

I've played with the zoom setting in Excel, and that seems to have no effect
(although I noticed that if the zoom's set such that it crops off much of the
selected area, Excel only puts unformatted text on the clipboard - you can't
even paste in an Excel object. That seems a bit odd. Buglike in fact.

 

[Guest]

Thanks for trying. Even though I don't know what's causing this problem for
me at least I know how to fix it. Thanks for helping.

I love these discussion boards!!! I've pick up so many tricks and tips.

 

[Steve Rindsberg]

Thanks for trying. Even though I don't know what's causing this problem for
me at least I know how to fix it. Thanks for helping.

My pleasure; I learned something new too. But if you do work out why the scale
percentage varies from one time to the next, please do post back!