Providers in SQL Server linked server configuration

How ‘allow in process’ works for providers in SQL server linked server configuration ? It looks like it’s unchecked by default. What is the requirement for keeping this option checked and What are the pros and cons of using it.