Forum Discussion
Auto fill and drag and drop columns unchecked - Excel 2016
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 Replies
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.
That sounds odd. This setting should be checked by default I think unless your Admin disabled it:
https://getadmx.com/?Category=Office2016&Policy=excel16.Office.Microsoft.Policies.Windows::L_EnableFillHandleAndCellDragAndDrop
If the admin didn't disable it then the only thing I can think of is to try to repair Office:
https://support.office.com/en-us/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b?ocmsassetID=HA010357402&CorrelationId=b0741cc0-b138-4200-bf42-ce689b47241c&ui=en-US&rs=en-US&ad=US
