Tag Info

New answers tagged

0

excel macro buttons (done via the macro interface) don't show up in the browser version of excel, the macro buttons would have to be activex buttons instead (not sure if they work that way though, I haven't tried).


0

I believe you need to create a new View with whatever filter you currently have and then exporting to spread sheet will only contain the relevant items.


2

No, that is a library level setting. SPFile.RequiresCheckout is a read only property that tells you is 'check out required' setting set for the document library.


0

As it turned out, it was a circumstantial MS Office bug. Third-party CSP (CryptoPro) did not initialize in time to verify the signature. This happened only when Excel opens file from sharepoint and no previous Excel instance running.


0

downgrading from enterprise to standard is not easy path. you have to clean the farm first, uninstalling the EE features. Rebuild the farm with Standard Key. http://www.concurrency.com/blog/sharepoint-enterprise-standard-edition-downgrade/ ...


0

That should still work to the best of my knowledge. I believe connecting workbooks to Excel is available in all SKUs of the product, Foundation, Standard, and Enterprise.


3

From the Excel Web Access Web Part it's not possible to edit the workbook in such a way that you save content. Excel Web Access is a Web Part. It can display all or part of an Excel workbook, and enables interaction with the workbook in a browser by using Dynamic Hierarchical Tag Markup Language (DHTML) and JavaScript. Because Excel Web Access is a ...


0

You can use ExcelPlus that permits to deal with Excel in JS and its based on xls-js ... I created it while working on SharepointPlus, a JS library for Sharepoint.


0

I doubt about doing this with a excel template but yes there is way to do excel with JSOM it involes of Excel Web Access webparts Check here for more details


1

Go to List and in the ribbon bar you will see an export to excel button. Click on that will save data in excel. save the file with the default "owssvr.iqy". Open it by double clicking, it will open in excel and then make some edit in the file like writing some text and then if you want delete it again and then save the file with .xlsx or xls extension. Now ...


0

Go to List and on top of List you will see an export to excel button. Click on that will save data in excel.


0

I had the same problems with the Excel Services and found a solution for the office webapps for word and powerpoint also. Follow the procedure below. The problem was traced to SharePoint’s built-in URL redirection for various files types. Behind the scenes, SharePoint is attempting to redirect the Excel/Word/Powerpoint file to a common viewer component. We ...


0

If you have the excel Service enabled then this problem is most probably with ASP.NET Impersonation. Solution: Disable the ASP.NET Impersonation at the Server level and "SharePoint Web Services" level. Via: IIS > Authentication > ASP.NET Impersonation https://support.microsoft.com/en-us/kb/2291790?wa=wsignin1.0 IF no ECS configured in the farm then ...


0

You are able to use Rich Text and Enhanced Rich Text in a SharePoint list. First, you need to make sure the column is set up appropriately. (List Settings -> Click on column name -> Make sure it is Multi Line of Text column and that at least Rich Text is allowed). Copying the formatting directly from Excel doesn't work but you are able to format it after ...


-1

SharePoint 2013 handle only some column types like: 1 line of text, multiple lines of text, number, date, ... but not the style of text. To make bold text in a SharePoint table, you can modify the CSS of the page.


0

You just have to extend the duration of the Excel export or request timeout by doing the following: Log in to Central Admin as a Farm Administrator Click Application Management in the left nav. Click Manage service applications under Service Applications. Click Excel Services Application next to Excel Services Application Web Service Application Note: ...


0

Problem is in trusted web. Please delete URL of the site where the file is on from "Local Intranet" and "Trusted Web Site" in Internet Explorer Settings.


0

Well I'm curious what steps the IT took to resolve the issue, if you have that information please share. Here are some potential causes. You are accessing from a different browser than the designer anticipated. Check if another browser has the same issue if you have access to one. If you are using IE, I've seen some weird interactions between temporary ...


0

In order to query SharePoint Data with Excel, you should use PowerQuery. Beware, if your sharepoint site hasn't been created with the english language template, you'll have to query the list through ODATA



Top 50 recent answers are included