Tag Info

New answers tagged

0

The problem that causes this error is when the Claims to Windows token service is using a service account and not the Local System account. It's an easy fix that will get rid of the "Unable to refresh data for a data connection in the workbook" error. To fix the problem follow these steps: Logon to the server you installed Powerpivot on Click Start Click ...


0

Depending on what you are trying to achieve it may be easier to come at this from a different angle. You could write a macro in excel that will allow you to grab the data for the entire list, then split by category into individual sheets (or books).


0

Unfortunately the default SharePoint Export to Excel behavior will only export a .iqy file that ignores any filters applied. As mentioned in the comments, there are a lot of 3rd party solutions to achieve this functionality that you might want to look into - for instance, Export Selected Items to Excel could do the trick (create a view with no pagination and ...


1

There is no way OOTB to have a column filter behave like the one you have in Excel. As you already noticed, the SharePoint filter is an exact-match type of filter. There is a workaround though, which involves creating a parameter on the XsltListViewWebPart and adding either a text filter webpart or a textbox input control on the same page where the XLVWP ...


0

Under "Library Tools", you have "Export to Excel", then you can filter this Excel and save it to .csv


0

I believe your seeing the result of a perfect storm from using InfoPath, Versioning and Enh Rich Text. http://www.guio.com/marlene/Lists/Posts/Post.aspx?ID=10. Eliminate one of the three attributes(InfoPath, Versioning and Enh Rich Text) to resolve the issue .


0

What I could notice is that the excel files that are not previewed its because they have protected sheets, which makes sense!


1

You need to add properties in Excel and then align them to Columns in sharepoint. Make sure the names align. For Each Prop In WB.ContentTypeProperties If Prop.Name = "DateSubmitted" Then Prop.Value = Range("DateSubmitted").Value End If Next Prop


1

After doing some more research, it looks like there is no way to do this from VBA.


1

You can specify per list if (under Advanced settings) if documents should default to Office Online (WAC) or the Office Client. You cannot do it only do it for Excel files - it's always for all Office docs.



Top 50 recent answers are included