PowerPoint to Excel link issues

[DrLostinExcel]

PowerPoint 2003 11.6361.6360 SP1
Excel 2003 11.6361.6360 SP1
Windows 2000 Pro

My company generates reports in PDF from MS-SQL Server. One of our clients
wanted the data put into a Powerpoint presentation. This consisted of 45
charts (80-120 slides). I spent weeks trying to get the data into Powerpoint
and the only thing that has come close is to import the data into an Excel
spreadsheet and then do links into Powerpoint. There are quite a few problems
that I have run into. Here are a few:

Instead of being able to take the data from Excel into a PP chart I need to
make a link to an Excel object which creates a PICTURE. Why can't I just send
the data over instead of having a picture of the cells? Since I don't want
boxes around text items I have to turn off the gridlines in Excel or they go
into PowerPoint along with the data.

I need a chart in excel for each graph in Powerpoint. When I try to put 2
linked charts on a Powerpoint slide and resize them, as soon as I add
another linked object all of the linked objects revert back to their original
size.

The above often happens when you update links.

Charts will often lose part of their content as if they have been visually
cropped.
The only way to fix them is to do an update link which will sometimes cause
all of the objects to revert back to their original size.

The only way around the resizing issue that I've found is to make the charts
a size which doesn't need to be resized in Powerpoint. Of course then if you
use a different size monitor, which is smaller than the size the Powerpoint
monitor was when the show was developed, the charts resize again.

With all of the above issues I can't help but feel that I'm missing
something but I can't fathom what. Any help would be greatly appreciated.

Thanks

DLIE

 

[Kurt]

Hi
Maybe www.take-off.as/datapoint could solve this problem.
Kurt.

 

[DrLostinExcel]

Thanks Steve,

Since I work at home as much as possible to avoid annoying officemates I've
taken the precaution of a padded bandana.

No, I don't want pictures. I wish I could set up the charts totally in
PowerPoint and just import the data directly into the datasheets from Excel.
Since you seem to know what I need to know I have a couple of more questions.

When I try to work on charts in PP if I double click on a chart I get a pair
of dialogs asking for the office 2000 CD. I can continue to work by canceling
both of them but I'd really like to give PP whatever it's looking for so I
don't have to do the double cancel. We got a full update for Office to 2003
and I've tried to use those disks but it still wants the old 2000 CD. If I
try those it tells me that they're not the correct version. Any ideas here?

As far as the pasting of data using copy in XL, Paste, Special, Link that
appears to copy a picture. Still not clear on how to do just data.

Once again
THANKS!!!!

DLIE

 

[DrLostinExcel]

I only use the padded banana when my wife decides to make bread...

I must say this has been one of the most enlightening and enjoyable
repartees I've had in a while with Microsoft. IMNSHO I hope they pay you
enough because you do deserve it.

Armed with my shiny new implements of destruction it's back into the fray
for me.

Thanks again!!!!!!