Category: Addins
-
Microsoft Excel: The File couldn’t open in Protected View – Security Error Message
When we receive the error message “The file could not open in Protected View” in Microsoft Excel, it means that Excel application has detected potential security risks in the file. This Protected View is a security feature in the latest version of Microsoft Excel that helps prevent malicious content from running on your computer. This…
-
Missing Windows Authentication Feature IIS and Windows 10
If you have windows 10 Home or SL version when might be you are unable to see Windows Authentication under IIS options when installing. To enable “Windows Authentication” either you need to upgrade the OS to Pro version or you can run this command to enable it. C:\WINDOWS\system32>dism /online /norestart /add-package:%SystemRoot%\servicing\Packages\Microsoft-Windows-IIS-WebServer-AddOn-2-Package~31bf3856ad364e35~amd64~~10.0.17134.1.mum The file name will…
-
How to fix apache drill startup error on windows-10
Apache Drill can be downloaded from here. It will works fine on windows 7 but it is giving error when you install it as embedded mode on Windows-10. Error is something like that after running the command: sqlline.bat -u “jdbc:drill:zk=local” Error during udf area creation [/C:/Users/<user>/drill/udf/registry] on file system [file:///] (state=,code=0) After googling I found…
-
remove duplicate values from a excel cell
Microsoft Excel is used by everyone in the world for all data related things, some time we have duplicate cell contents in rows or in columns. To remove these duplicate values from the sheet we already have a feature “Remove Duplicates” in latest version of the excel application. But if we have some duplicate values…