Importing a large excel table a line at a time.

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

I have several large tables in Excel with conditionally formatted
coloured cells. Is there a way to import them into Powerpoint so that
the rows are revealed sequentially down to form the entire table in an
active slide. There are 50 to 100 rows and 50 columns so importing
them manually is at best tedious, and the size of the slide would be
boggling if I understand what has to come with each row.

An alternative might be to import the whole table into powerpoint and
reveal/unhide the rows sequentially. I know how to do that for
revealing points in a text presentation, but not how to do it for a
table.

Could any kind soul point me in the right direction? Please?
 
I think you'd need to import the table and then ungroup it in PPT.
Regroup the individual lines and animate those.

Oh, or maybe you could animate a series of background-colored boxes to
cover/reveal the areas as needed. Depending on which version of PPT,
that may very well be easier.
 
[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

Excel does not provide that level of integration with PowerPoint (so
PowerPoint does not know how to parse an Excel table into individual
objects which can be animated). To get that kind of integration you would
have do lots of manual work, write your own solution (e.g. VBA) or find
some 3rd party solution already developed.

If you (or anyone else reading this message) thinks that is important for
PowerPoint to provide better (or any) support for support for consuming,
viewing and/or interacting with data and documents from other Office
applications (without having to resort to VBA or add-ins), don't forget to
send your feedback (in YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
Back
Top