MapInfo Pro error: The Micorosoft Access database engine could not find the object

Products affected: MapInfo Pro™


Opening an Excel spreadsheet in MapInfo Professional 11 with a worksheet name that has a space or special character in the name of the Excel worksheet will cause the following error:
Microsoft Access Database Engine: The Microsoft Access database engine could not find the object 'Sheet1$'_xlnm._FilterDatabas'.  Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$'_xlnm._filterDatabas' is not a local object, check your network connection or contact the server administrator.
User-added image


An Excel worksheet name with a space or special characters such as %, #, @, etc..will cause the error.
User-added image


UPDATED: December 2, 2019
This bug has been fixed in MapInfo Pro v12.0 and higher.

To fix the problem for versions prior to v12.0, open each spreadsheet that is not working properly in Excel.
Remove spaces or special characters in the names of any worksheet that have them.
Example: change the worksheet with a space to have none.  Such as, “sheet 1” to “sheet1”.
User-added image
Then edit the related MapInfo.Tab file in Notepad so that the sheet name space is deleted in the related .tab as well.

- In windows explorer, find the .tab file that has the same name as the spreadsheet. 
- Right-click on the .tab file and choose “Open With.. ”   Select Notepad to open the .tab file. 
-Edit the reference to the “sheet name” that was corrected in Excel and remove the spaces here.
In this example, the space is outlined in the screenshot with Red ().
Once the space is removed, save the changes using file>save.
User-added image
Repeat this process for any .Tab/Excel files that are not working or generate the error.  Once they are corrected, all workspaces should open without errors.