Imported Excel wkshts in PwrPoint: can formulas autoupdate?

[stratocastr]

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)

 

[Brian Reilly, MS MVP]

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