I'm running Excel 2007 and have a number of different Sharepoint lists (SP 2003?) - all structured identically. The question is how to most efficiently create a refreshable excel table which contains data from all the linked sharepoint lists.
We've come up a way to do this, by essentially creating a scratch tab which cycles through each of the SP lists - and then copying into a master table. Is there a more elegant way to do this directly into a single table - to speed up the refresh.
Any input would be much appreciated.
We've come up a way to do this, by essentially creating a scratch tab which cycles through each of the SP lists - and then copying into a master table. Is there a more elegant way to do this directly into a single table - to speed up the refresh.
Any input would be much appreciated.
