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 is a solution which can do that!
2. This solution Mauro Cardarelli : Aggregating Data From Different SharePoint List Types 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

Quote:

---

Originally Posted by SharePoint

There are two ways come to my mind!
1. SharePoint List Collection is a solution which can do that!
2. This solution Mauro Cardarelli : Aggregating Data From Different SharePoint List Types looks little bit hard, but it may shed you light!
Hope this helps!

---