SharePoint Online 2013 vs. SharePoint 2013 On-Premise

This short articles show you all the features that is meant for SharePoint On-Premise. When you reach this page https://technet.microsoft.com/en-us/library/jj819267.aspx then you will find the article comparing SharePoint Online Edition and SharePoint On-Premise Edition separately. Somehow the features it compares are the same. I extracted out what is in On-Premise but not in SharePoint Online as the table below. Development Features SharePoint Online SharePoint On-Premise BCS: Profile Pages No Yes BCS: Rich Client Integration ...

This workbook contains links to one or more external sources that could be unsafe

This short article shows you how to resolve the error “This workbook contains links to one or more external sources that could be unsafe.” which may keep popping up when you are opening the Excel workbook. I have been researching for a bit but I do not seem to find a build-in Excel solution for that. Alternatively, I managed to find Findlink http://www.manville.org.uk/software/findlink.htm Excel Add-ins. There is a file you will find findlink.xla. Open the file with the error. Go to File -> Add-Ins. Under Manage: choose Excel Add-ins then click Go. Browse to your findlink.xla then click OK. Up to this point you will be panicking as you may not find anything in your Spreadsheet Ribbon after selecting the add-ins. To resolve this, do not close the Excel spreadsheet, but instead double click on the findlink.xla file. This is how it looks. Now you can find your broken links. :)