Problems connecting to Excel sheet

Does anybody konw why a certain sheet from an Excel workbook might not open in JMP using the Database connection method. We found that certain sheets in an Excel book didn't open where others did. We shortened the name of the sheets and took out obscure characters from the name. It seemed to work then. Just wondering of anyone knows more about this so we can avoid in the future.

We have an Excel workbook with 3 sheets in it. 1 of them opened with no problem. 2 of them did not. I want to know why. As I say, we shortened the names of the sheets and got rid of characters like %,$ and they opened. I would like know what it was that stopped them from opening in the first place so that we can prevent these problems in future.

Unfortunately, I use datebase connection method open the Excel which has a sheet named "$120328--D--3-1" ,perhaps reinstalling your JMP will help you. You can copy the contents of Excel and open the new date table of JMP ,and then "edit---paste with colum names",if you can not use with JMP