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.