rbates

We have a workbook that consolidates data from several employees. Is it possible, using Excel Services on SharePoint, to create a web part that will allow the employees to enter their specific data and have it be saved back to the consolidated workbook

I don¡¯t believe something like this can be done ¡°out of the box¡± and if not, what options could be used My associate called the Microsoft Tech support line and they are saying it can be done. I would think a bit more programming would be required to take the employee¡¯s data and consolidate it back to the source workbook.

Thanks




Re: SharePoint - Excel Services Consolidating data in a workbook

Shahar Prish - MSFT

As you suspect, there's quite a bit of programming that needs to go into here. It really depends on what it is you want to do. How you want the information entered etc.

One simple solution is to have the employee data entered into a database and then use Excel Services External References to read that data. You can also use a SharePoint list to store the data and then use a UDF to fetch the data into the workbook when the workbook loads.

I can think of two or three other solutions as well.It really ends up depending on what you want to do.






Re: SharePoint - Excel Services Consolidating data in a workbook

rbates

Thanks for your quick response. We don't have a database engine in our Sharepoint environment (ASP Hosted). Can we save the data (entered in a Excel Web Part ) to an .xml file and the use it as the external reference I see that updateing a SharePoint list from Excel is not the best way to do this. (Sorry, but I'm a web and database type and SharePoint is new territory.)

Thanks again.

Rob






Re: SharePoint - Excel Services Consolidating data in a workbook

Shahar Prish - MSFT

You should be able to do that (save it to a well-known XML and then use that). Of course, you will need to supply database semantics (locking, saving, caching etc etc). You can then use Excel Services to do what you want (namely, read the XML and display the data). You would have to do tha thru UDFs though (which is not always easy to do).

Edit: Correction.. UDFs are VERY easy to write, just not always easy to get them to do exactly what you want or expect.