Monthly Archives: June 2015

Linking Excel Cell to another Excel file in OneDrive

Posted on June 28, 2015 by chanmingman

This short article shows you to link 2 Excel workbooks in OneDrive is feasible. I created 2 Excel files in OneDrive one named Book1Linked.xlsx and another named Book1Linking.xlsx.   I then linked a cell B3 in Book1Linking.xlsx to B5 cell … Continue reading →

Posted in Community, Microsoft Office | Tagged , , | 2 Comments

Access OneDrive from Windows Explorer in Windows 8.1

Posted on June 28, 2015 by chanmingman

This short article shows you how to access OneDrive from Windows Explorer in Windows 8.1. When you want to download the OneDrive app from the Internet, https://chanmingman.wordpress.com/2015/05/27/use-onedrive-with-windows-explorer/, you will the site written OneDrive comes preinstalled on Windows 8.1.  OneDrive is … Continue reading →

Posted in .Net, Community, Operating System | Tagged , , , , | Leave a comment

Cannot find Windows Update in Windows 10

Posted on June 28, 2015 by chanmingman

This short article shows you where to find Windows Update in Windows 10. Open Windows Explorer, make sure you select your computer, and click on Open Settings.   In the Settings Window click Update and Recovery.

Posted in .Net, Community, Operating System | Tagged , , , , , , , | Leave a comment

401 Unauthorized when using Self-Signed certificate in SharePoint 2013

Posted on June 27, 2015 by chanmingman

This short article is showing you how to configure SharePoint Site to support SSL. If you create a Self-Signed Certificate from IIS and bind directly to the SharePoint site then you will get 401 Unauthorized error like me. You need … Continue reading →

Posted in .Net, Community | Tagged , , | 1 Comment

Sideloading of apps is not enabled on this site – SharePoint Online

Posted on June 26, 2015 by chanmingman

This short article shows how to resolve the error “Sideloading of apps is not enabled on this site”. When you can Start to run in your App for SharePoint then you might get the error “Sideloading of apps is not … Continue reading →

Posted in .Net, Community | Tagged , , , | Leave a comment

Free ebook: Microsoft System Center Data Protection for the Hybrid Cloud

Posted on June 25, 2015 by chanmingman

If you are responsible for architecting and designing the backup strategy for your organization, especially if you’re looking for ways to incorporate cloud backup into your business continuity scenarios, this book is for you. With the increasing trends in virtualization … Continue reading →

Posted in .Net, Community | Tagged , | Leave a comment

The SDDL string contains an invalid sid or a sid that cannot be translated

Posted on June 25, 2015 by chanmingman

This short article shows you the possible way to resolve the error “The SDDL string contains an invalid sid or a sid that cannot be translated”. Following the article http://embraceware.com/blog/2014/05/error-the-sddl-string-contains-an-invalid-sid-or-a-sid-that-cannot-be-translated/ I did the following. 1. Determine which user account you … Continue reading →

Posted in .Net, Community | Tagged , , | Leave a comment

How to Crack Forgotten Excel XLS Password that is protecting your columns

Posted on June 22, 2015 by chanmingman

This short article shows you what to do if you have forgotten the password that you put to protect your columns or someone think they are genius, put the password into Excel columns and leave the company.   This http://www.straxx.com/free-excel-password-remover-2012/ … Continue reading →

Posted in Community, Microsoft Office | Tagged , , , , , | 1 Comment

Problem installing Microsoft SQL Server 2012 or Microsoft SQL Server 2014 in Windows Server 2012 R2

Posted on June 22, 2015 by chanmingman

This short writing just tell you the workaround and it is not really a full solution. I have problem to install Microsoft SQL Server 2012 or Microsoft SQL Server 2014 in Server 2012 R2 after added Active Directory role. I … Continue reading →

Posted in .Net, Community | Tagged , , , , | 1 Comment

Insert Clipart in Microsoft Office

Posted on June 19, 2015 by chanmingman

This short article tells you do not look for inset Clipart to Microsoft Office Component like Word, PowerPoint, and others again. Microsoft has killed the beautiful feature in Microsoft Office, Insert Clipart. My workaround is, click on the INSERT tab, … Continue reading →

Posted in Community, Microsoft Office | Tagged , , , , , , | Leave a comment