This is more of an Excel question than a Powerpoint question, I think. So I give an Excel based answer, from the Excel help.
=SUM(C10:C25): current worksheet
=SUM(Year!C10:C25): other worksheet in current workbook
=SUM('C:\Reports\[Budget.xls]Year'!C10:C25): other worksheet in other workbook
But I'm afraid the changes in the one don't automatically show up in the other. You might have to use refresh (f9 or shift-f9).
Hope this helps.
Kees
Hello. I have a slide in my powerpoint presentation which has 2 independant Excel objects on the same page. Can I take a value from one object in a specific worksheet and apply that to a cell in the other object?
Something like the following:
In Object 5 Data Worksheet Cell A5 = Object 2 Data Worksheet Cell B5
so when I update Object 2 with new data, Cell A5 in object 5 updates based upon the new data in Object 2.
Thanks in Advance.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic