Tag Info

New answers tagged

0

Sorry there is no option for this in quick edit view. I was referring to Data Sheet view before. Which seems to be much different with the new quick edit implementation. Please refer this thread where a Technical Community Support member posted in Technet.


1

If you want to create and modify Office documents you'll need to work with a different technology, Open XML. You can download the Open XML SDK here: http://www.microsoft.com/en-us/download/details.aspx?id=30425 More information is available here: http://msdn.microsoft.com/en-us/library/office/bb448854(v=office.15).aspx I didn't check up on it in detail, ...


0

The best work around I've found (with help) is to 1) Let the import complete with the multiple lines 2) Go in to Sharepoint > List Settings 3) Change the column properties from text to plain text, and number of lines to 1, 4) Save, exit and then reopen the Column properties 5) YOu should now have the option to change the multi-line to single line You ...


0

I think the answer here would be related more to good practices when using files. If you use versioning and the whole check-in/check-out system, then the users will be prompted to specify what changes they made when they check the file back in. Alternatively, you can skim the current version of the excel file and the previous version and try to spot any ...


0

This is not a feature that can be done in SharePoint about any type of file. However Excel 2013 has a feature called Spreadsheet enquire that can show you the differences between 2 versions of the file. http://office.microsoft.com/en-001/excel-help/what-you-can-do-with-spreadsheet-inquire-HA102835926.aspx That is the closest you can get to what you want to ...


0

There are multiple things you have take into account: Only Excel Files created with Excel 2013 are supported. They must be saved in Excel 2013. Credentials must be correctly supplied (Unattended PowerPivot Data Refresh Account) Secure Store Service must be setup correctly If using credentials in your excel file, it must be stored in the excel file. Only ...



Top 50 recent answers are included