[h=1]Losing some dropdown lists when closing Excel[/h]We have a form created in 93-2003 Excel that populates other forms in the same workbook. There is also a tab we use just for reference data in the dropdowns and formulas we use. This is currently being used in Excel 2010. Operating system is Windows XP.
Now I've added a new forms (tab) with many formulas and references to populate areas from the first tab, which is the main form. Everything works until the file is closed and then the drop downs on the first page disappeared and had to be re-done and continue to be lost when the form is closed.
Now I am back to trying to solve after several weeks of putting it on the back burner and miraculously six dropdowns stay and three are still being lost, the same three each time. All setting are the same, I've made sure the Macros are enabled and then tried with them disabled. Can't find anyone with the same issue, so I'm looking for suggestions.
I'm not a techie, so talk to me as if I know nothing...which is very near the truth.
Thank you for your time.
Now I've added a new forms (tab) with many formulas and references to populate areas from the first tab, which is the main form. Everything works until the file is closed and then the drop downs on the first page disappeared and had to be re-done and continue to be lost when the form is closed.
Now I am back to trying to solve after several weeks of putting it on the back burner and miraculously six dropdowns stay and three are still being lost, the same three each time. All setting are the same, I've made sure the Macros are enabled and then tried with them disabled. Can't find anyone with the same issue, so I'm looking for suggestions.
I'm not a techie, so talk to me as if I know nothing...which is very near the truth.
Thank you for your time.
