Forum Discussion

pejbox's avatar
pejbox
Copper Contributor
Jan 16, 2023

Excel 365> autofill, flash fill, custom lists not working

Hello.

Working here on a latest Windows 10 Pro with latest Office 365 Version 2212 Build 16.0.15928.20196 64-bit.

I had found a couple of months ago some weird behavior and today was trying to resolve it as it got too annoying to live with.

Issue 1. When I try to enter Options->Advanced->Edit Custom Lists, nothing happens. The "Advanced Options" window closes for a moment and opens again. So, there is no way to edit custom lists.

Issue 2. But what is most frustrating is that Excel does not understand simple series any more. I enter 1 and 2, select them both and try to stretch with autofill function, but just receive an endless line or columnt of 1s and 2s. So this:

Becomes this:

Same goes for Monday and Tuesday, for example. When I enter dates, say 1.01.2023 and 1.02.2023, I get a sequence of them in turns. 

If I try to Ctrl+E them (Flash Fill), I get this:

 

I tried reinstalling Office. Uninstall / Clean Registry / Clean using Microsoft SARA, and then installing again after restarting the computer - no luck. I get the installer from my Microsoft account page.

The needed "enable fill handle" and all the other options have been turned off and on again a gazillion times - nothing:

 

 

Anyone had the same problem with lucky ending? Or am I the only "lucky" here?

 

Thanks in advance

excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 16, 2023

    Hi pejbox 

     

    You're not the only lucky one. I'm on the same Version + Build (Click To Run) and have been experiencing the auto-fill issues for days at least (same with previous version). I haven't checked the other issue you mentioned

    • chas707's avatar
      chas707
      Copper Contributor
      Apr 02, 2023
      The same is happening to me. I'm on the latest windows 11 with updates.
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Apr 03, 2023

        chas707 

        Not sure when this happened exactly but functionnalities are back here for about a month

        Currently running Version 2302 Build 16130.20332 Current Channel where everthing works as expected

  • pejbox's avatar
    pejbox
    Copper Contributor
    May 17, 2023
    Well, I am still out of luck. Had to buy and install a 2021 version and today after reading L z. reply, decided to give M365 another try. And... it still does not work. Auto series still do not work. And I am still unable to enter Custom lists. Also, built-in lists do not work (try entering "Monday" and then auto-filling with series filler. I get "Monday" only). The version is the latest one: Version 2304 (build 16327.20248 Click-to-Run).
    I am frustrated. Will have to reinstall 2021 version again. And, what's even more frustrating, is that I can not install two versions in parallel: one for one user, second - for the other. As soon as I enter a 2021 key, both users' versions become 2021. But that's not the issue of this topic, just another complaint.
    So, no solution as of today, 17.05.2023.
  • Ginorio1's avatar
    Ginorio1
    Copper Contributor
    Oct 27, 2023

    Also have the same issue - unable to resolve it with any "Options" configurations - perhaps MS will address the issue? pejbox 

  • pejbox's avatar
    pejbox
    Copper Contributor
    Jan 05, 2024

    Installed fresh version today: 2312 (Build 17126.20126 Click-to-Run) and having same issues. I guess Microsoft is not going to investigate and make any improvements - there seems to be too few of us with this problem.

  • pejbox's avatar
    pejbox
    Copper Contributor
    Sep 12, 2024
    Installed 2409 18025.20030 version today - no change. Probably will have to use some other office product on this computer.
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Sep 12, 2024

      pejbox 

      That's Current (preview) channel. I'm on Current

      and it works. Select

      and drag down

      Settings are

      • pejbox's avatar
        pejbox
        Copper Contributor
        Sep 18, 2024

        SergeiBaklan 

        I have exactly the same settings:

        And I am still getting this:

        And this:

        And if I try to edit custom lists, it still does nothing. On all my other computers everything works as intended.

        Version and license:

        As I understood from other commentaries, I am not the only one with this problem. Maybe, there's too few of us, the unlucky, for Microsoft to investigate.