Values in combo boxes not visible after closing then re-opening...

B

blankcomboboxes

I have a number of combo boxes in an Excel sheet that are populated prior to
saving the sheet. After saving, closing and re-opening the sheet, the combo
box values are not visible. Re-calculating with F9 does not help. When I
click "Print" they reappear, however. This file is used by many people and I
would like to find a better solution than telling everyone to click "Print"
after they re-open it. Any suggestions would be greatly appreciated.
 
Top