Datamapping to Excel

PPT 2003

Need some help. I'm trying to datamap to Excel. On a slide I want to
show the live contents (linked) of a single cell from an Excel file.
On the slide I will have several such objects. I tried copying a cell
and pasting as a link into the slide. It worked fine except the visual
quality was bad. Being Excel used 10pt, contents appeared too small on
the slide, and the edges of the characters were jagged in Slide Show.
I enlarged the linked object and it looked fine, but in Slide Show, it
was so jagged it was unacceptable. Is this the only way to do this?

I'm not a stranger to PPT and will even take VBA suggestions. I'm very
familiar with PPT and even used to program VBA with it, but it's been
a long long time. I've been wrapped up in Excel VBA projects for a few
years now and have forgotten a lot. Thanks.

Mel
Fri Aug 15 00:15:46 CDT 2008

I need to clarify the jagged edges appear only when the linked object
is animated. I can animate other textual objects without that
happening. Do linked objects that display text run under a different
set of rules?



On Aug 14, 11:35 pm, mel.tu...@yahoo.com wrote:
> PPT 2003
>
> Need some help. I'm trying to datamap to Excel. On a slide I want to
> show the live contents (linked) of a single cell from an Excel file.
> On the slide I will have several such objects. I tried copying a cell
> and pasting as a link into the slide. It worked fine except the visual
> quality was bad. Being Excel used 10pt, contents appeared too small on
> the slide, and the edges of the characters were jagged in Slide Show.
> I enlarged the linked object and it looked fine, but in Slide Show, it
> was so jagged it was unacceptable. Is this the only way to do this?
>
> I'm not a stranger to PPT and will even take VBA suggestions. I'm very
> familiar with PPT and even used to program VBA with it, but it's been
> a long long time. I've been wrapped up in Excel VBA projects for a few
> years now and have forgotten a lot. Thanks.

Mel
Fri Aug 15 00:29:41 CDT 2008

Nope - scratch that. NOW all linked text is appearing jagged -
animated or not - when a moment ago it was only the animated linked
text that was jagginating. Note that animated non-linked text does not
jagginate - only linked text from Excel.

I know about some history of jagged edges issues, but I've never seen
it happen on only linked text. Anyone know what's going on?


On Aug 15, 12:15 am, Mel <mel.tu...@yahoo.com> wrote:
> I need to clarify the jagged edges appear only when the linked object
> is animated. I can animate other textual objects without that
> happening. Do linked objects that display text run under a different
> set of rules?
>
> On Aug 14, 11:35 pm, mel.tu...@yahoo.com wrote:
>
> > PPT 2003
>
> > Need some help. I'm trying to datamap to Excel. On a slide I want to
> > show the live contents (linked) of a single cell from an Excel file.
> > On the slide I will have several such objects. I tried copying a cell
> > and pasting as a link into the slide. It worked fine except the visual
> > quality was bad. Being Excel used 10pt, contents appeared too small on
> > the slide, and the edges of the characters were jagged in Slide Show.
> > I enlarged the linked object and it looked fine, but in Slide Show, it
> > was so jagged it was unacceptable. Is this the only way to do this?
>
> > I'm not a stranger to PPT and will even take VBA suggestions. I'm very
> > familiar with PPT and even used to program VBA with it, but it's been
> > a long long time. I've been wrapped up in Excel VBA projects for a few
> > years now and have forgotten a lot. Thanks.

Steve
Fri Aug 15 10:03:26 CDT 2008


Try formatting the text larger in Excel, even to the point of making it FAR
larger than it needs to be, then reducing it in PPT.

If that munges your worksheet formatting, you could probably leave the original
cell alone, copy/link it to another cell on a different sheet, format that then
copy/paste/link it to PPT.

I suspect the root of the problem is that since PPT 2002, PPT has been unable
to do a decent job of converting text to bitmaps (text in exported PNG files
and the like often looks awful as well). And since it needs to make bitmaps in
order to animate text as sprites ... well, there you go.



In article <ce5bea91-3819-409f-9861-4604ccdf9f66@d45g2000hsc.googlegroups.com>,
Mel wrote:
> Nope - scratch that. NOW all linked text is appearing jagged -
> animated or not - when a moment ago it was only the animated linked
> text that was jagginating. Note that animated non-linked text does not
> jagginate - only linked text from Excel.
>
> I know about some history of jagged edges issues, but I've never seen
> it happen on only linked text. Anyone know what's going on?
>
> On Aug 15, 12:15 am, Mel <mel.tu...@yahoo.com> wrote:
> > I need to clarify the jagged edges appear only when the linked object
> > is animated. I can animate other textual objects without that
> > happening. Do linked objects that display text run under a different
> > set of rules?
> >
> > On Aug 14, 11:35 pm, mel.tu...@yahoo.com wrote:
> >
> > > PPT 2003
> >
> > > Need some help. I'm trying to datamap to Excel. On a slide I want to
> > > show the live contents (linked) of a single cell from an Excel file.
> > > On the slide I will have several such objects. I tried copying a cell
> > > and pasting as a link into the slide. It worked fine except the visual
> > > quality was bad. Being Excel used 10pt, contents appeared too small on
> > > the slide, and the edges of the characters were jagged in Slide Show.
> > > I enlarged the linked object and it looked fine, but in Slide Show, it
> > > was so jagged it was unacceptable. Is this the only way to do this?
> >
> > > I'm not a stranger to PPT and will even take VBA suggestions. I'm very
> > > familiar with PPT and even used to program VBA with it, but it's been
> > > a long long time. I've been wrapped up in Excel VBA projects for a few
> > > years now and have forgotten a lot. Thanks.
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com

Mel
Fri Aug 15 18:24:06 CDT 2008

STEVE! ... Brilliant idea, man! <big kiss headed your way>

Lemme see how that works.

Thanks
Mel

On Aug 15, 10:03 am, Steve Rindsberg <ab...@localhost.com> wrote:
...
> If that munges your worksheet formatting, you could probably leave the original
> cell alone, copy/link it to another cell on a different sheet, format that then
> copy/paste/link it to PPT.
...

Steve
Sat Aug 16 11:58:13 CDT 2008

In article <18503bee-aa3a-40e9-8ba7-c1ba1c3fb72a@m3g2000hsc.googlegroups.com>, Mel
wrote:
> STEVE! ... Brilliant idea, man! <big kiss headed your way>

HeyHey! Watch that! ;-)

>
> Lemme see how that works.
>
> Thanks
> Mel
>
> On Aug 15, 10:03 am, Steve Rindsberg <ab...@localhost.com> wrote:
> ....
> > If that munges your worksheet formatting, you could probably leave the original
> > cell alone, copy/link it to another cell on a different sheet, format that then
> > copy/paste/link it to PPT.
> ....
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com