We have two spreadsheets in Sharepoint. They are maintained by two different people. We would like to incorporate the second spreadsheet as a worksheet in the first spreadsheet and link to the second spreadsheet. THe goal is to make sure that the changes in the second worksheet/spreadsheet to automatically reflected in the first. Please let me know if there is a way. Please note that I am not a experienced excel user.

Thanks,
Mallesh

There are two ways come to my mind!
1. SharePoint List Collection (http://www.sharepointboost.com/listcollection.html)is a solution which can do that!
2. This solution Mauro Cardarelli : Aggregating Data From Different SharePoint List Types (http://blogs.officezealot.com/mauro/archive/2008/05/24/21049.aspx) looks little bit hard, but it may shed you light!
Hope this helps!

Hey, SharePoint List Collection link is broken, it should be: SharePoint List Collection (http://www.boostsolutions.com/listcollection.html)


There are two ways come to my mind!
1. SharePoint List Collection (http://www.sharepointboost.com/listcollection.html)is a solution which can do that!
2. This solution Mauro Cardarelli : Aggregating Data From Different SharePoint List Types (http://blogs.officezealot.com/mauro/archive/2008/05/24/21049.aspx) looks little bit hard, but it may shed you light!
Hope this helps!