I’m currently using SharePoint 2007 with Excel 2010.
I have many excel files on my SP 2007 server and I can click on them and open them with Excel 2010 and click the edit button in excel to be able to edit the excel file and save the changes back to SharePoint.
My question regarding SharePoint 2010 with Excel 2010 is does SharePoint 2010 allow you to do this? In other words, does SharePoint 2010 (enterprise version) allow you to open excel file in Excel 2010 (not just in read only mode) and be able to edit the file in Excel 2010 and save it right back to SharePoint 2010?
Or do I need office web apps installed on SharePoint 2010 to accomplish this task?