When I originally asked this question it some how got flagged in the programming catagory instead of the microsoft office catagory and there seems to be no way of changing the catagory, so I am submitting it directly to you, if you would care to address it
I am having a problem in Excel 2010 deleting certain combo boxes. Most of them I have been able to delete with no problem, but I have two that I just can not find anyway to delete. If I delete the rows they are on, includes the ones above and below it, the rows are deleted and the cells are move up, but the combo box remains where it was I have enabled the developer tab, but find no way that works to delete the box
Hi Dennis,Thank you for writing back. I believe our moderators already addressed the category problem since it is now listed under MS Office.Regarding the deleting of combo boxes, have you tried these trick?=> Right click on the combo box=> There is no delete command there. Press ESC key to close the context menu but you shall see that the combo box is still selected.=> Press the DEL key in your keyboard to delete the control (combo box)Another way is to right click on the combo box, then click on CUT. The combobox shall be deleted.Please give it a try and let me know your results so that I can help you further.Best regards,Jess
I have tried right click and cut - that does not work
I have tried selecting several rows in using the ones above a d below i;t
The rows do get deleted but the combo box does not get deleted
Note there were multiple copies of the section including combo boxes, selecting these rows and deleting them removed tbe combo boxes as well. But I ended up with one row with several combo boxes on it that still work.
I could delete cells between the combo boxes and the box would shift to the left as expected
I can add additional rows between the combo box and the row above it and it move down
I just can not delete it
Thank you for your reply
Will do this afternoon when I get back to work
The file I want to send I am unable to open, edit and save. It is an xls file created and edited in Excel 2003
I am attaching a much simpler file which is actually a copy and paste from the problem file prior to having my machine upgraded to Excel 2010
The following is a copy and paste from the file
There are no complex forumulas, simple division, rounding and sums
I hope this helps
As for the 2nd question - not being able to delete the combo box I have attached a second file
File ID: 173854
I reduced the file greatly, leaving some combo boxes that I can delete and others that I can not detete
Hi Dennis,Thank you for patiently waiting. I got your files and here are the results of the troubleshooting that I did on your 2 Excel files.First, the 16.5MB file. I believe it was created by an older version of Excel and it was extremely "bloated" in terms of file size. The reason for this is data corruption. That is, as your save the file over time, data stored in the file were corrupted, some of the data I should say, which was causing the file to be bloated (16.5MB now).When I tried to open the huge file using Office 2003, the corrupted data were discarded in order for Excel to be able to open it. The same thing happened when I tried to open the huge file with my Office Excel 2010. Now, only the readable and non-corrupted data were recovered. Here is the recovered file:http://wikisend.com/download/406798/Week%2016%20boxes_repaired.xlsIf you are using MS Excel 2010, I highly suggest that you convert the file to XLSX format so that no data will be lost when opening and editing the file with lower versions of Excel. Here is the XLSX version of the file:http://wikisend.com/download/558828/Week 16 boxes_repaired.xlsxNow, regarding the second file where you cannot delete some of the combo boxes, I tried deleting them with the steps that I gave you and I was able to delete them. I believe there is no problem with your Excel settings there since you were able to delete the other combo boxes. First, I was thinking if your workbook was protected or locked causing the combo boxes not to delete, but I believe the workbook is not protected since I was able to delete the controls (combo boxes).Here is what I did to delete the combo boxes. I provide screen shots to fully describe the process.First, you have indicated in the file that the combo boxes are not deletable, or cannot be deleted. I suggested before that you right-click on the combo box then click on CUT. Or alternatively, right click on the combo box, press ESC key to remove the context menu and leaving the combo box selected, then press the DEL key to delete the selected combo box.Now, the combo box is indeed deleted! The only problem is, it appears NOT being deleted because there are actually several combo boxes piled up in the row that you mentioned. So you though the right-click + CUT method did not work. But it works, you just need to do it several times because there are lots ob combo boxes piled up there. There reason why they piled up is because, you might have deleted a row containing the controls. When the rows are deleted the controls are shifted to left, right, up or down piling up the combo boxes.Here is my screen shot when I first tried to MOVE the combo boxes to see if there are still others in the row even after moving. To move the combo box, right click on the combo box and hold and then drag it, then release the mouse button. You shall see Copy Here or Move Here after releasing the mouse button. Click on Move Here. You will see then that after moving, there are still combo boxes there. These proves that the combo boxes were actually plenty but piled up on each other in the row.After moving, I figured out that the first problem row has 4 combo boxes that are piled on top of each other. Unfortunately, in the second problem row, there are very plenty of there. Here is my screen shot after moving more than 10 of them and still there are piled up combo boxes.Therefore, if you decide to delete them, you need to do it several times since there are actually several combo boxes overlapping or piled up on top of each other. To do this, right-click on the combo box then click on CUT and do this until all combo boxes are removed.Please remember to rate my service positively (3-5 stars/faces) once you have all the information you need. If you have any other questions, please ask me or reply to me – I’ll be happy to respond. Thank you!Best regards,Jess
Please remember to rate my service positively (3-5 stars/faces) once you have all the information you need. If you have any other questions, please ask me or reply to me – I’ll be happy to respond. Thank you!Best regards,Jess
As to the first question - the bloated file.
I guess I did not make myself clear enough, sorry about that.
The real problem file I was not able to send to you.
When I open it in Excel 2010 it takes for ever and after it is open there is not way of saving it.
I will try using a different computer when I can open it in Excel 2003 and strip out the data corporate will not let me send you.
I will let you know when I am able to post that file.
Regarding the send issue - combo boxes that do not delete, I am currently working my way through what you sent me, Thank you.
It is very possible that the stacking happened when I deleted the multiple sections at the bottom of the file in which case the combo boxes were probably not deleted by rather simply move up and stacked on top of one another. I think I have enough info on that now to fix it, if not I will add a reply when I send the other file to you.
Thanks again for your help
I have uploaded a copy of the file that I can not save using Excel 2010
I have also uploaded a copy of the Excel 2010 developer tab screen shot which is different than the one you sent me
I have been trying to delete the combo boxes but because of the shear number of them it is taking a lot of time
Please download the repaired file using the steps I just described above:
http://wikisend.com/download/415420/Prebill Week 18 Temp_rev2_repaired.xls
Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! If you have any other questions, please ask me or reply to me – I’ll be happy to respond. Thank you!Best regards,Jess
Thank you again for your assistance
As long as I was working in Excel 2003 there were not problems except that it was very slow. Appareltly the original file was created in Excel 97 and with all the many repeated "save as" creations. We are getting everything cleaned up and building a template to use instead of using multiple generations of "save as" files.
Thanks again and we can consider this issue closed.
Back to the combo box issue, should I open a new ticket and continue on with this one.
I discovered what is causing my deletion problem, just do not know how to fix it.
The problem is that the combo box it not attached to any specific cell in the spread sheet.
The result is that when you delete a series of rows containing combo boxes everything gets deleted EXCEPT for the combo boxes that simply move up to the closest undeleted row.
There is also a problem viewing the spread sheet.
If you hide a series of columns and some contain combo boxes, the combo boxes do NOT get hidden, but simply slide over to the first viewable column. When you unhide the columns the combo boxes revert to their correct position.
Is there any way to lock the combo boxes to a cell to avoid this problem?
Thank you very much for your assistance.
Excel 2010 is sure a big learning curve from Excel 2003
Because of you help and using the built in help functions, I was able to create a "Two way Lookup"
Now you know why there were so many combo boxes stacked on top of each other (I deleted about 800 rows that had lots of combo boxes in them.)