Tag Info

New answers tagged

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


0

Shared workbooks have been a source of trouble for years and should be avoided. Why do you use an Excel file if you have SharePoint? Instead of the file, create a SharePoint list and multiple users can simultaneously edit the list.


1

unfortunately this limitation is being in SharePoint 2013 for create the connection to power pivot data model follow this blow links http://msdn.microsoft.com/en-us/library/hh230901.aspx http://msdn.microsoft.com/en-us/library/hh213103.aspx#bkmk_create http://msdn.microsoft.com/en-us/library/hh230813.aspx



Top 50 recent answers are included