Click-to-Run and Window Installer on same computer?

“We’re sorry, Office Click-to-Run installer encountered a problem because you have these Windows Installer based Office programs installed on your computer”


Unfortunately, you can’t have Office products of the same version (like 2013 or 2016) that use two different installation technologies (Click-to-Run and Windows Installer) installed on the same computer. To fix this problem, remove the Windows Installer version of Office. Then, retry the installation of Office you were doing when you got the error message.

Get year of created date in a calculated column

If you need to extract year from created value, just create new column  and use the following formula:




New column should be single text in order to use its value in views and filters, because date format is not supported.