Combo box loosing it´s data.

G

GastonFranzini

I have a combo Box that is linked to a dinamic range in another
workbook.
It works ok until I close the workbooks. When I open the workbooks
again It looses it`s link.
The solution is to go to properties of the combo box and select
listfillrange and then it starts working again.
Is there a way to solve this problem?
Thanks
 
C

Chip Pearson

I would try linking the combobox to a range on the same sheet, and link that
range to the external file. Its two links instead of one, but is probably
more stable.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
G

GastonFranzini

That`s the way I have it.
The problem is that The source file needs to be opened previously.
Thanks
 
Top