Hot answers tagged

8

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 ...


7

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

Dim SharepointAddress As String Dim LocalAddress As String Dim objNet As Object Dim FS As Object ' Where you will enter Sharepoint location path SharepointAddress = "\\sharepoint path to document library" & "\" ' Where you will enter the file path, ex: Excel file LocalAddress = "your file path" Set objNet = ...


4

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) ...


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

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 ...


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. ...


4

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 -> ...


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

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 ...


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 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

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

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

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

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'


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


2

there is 3rd party tool called Muhimbi PDF Converter http://blog.muhimbi.com/2012/02/convert-infopath-to-ms-word-excel-xps.html


2

When using the PowerPivot Gallery, thumbnails only appear when the workbook uses embedded data or when an external PowerPivot workbook is used as a datasource. MSDN does not state any support for thumbnails of workbooks based on Tabular Model: http://msdn.microsoft.com/en-us/library/ee637435.aspx#prereq When using auto-refresh, you basically declare that ...


2

I was facing same issue. I just removed the Document Library URL from Trusted File locations and it worked. GoTo Excel Services > Global Settings > Trusted file locations and remove the entry of document libraray you may have added.


2

Do a repair on your office 2010 installation. EDIT More info here. You are running Excel 2010 and Visio 2013. Run the repair on 2010 should fix your Excel issue. However you did not install the bits so that you can open it in Visio 2013 - and they don't co-exist as far as I know, you have to use one or the other. Your alternative is to just download ...


2

Issue got resolved after updating the SQL 2012 Server(PowerPivot) version to SP1 and changing the account for SQL Server Analysis Services (PowerPivot) to Local System account. Also, the service account used for the Excel Services Application needs to be set as an Analysis Services administrator. MSDN reference link


2

To work around this issue, follow these steps: Open the workbook in an Excel client application. Select the data connection that is listed in the error message, and then click Properties under the Data tab. Clear the Always use connection file check box under the Definition tab. Republish the workbook to the WAC server. here is the KB for above: 2758432 ...


2

The user-defined functions in Excel Services are managed code, written with Visual Studio and compiled to a DLL. See Understanding Excel Services UDFs Excel Web Apps used to display Excel in the browser on a SharePoint site does not support VBA.


2

I fix this error with this way : I Run as administrator in IE and then I go to Central Administration And then I go to Secure Store Service , Then press New I fill Target Application ID and Display Name and Contact E-mail and select Target Application Type in Group and Target Application Page URL is none. Then press Next button and in new page ...


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.


2

The Excel Service Application has no Database itself. But in order for it to have access to the Content Database of your web application you have to execute the following powershell (for each WebApp where you want to allow Excel Services to access spreadsheets from) $w = Get-SPWebApplication -identity http://<WebApplication> ...


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 ...



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