Tag Info

Hot answers tagged

6

Microsoft say you need to give your Excel Services account access to all content databases in the SP2010 Kerberos Guide. You can do this with the following PowerShell instead of manually with SQL Management Studio: $w = Get-SPWebApplication -Identity http://portal $w.GrantAccessToProcessIdentity("vmlab\svcExcel")


5

I noticed that SharePoint Worksapce was running in the system tray which had the "Shared Documents" library synced, because of this there were some temp files out there in the following location "c:\Users\login_user_name\AppData\Local\Microsoft\Office\14.0\OfficeFileCache" after terminating the Sharepoint workspace and clearing those temp files, I was ...


4

The Excel 2010 client application does not support co-authoring workbooks in SharePoint Server 2010. However, the Excel client application does support non-real-time co-authoring workbooks stored locally or on network (UNC) paths by using the Shared Workbook feature. Co-authoring workbooks in SharePoint is supported by using the Microsoft Excel Web App, ...


4

I found the solution.. This is what I did - Navigate to Document Library -> Library Settings -> Advanced Settings -> and changed the 'Default open behavior for browser-enabled documents:' to 'Open in the client application'. and Excel sheets worked smooth :)! I tried the same issue on another server without enabling the excel services and all the other ...


4

This is normal behavior in Rich Text fields in SharePoint 2007/2010. The reason is that the Enhanced Rich Editor control in versions before 2013 did not support browsers other than IE and for that reason other browsers get downgraded to a regular text box and since the value of the field is HTML, other browsers see the HTML code rather than the editor. ...


3

Have you checked this documentation: Configure the default open behavior for browser-enabled documents (Office Web Apps) You can either disable the Excel Services Application for all site collection in the central administration (Service Applications under APplication Managemend) , or you can disable the Web Access via Feature/Powershell explained in the ...


3

We had to open a case with Microsoft about this same issue. We literally tried every solution suggested in this thread and many others (IE settings, Office Trust Center settings, removing cache directories, etc, etc). It turned out that a pre-release version of Office was installed on the affected machines. The pre-release version (found in Control Panel -> ...


3

There is the option of using datasheet view to copy-paste data, especially if need lookups to other lists or have "choices" already set up. This does require you to normalize the data in your spreadsheet. The downside is that you can't paste in data for columns that are "multi-line" type in datasheet view. Using the above two walk-throughs, you can first ...


3

You can create a new list based on an Excel document. Here are some walk-thrus: http://www.bloggix.com/archive/2010/06/15/import-and-export-data-between-excel-2010-and-sharepoint-2010/ http://sharepointbuzzer.wordpress.com/2010/10/22/import-excel-sheet-as-sharepoint-list/


3

http://wellytonian.com/2011/10/excel-workbook-cannot-be-opened-error-%e2%80%93-sharepoint-2010/ Similar issue I had a similar issue couple of hours before writing this blog post. Simple Doc Lib that wouldnt open Excel Workbook within the Browser. My Google page as usual has turned pink searching for an answer. The solution was either one of the following ...


3

You need to enable the "SharePoint Server Enterprise Site Collection features" Site Collection feature. And Office Web Apps is not Excel Services. In Office Web Apps (is OWA the correct acroynom?) you have the Excel editor/browser which is not the same as Excel Services.


3

Nothing specific to Excel web parts. There is a default maximum number of web parts per page configured in your Web.config. The setting is "WebPartLimits" if you need to modify it. For example: <WebPartLimits MaxZoneParts="50" PropertySize="1048576" /> With that said, however, if you run too many Excel web parts on a single page, it will load ...


3

You can configure the default-open behavior of browser enabled documents in the list settings. See http://technet.microsoft.com/en-us/library/ee837425(v=office.14).aspx If you don't want miss excel service feature, you might also think of providing a dedicated page where a web part displays your library and another web part (for example a content editor) ...


3

If the spreadsheet uses the "Spreadsheet and database integration" features of Excel, it will not work in IE 64bit, this is due to this module not being compatible with the 64-bit browser versions of IE. More information about Browser support and limitations for SharePoint 2010 here: http://technet.microsoft.com/en-us/library/cc263526%28v=office.14%29.aspx


3

Explanation There are multiple causes for this error message. The common factor behind all of them is that Excel Services cannot get a valid Windows user identity from a claims token in SharePoint. In the case of Excel workbooks that contain PowerPivot data, this error occurs when any of the following conditions exist: •The Claims to ...


3

I have fixed this issue in the past with a little bit of client side code - basically some javascript that will turn that HTML into a rich text editor, just like in IE. Its not that hard and only takes a few minutes to apply it to the Edit and New forms. And: you don't need to be a sys admin. As long a you can design the forms (ex: your in the Site Owners ...


3

If you use Excel Web Access Web Part to display the chart, it has an option to auto refresh at regular interval. Check out link below for config options: http://office.microsoft.com/en-us/sharepoint-server-help/excel-web-access-web-part-custom-properties-HA010377893.aspx'


2

You first have to add your site collection url to the list of trusted excel services locations. After that you should have the option to open in web in any document libraries in that site collection.


2

Importing spreadsheet is an inbuilt option in SharePoint 2010. You can follow these steps mentioned over here in this video demo -http://www.sharepoint-videos.com/sp10import-spreadsheet-to-create-a-new-list/


2

Would be nice if you could provide some log information, but double check: Excel Services is actually running on the farm. Check if you can run Get-SPExcelServiceApplication Check the Trusted File Location for Excel Services Check if your Web Application has a service connection to the Excel Services


2

At the end got it working, In order to get rid off the error we need to activate the Excel services web service application proxy in web application service connections. In case the above mentioned proxy is not available under the service connections, go ahead and create one. Need some help, its right here !!


2

I'd reckon you're better building an OLAP cube out of the raw data using SQL Server Analysis Services, then surfacing that through PerformancePoint or PowerPivot. Within the OLAP cube you could build calculated measures written in MDX to apply the algorithm you need.


2

It is the cache that is storing the previous version of the workbook in memory and therefore producing an out of date version. As you have already answered, the best way to prevent this is to reduce the cache configuration against the Excel Services application to its lowest value. This would be recommended for a development Sharepoint instance so that you ...


2

As per your requirement you should go with the Office Web Apps. I will also works fine with Sharepoint 2010 Foundation and you can also download it from volume licensing program of Microsoft. Here is an post that shows system requirements of Web Apps. http://technet.microsoft.com/en-us/library/ff431682.aspx And these are the steps to install and configure ...


2

No, there is no configuration option to make this happen. In addition, the Office Web Apps use their own master pages, so editing the master page of your SharePoint site wouldn't even give you the option to do it on the client side.


2

From what I know, if you want major AND minor versions, you will have to save ('Publish') a major version through the SharePoint UI. Excel Web App, Excel Services and even Excel itself on the user's machine will only 'save a version', without the ability to 'publish a major version'.


2

Really simple, but this should work. If you want to get user-entered parameters, do this: First make the cell you want to treat as a parameter a named cell before publishing the workbook to SharePoint. It sounds like you have already done this. Create a new web part page, add the Excel viewer web part to it, and configure it to display your workbook. ...


2

Have you considered using a standard SharePoint List with a form either in SharePoint or using InfoPath? THis allows you to lock down the list, and also allows you to set the protection on the list to only allow the users access to their own data. Once completed the data can then be exported to Excel to manage the final results. Pro Tip: Do some research ...


2

You need to make sure that you have provisioned the Claims to Windows Token Service (C2WTS) using its own domain account. Then create a fake SPN for that account (this is only needed to get the Delegation tab to show up in the ADUC MMC): setspn SP/C2WTS domain\user Then configure constrained delegation for that service account to the SSAS service.



Only top voted, non community-wiki answers of a minimum length are eligible