autofill at excel 2016 didn't work

배승철 0 평판 포인트
2026-09-14T06:38:46.62+00:00

사용자의 이미지

Excel AutoFill was working fine until yesterday, but today it suddenly stopped working. When I drag the fill handle and release the mouse button, nothing happens at all and the target cells remain completely blank.

I have already tried the following troubleshooting steps, but the issue persists:

Running Excel in Safe Mode (excel /safe)

Testing on a brand-new blank workbook

Restarting the computer

Check setting to set drag and drop option and etc

I couldn't find any working solutions online. Has anyone encountered this issue or know how to fix it?

Microsoft 365 및 Office | Excel | 기업용 | Windows
댓글 0개 설명 없음

답변 2개

정렬 기준: 가장 유용함
  1. EmilyS_726 30,360 평판 포인트 자원봉사자 감독
    2026-09-15T01:22:31.7666667+00:00

    최근 업데이트로 인해 알려진 문제입니다.

    https://support.microsoft.com/servicing/office/hotfix/excel/5002914

    작업 표시줄의 검색에 cmd를 입력해 주세요. 아직 엔터 키를 누르지 마세요. 대신 "관리자로 실행"을 선택해 명령 프롬프트를 실행하세요.

    그 다음 이 명령을 실행하세요. 명령 시작 부분의 따옴표를 포함해 전체 명령어를 복사하세요.

    "C:\Program Files\Common Files\Microsoft Shared\OFFICE16\Oarpmany.exe" /removereleaseinpatch "{90160000-0012-0000-1000-0000000FF1CE}" "{27882596-A8ED-4382-9C71-6CD2DD19F732}" "1033" "0" 
    

    명령어는 이 문제를 일으키는 최신 업데이트를 제거하는 것입니다.

    이 대답이 도움이 되었나요?

    댓글 0개 설명 없음

  2. Darren Bruce 1,930 평판 포인트 독립 자문가
    2026-09-14T07:08:03.5866667+00:00

    Note: Since you are using English, although the site locale is ko-kr (Korean), I will response to this question in English. If there is anything unclear about my reply, please leave a comment and I will get back to you as soon as possible.  

    Dear @배승철,

    Based on your description, the problem is unlikely to be caused by a workbook-specific issue or an add-in. Could you also confirm whether the issue occurs in a completely new blank workbook?

    In the meantime, here are some suggestions you can try:

    1/Disable Hardware Graphics Acceleration

    • Go to File > Options > Advanced
    • Under Display, enable Disable hardware graphics acceleration
    • Restart Excel and test again

    2/Reset Excel User Settings

    • Close Excel
    • Open Registry Editor
    • Navigate to:
    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel
    
    • Rename the Excel key (for example, to Excel_old)
    • Start Excel again and test AutoFill

    3/Verify Sheet Protection

    • Check Review > Unprotect Sheet
    • Ensure the workbook/sheet is not protected.

    4/Repair office

    • Open Control Panel > Programs and Features.
    • Select Microsoft Office.
    • Click Change.
    • Run Quick Repair first.
    • If the issue persists, run Online Repair.

    Additionally, some users have reported similar issues after installing recent Office updates. It is possible that the problem is caused by a bug in the current Office version.

    For reference https://support.microsoft.com/en-us/servicing/office/hotfix/excel/5002914

    As a troubleshooting step, please try reverting to a previous Office build and see whether the issue still occurs. If the problem is resolved after the rollback, it would indicate that the issue is related to the latest Office update.

    Please note that Office 2016 reached end of support on October 14, 2025. While the applications will continue to run, Microsoft no longer provides security updates, bug fixes, or technical support for Office 2016.

    I hope information above can help you resolve the issue, feel free to reach out if you have any other questions.


    If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment".   

    Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    이 대답이 도움이 되었나요?


답변

질문 작성자는 답변을 '승인됨'으로 표시하고, 중재자는 답변을 '추천됨'으로 표시할 수 있습니다. 이를 통해 사용자는 해당 답변이 작성자의 문제를 해결했다는 것을 알 수 있습니다.