Avoiding Corrupt Excel™ Workbooks
|
Avoiding Corrupt Excel™ Workbooks |
|
|
There is a situation that will cause a spreadsheets to become corrupted that
is not easy to find information about online. The information is there but it takes some searching to find it. The symptoms are that a spreadsheet with a drop down list defined as a comma separated string that exceeds 256 characters in length will work fine until it is saved and re-opened. Upon re-opening the workbook is corrupted. It can be repaired but it leaves sheets in the workbook that can't be used (We were even unable to delete them in our case). It turns out that a drop down list cannot exceed 256 characters or this corruption occurs. The way around this is to use a range of cells rather than a comma delimited list. This link will take you to the FillDropDown subroutine which also contains user instructions and some sample code on how to use the subroutine. For a full working spreadsheet, please see our Coin Collection Workbook which is available here We are uncertain that this issue will ever be fixed by Microsoft, but this workaround should work regardless of the length of the list specified in the range. |
||
Number of unique visitors 199
Copyright © Abbydale Systems LLC 2015-2024
Abbydale Systems LLC Lic. 802696149. All rights reserved.
