 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006Combo box loosing it´s data.
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 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.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) >I have a combo Box that is linked to a dinamic range in another > workbook. [quoted text clipped - 4 lines] > Is there a way to solve this problem? > Thanks That`s the way I have it. The problem is that The source file needs to be opened previously. Thanks
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.