Having Live Updates to Excel /Visio Information

[Guest]

Hi all:

Question 1:
Sorry about being longwinded, but I have a problem with powerpoint that
others might also be having: Sometimes I create a powerpoint presentation
where I cut and paste into the powerpoint information from another program,
usually an excel spreadsheet, but sometimes also a visio diagram.

Usually I paste special as a picture because it tends to take little space,
usually formats well, and looks ok. However, sometimes when I am working with
an excel sheet with a large copy area (e.g. suppose that the font of the
sheet is large, like 24 pt. ) I have to cut and paste as a bitmap, which
looks best but takes up a lot of megs.

However, I often change the information on the excel sheet after pasting,
,and then have to remind myself to change the information on powerpoint,
which adds a potential point of failure on this whole chain. I was wondering
if there was a way of pasting the information in such a way so that if I
change a number in excel, the number wiill also be changes in powerpoint? Is
there also a way to make text in powerpoint referring to a data point in the
excel data change- i.e. if I change X from 10% to 25%, I can have a bullet
point go from "Sales will rise by 10%" to "Sales will rise by 25%"

Thanks,

Steve-o

 

[Tushar Mehta]

In PP, when you have the Edit | Paste Special... dialog box open,
select the 'Paste Link' option.

I don't know of any simple way to connect the content of PP text to a
XL worksheet cell. The closest one can get is to create a bullet:
'The change was'
and then position an XL cell image (using the Paste Link option) in the
right spot. Experiment with the formatting and you *may* get the
desired effect. If you go with this option remember to use a
'neutral' phrasing for your comment. Don't say "sales will rise" (or
drop) but rather "sales will change" That way if sales drop, your
comment won't read "Sales will rise by -4%"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Echo S]

Maybe have a look at DataPoint. http://www.presentationpoint.com/