Share via

Excel Date Autofill problems

Anonymous
2020-04-27T18:23:09+00:00

Hi all :)

I have a problem with autofilling dates in Excel (Office 365). It is not possible to autofill dates. This is the same for days, months or years. I do not even come to point to choose what to autofill ( drag down while holding right-click).

My cells are in the right format for my region. I can change them to short or long format without a problem but the autofill won't work.

For your information my display language (Windows + Excel) is english. Region settings for Germany.

Maybe someone had the same issue or can help me.

Best regards

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

23 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-29T08:07:37+00:00

    Thanks for your advice. I tried the safe-mode and it worked properly.

    After a repair I will tell you if it fixed the problem. I checked the Add-ins too. There was no active add-in.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-04-29T08:13:22+00:00

    Thanks for your advice. I tried the safe-mode and it worked properly.

    After a repair I will tell you if it fixed the problem. I checked the Add-ins too. There was no active add-in.

    0 comments
  3. Anonymous
    2020-04-29T08:44:22+00:00

    After the online-repair there is still no difference. It works fine in safe-mode but only in safe-mode.

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2020-04-29T09:18:00+00:00

    Working in Safe Mode means that there is an addin causing the problem. In the reply that I suggested using safe mode, the last 2 lines are articles on testing to find which specific addin is causing the problem.

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2020-04-29T12:53:23+00:00

    Yes, I checked if there is any active add-in but there is none. But there are several add-ins inactive but loaded(?). The "Microsoft Actions Pane 3" xml-expansion is loading again after removing it and restarting excel.

    Is it useful to delete all add-ins to check if they are causing the problem?

    0 comments