+ Reply to Thread
Results 1 to 5 of 5

Searchable Drop Down List in Excel formulas doesn't save

  1. #1
    Registered User
    Join Date
    08-01-2017
    Location
    Lithuania
    MS-Off Ver
    2110
    Posts
    6

    Unhappy Searchable Drop Down List in Excel formulas doesn't save

    I made searchable Drop Down List in Excel, however it doesn't save after i save, lock the cells and close the document.
    I would like to give an example, but as it's not saving - it's meaningless.

    Maybe someone knows why?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Searchable Drop Down List in Excel formulas doesn't save

    Quote Originally Posted by kikimara View Post
    ... but as it's not saving - it's meaningless ...
    Difficult to suggest what is happening, then.

    Maybe you could explain what you mean by "... searchable Drop Down List ... " in a bit more detail. Oh, and tell us what your location is, by updating your profile by using User CP.

    Pete

  3. #3
    Registered User
    Join Date
    08-01-2017
    Location
    Lithuania
    MS-Off Ver
    2110
    Posts
    6

    Re: Searchable Drop Down List in Excel formulas doesn't save

    Thank you for reply. I'm from Europe.
    I did the listing with help of this video.
    watch?v=Z-h2UER3b_0&t=463s

  4. #4
    Registered User
    Join Date
    08-01-2017
    Location
    Lithuania
    MS-Off Ver
    2110
    Posts
    6

    Re: Searchable Drop Down List in Excel formulas doesn't save

    What exactly doesn't saves is the Data validation list with Excel Spill Array.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,552

    Re: Searchable Drop Down List in Excel formulas doesn't save

    You might try searching through the comments below the video (youtube) to see if anyone else experienced problems saving the file and if they were offered a solution?
    Perhaps the statement made near the 1:15 mark of the video stating that this will work for the 365 version, insider edition, which doesn't appear to be what you have based on the profile (2110 ?)
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Searchable Drop down list
    By ashrafbh in forum Excel General
    Replies: 4
    Last Post: 11-02-2020, 05:56 AM
  2. Searchable Drop down list in excel online at SharePoint
    By VireshRuia in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 05-07-2019, 02:57 AM
  3. Drop down menu to reference different sheets in searchable drop down list
    By MJAHNKE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2019, 01:00 PM
  4. [SOLVED] Searchable drop down list
    By roadwreck in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2018, 04:52 AM
  5. Searchable drop down list
    By sradjend in forum Excel General
    Replies: 17
    Last Post: 02-12-2018, 07:38 AM
  6. Searchable Drop down list
    By axangec in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-20-2016, 08:43 AM
  7. Searchable Drop down list
    By Jesscyca in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2014, 11:03 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1