Office Web Apps - Error when editing Excel file in Browser
I have been working with the Office Web Apps and SharePoint 2010 this week. Quick FYI, I noticed that when I attempt to edit an Excel file in the browser when its document library is NOT a trusted file location I get a “Unable to process the request. Wait a few minutes and try performing this operation again” error message. So, if you have installed the Office Web Apps, started the appropriate viewing services, enabled the Office Web App feature for your site collection and still can’t edit a spreadsheet in the browser check your trusted file locations!
By the way, I have been impressed with the Office Web Apps, especially the co-authoring (also sometimes referred to as ‘simultaneous users’) functionality in Excel. It really works! There are some shortcomings that users need to be aware of (more details in a subsequent post) but, needless to say, things like (1) can’t run macros (2) no undo when making simultaneous edits and (3) 2MB size limit on Excel files are really going to force IT staff to properly set expectations with business users who may want to do real-time collaboration on big, complex spreadsheets.