Imported Excel wkshts in PwrPoint: can formulas autoupdate?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need Excel worksheets--with formulas--imported into Powerpoint to
automatically update without me having to manually double clicking on the
object. (The imported worksheet will then update.) I need it to update 100%
on its own. For example: "It's been xx days since..." (xx = the function that
needs to update itself without user input). It autoupdates in Excel fine just
not in Powerpoint. Powerpoint seems to treat it like a graphic until the user
double clicks the object, temporarily bringing up the worksheet with all its
features.
Here's the formula I'm working with:

A
Date
6/8/2007
6/20/2007
Formula Description
=A3-A2 Days between the two dates (12)
=NETWORKDAYS(A2,A3) Weekdays between the two dates (9)
 
This use to work back in Office 97 but you will now need to resort to
a little VBA to update the data if you are going to want this to be a
real time update during a slide show.

Brian Reilly, MVP
 
Is it possible to see the solution to this issue?



Brian Reilly said:
This use to work back in Office 97 but you will now need to resort to
a little VBA to update the data if you are going to want this to be a
real time update during a slide show.

Brian Reilly, MVP

On Thu, 14 Jul 2005 10:30:01 -0700, "stratocastr"
wrote:

>I need Excel worksheets--with formulas--imported into Powerpoint to
>automatically update without me having to manually double clicking on the
>object. (The imported worksheet will then update.) I need it to update 100%
>on its own. For example: "It's been xx days since..." (xx = the function that
>needs to update itself without user input). It autoupdates in Excel fine just
>not in Powerpoint. Powerpoint seems to treat it like a graphic until the user
>double clicks the object, temporarily bringing up the worksheet with all its
>features.
>Here's the formula I'm working with:
>
>A
>Date
>6/8/2007
>6/20/2007
>Formula Description
>=A3-A2 Days between the two dates (12)
>=NETWORKDAYS(A2,A3) Weekdays between the two dates (9)
Click to expand...
 
Back
Top