Tag Info

New answers tagged

0

Best advice I can offer you is to create a value in the choice column of your list. Call it something like: N/A SharePoint choice fields data actually looks like [ID];#[Text Value] In order for your no to manipulate your data in your excel sheet for SharePoint to except the data, you will need to determine what the ID of that choice value is. So, in ...


0

I cannot say exactly what is happening but I've had similar problems, resolved by one or more of the following: Repair Office 2010 on the client machine and restart Upgrade to IE10 or above Remove cached files from the upload center


0

I don't think this is possible with a calculated column as the data for the column is only calculated when the item is updated. You might can achieve this with the Client Side Render of a custom column in SharePoint 2013.


0

You are able to access the files in a document library via C# SharePoint Library and read from an excel file. Read from excel file: http://social.msdn.microsoft.com/Forums/vstudio/en-US/b6e8a28c-6760-4e86-a1aa-e2ce9ec36380/reading-excel-from-c?forum=vsto Use C# to access sharepoint list: ...


0

From previous experience, here are some topics to help mitigate and/or solve office integration problems: reinstall office and restart (same behavior below) For some users documents keep opening in browser clear out microsoft upload center reset/repair IE http://support.microsoft.com/mats/ie_performance_and_safety/ upgrade to the next available ...


0

I would try adding my SharePoint URL to the trusted sites and Intranet sites list in IE settings. This would remove the window Alex was referring to and allow the user to see a yellow bar at the top of the Excel window that allows them to edit the document.


0

Just to clarify this is not referring to running Macro's in Excel Workbooks stored in SharePoint - that is definitely do-able in SharePoint 2013!


2

It seems that you would want to upload an excel document to a document library and while that happens, do stuff. One way to achieve this is creating an event receiver that captures the ItemUpdated event. For the "do stuff" part, you can use the openxml api, which will allow you do read data from the excel document and populate it in the list. here are a ...


0

I have not found a way to do this either. But I found one workaround: To avoid having to open each response to see the selection made, I found that the RSS feed view at a least contained the value chosen. From there I copied the feed into excel and cleaned it up. I tried attaching the list in Ms Access - but it isn't an available list to choose. If ...


1

I tried your issue and unable to reproduce it. I use an Enterprise E3 license and on my team site I have checked the default behaviour in advanced settings: To enable editing I need to switch from viewing to editing before start: When this is done, it works like a charm. But I don't use Power View - which I'm afraid to say isn't supported: You can ...


0

Create a Data Source document library in your Sharepoint site and upload the iqy file there. Check it in and approve it. Rebuild your workbook to use that datasource. Publish via Excel Services.


1

An export to Excel will only ever export the view columns, not the grouping. You will need to build this in Excel from the ground up. Create a copy of that view. Add the grouping columns as view columns and don't group, then export. In Excel, build a pivot table. Drag all desired columns into the rows area. Set the pivot table to be a tabular format. ...


2

Had the same problem with two user fields containing texts. Export works fine without them. And the Solution was to add additional Filter to the View! The Filter is on Date Created Field (in my case) > xx and it's set so that all the data that we were displaying before is also shown, the additional Filter does not return any less Results, so the amount of ...



Top 50 recent answers are included