I've been asked to change an old Excel spreadsheet I made, but I can't for the life of me find where the list of values for this dropdown are stored:
Right-click > Pick from dropdown list but the list is empty.
I've copied the cell to a new Excel sheet and uploaded it to Dropbox.
How can I edit the values?
If I can copy just the single cell to a new Excel file, the values have to be stored within the cell somewhere, not in a hidden sheet etc.