Excel 2016 Custom Lists not saving

Question

I'm using Excel 2016 Professional Pro.  Every time I add entries into a Custom List, they are lost when Excel is closed.  I've tried running "As Administrator" and it didn't change the results.

What setting needs to be updated to allow custom lists and other defaults to stick?

**Moved from: Office / Excel / Windows 10 / Office 2016**

Answer 1

Hi Rena,

1.  Yes, I did try the Repair option found in Control Panel.  After that, I rebooted the system to start fresh.

2.  Here is a screen shot from my screen.

As you can see, there is no "Version" number display.

3.  When I say "other copy of Excel", I'm referring to when I worked at a different company on a different computer.  This is the first time I've ever seen these options not work properly.

Thanks,

Jeff

Answer 2

Hi Jeff,

Thanks for the update. Here we still want to collect the information below:

1. Have you tried to repair the Office via Control Panel to fix the issue? You can refer to

 Repair an Office application. 2. The Office version we need is under File > Account > Product Information. You can provide a screenshot like this. 3. You mentioned that “This has never worked with this copy of Excel.  I've never seen this issue with any other copy”, What do you mean the “copy of Excel”?

Thanks,

Rena

Answer 3

Hi Jeff,

Please first try to Repair an Office application to see if this can fix the issue.

If the issue persists, please provide the information below for our more investigation:

1. Is the “custom list” you mean is Sort data using a custom list?  No.  I go to File>Options>Advanced>Edit Custom Lists.  I add entries in the Custom List.  The entries in the Custom List are retained during that session of Excel.  After Excel is closed and reopened, the entries in the new Custom List are gone.
2. What’s your Office version? You can go to File>Account>Product Information to check it. For example: 1708(8431.2031).  It says, "Microsoft Excel 2016 MSO (16.0.4549.1000) 32-bit.
3. Can your Excel remember other customized settings? For example, styles.  I'm not sure.  I've not checked anything else.
4. When did the issue happen? Was there anything changed before the issue occurred?  This has never worked with this copy of Excel.  I've never seen this issue with any other copy.
5. To see if the issue has something to do with the Office add-ins, run Office safe mode via holding CTRL to launch the Excel to see the result.  When that is tried, the selection at File>Options>Advanced is greyed out.  I cannot make Custom List entries to verify.
6. To see if the issue is affected by some third party programs, run Windows clean boot to see the result.  I am not an administrator at my company and I'm unable to do this.

Thanks,

Rena

Answer 4

Hi Jeff,

Please first try to Repair an Office application to see if this can fix the issue.

If the issue persists, please provide the information below for our more investigation:

1. Is the “custom list” you mean is Sort data using a custom list?
2. What’s your Office version? You can go to File>Account>Product Information to check it. For example: 1708(8431.2031)
3. Can your Excel remember other customized settings? For example, styles.
4. When did the issue happen? Was there anything changed before the issue occurred?
5. To see if the issue has something to do with the Office add-ins, run Office safe mode via holding CTRL to launch the Excel to see the result.
6. To see if the issue is affected by some third party programs, run Windows clean boot to see the result.

Thanks,

Rena