Dropdown menu gone when saving and when closing file?

HardWorker

New Member
Joined
Jun 2, 2015
Messages
2
Hi All. According to the following video https://www.youtube.com/watch?v=XjnCFez4pto I learned how to make a dropdown menu in every single highlighted cell of chosen column based on the data on different worksheet of same Excel file. I also made sure I am NOT skipping the empty cells. I finished the procedure exactly the same as author on video did on 1:35 minute and consequence was correct, same as i wanted and same as shown on 1:40 minute. However my problem is that after making sure, for three times, that i really use SAVE button before closing excel, when reopening this same file, all the dropdown menus are gone - they didn't get saved. Whichever cell I click in same column (previously, before closing file, dropdown menus in every single cell were there successfully!) it doesn't have that dropdown menu anymore. They are gone. After doing a little of google research I discovered the problem might be solved if saving file to different extension but somehow I want to avoid doing this. How could I make sure they get saved permanently? I have 2013 version. Thank you a lot in advance.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
i researched further and also changing in Settings\Advanced to show all objects DOESN'T help as this is already ticked.
 
Upvote 0

Forum statistics

Threads
1,203,640
Messages
6,056,491
Members
444,869
Latest member
tulo spont

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top