Auto fill and drag and drop columns unchecked - Excel 2016

[Jan Möhring]

Hallo,

i've got a little problem.

When ever i start excel the option described in the title is always unchecked.

Everytime i use excel i have to enable this option.

Perhaps somebody has a solution for this.

Best regards,

Jan

[#2]

That sounds odd.  This setting should be checked by default I think unless your Admin disabled it:

Registry Key Link

If the admin didn't disable it then the only thing I can think of is to try to repair Office:

MSFT Office Application Repair Tool

[#3]

Hello Jan,

have you tried to start Excel in SAFE mode (i.e. by pressing CTRL when starting Excel and confirm the appearing message box)? Maybe it is an Addin or something in the Excel autostart-Folder.