Excel/Powerpoint NIGHTMARE!!!!!!!!

[DrLostinExcel]

My company generates reports in PDF. One of our clients wanted the data put
into a Powerpoint presentation. This consisted of 45 charts. I spent weeks
trying to get the data in to 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 so many problems that I can't believe Microsoft hasn't
addressed them!!!!! 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?

I need a chart in excel for each graph in Powerpoint. OK but try to put 2
linked charts on a Powerpoint slide and resize them. As soon as you 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 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.

COME ON MICROSOFT!!!!!!!!
Put direct ODBC links into Powerpoint and eliminate this huge waste of time..

 

[Bob Buckland ?:-\)]

You may want to post this in the Powerpoint
newsgroup as well (link below) and include
the version of Powerpoint and Excel you're using.

=========
My company generates reports in PDF. One of our clients wanted the data put
into a Powerpoint presentation. This consisted of 45 charts. I spent weeks
trying to get the data in to 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 so many problems that I can't believe Microsoft hasn't
addressed them!!!!! 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?

I need a chart in excel for each graph in Powerpoint. OK but try to put 2
linked charts on a Powerpoint slide and resize them. As soon as you 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 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.

COME ON MICROSOFT!!!!!!!!
Put direct ODBC links into Powerpoint and eliminate this huge waste of time.. >>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.powerpoint
or via browser:
http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.powerpoint

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[DrLostinExcel]

I have 2 points here that I'd like to make.
A. It seems like ODBC SHOULD be an integral part of PowerPoint. Isn't
PowerPoint for presenting? And isn't corporate data something that is
presented ALL THE TIME?

B. With Office integration doesn't it seem more useful to have the actual
data passed between Office applications rather than pictures?

Courtesy is something that comes a lot easier when one doesn't have his
boss's foot up his butt because his boss can't believe that Microsoft
products can't possibly not do this.

8^\\

dlie

 

[Bob Buckland ?:-\)]

As I mentioned previously you're likely to
find more folks with expertise in Powerpoint
in the Powerpoint newsgroup

Powerpoint supports connections to other files
(Insert=>Object) or Edit=>Paste Special from Excel
but there is no Microsoft direct support to link
to PDF files. The folks in the Powerpoint group
have some pretty good tricks they use (but be sure
to talk nicely about cats over there).

========
I have 2 points here that I'd like to make.
A. It seems like ODBC SHOULD be an integral part of PowerPoint. Isn't
PowerPoint for presenting? And isn't corporate data something that is
presented ALL THE TIME?

B. With Office integration doesn't it seem more useful to have the actual
data passed between Office applications rather than pictures?

Courtesy is something that comes a lot easier when one doesn't have his
boss's foot up his butt because his boss can't believe that Microsoft
products can't possibly not do this.

8^\\

dlie >>
--
Let us know if this helped you,

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

Office 2003 Editions explained
http://www.microsoft.com/uk/office/editions.mspx

 

[DrLostinExcel]

Ahhh....
Beg to differ here.
I HAVE linked directly to PDF from inside PowerPoint but the boss wants the
charts which are already in the PDF's in PowerPoint and ayyyye, there's the
rub...

Thanks for the direction though, I'll swing by the PowerPoint board. Excuse
the frustration but I had to do 45 charts by hand in PowerPoint (82 slide
presentation) which took me 6 1/2 wee hours of the morning even though I had
the data all nicely formatted in Excel.

THX