'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix MBRS Cannot Generate Sheets Error in Microsoft 365
Question details
The user is unable to generate sheets using the MBRS add-in and receives a System.InvalidCastException error.
- Product
- Microsoft 365 / MBRS Add-in
- Device & OS
- not provided
- Scenario
- Launching the Malaysia Business Reporting System (MBRS) add-in to generate spreadsheet reports within Microsoft 365.
- Observed behavior
- An error message appears stating that sheets cannot be generated, followed immediately by a System.InvalidCastException thrown by the MBRS add-in.
Ensure you have administrative privileges on your computer, as you will need to create specific local directories and copy system patch files to resolve this add-in exception.
Apply the MBRS Folder Patch Workaround
Manually create the missing directories required by the MBRS script and copy the patch files to bypass the exception error.
This error is typically triggered by the SSM XBRL Preparation Tool (MBRS add-in) missing necessary source folders in its directory structure, rather than an issue with Microsoft Excel itself.
Open File Explorer and navigate to your D: drive. Manually create the nested folder path exactly as follows: D:\SSM\svn\_new\SSM\_iFile\_Code\iFile\iFileCore. If your system primarily uses a C: drive for this tool, adjust accordingly based on your initial installation path.
Navigate to the default installation directory for the MBRS tool, typically found at C:\SSM XBRL Preparation Tool\Patch.
Select all the required patch folders within the Patch directory, right-click, and choose Copy (or press Ctrl+C).
Go back to the newly created iFileCore folder on your D: drive, right-click inside the folder, and select Paste (or press Ctrl+V).
Completely close Microsoft Excel. Relaunch the application, open your workbook, and try generating the MBRS sheets again to confirm the error is resolved.
Contact the MBRS Manufacturer for an Update
If the manual folder patch fails, the issue is rooted in the third-party add-in code and requires official support from the manufacturer.
Experience a Stable Spreadsheet Environment with WPS Office
If third-party add-ins and software conflicts are causing Microsoft 365 to throw exception errors, consider switching to WPS Office. It provides a highly compatible and lightweight environment for your daily spreadsheet tasks without the hassle of complex technical troubleshooting.
Frequently Asked Questions
What is the MBRS add-in in Microsoft Excel?
MBRS stands for the Malaysia Business Reporting System. It is an XBRL preparation tool provided by the Companies Commission of Malaysia (SSM) used as an add-in within Excel to generate specific business reports.
Why am I getting a System.InvalidCastException error?
This error occurs when a piece of software (like the MBRS add-in) attempts an invalid data type conversion in its background code. In this specific case, it happens due to missing directory folders and patch files required by the add-in to function.
Does this MBRS error mean my Excel installation is corrupted?
No, the error message clearly states that the exception is generated by the MBRS add-in, not Microsoft Excel. Reinstalling Excel typically will not fix this issue; instead, the add-in's missing files must be patched.
