'%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)
How to Fix Data Streamer Certificate Error in Excel 2013
Question details
The user needs to resolve a System.Security.SecurityException that prevents the Data Streamer add-in from installing or functioning.
- Product
- Microsoft Excel 2013
- Device & OS
- not provided
- Scenario
- Attempting to install or enable the Data Streamer add-in for real-time data streaming in Excel 2013.
- Observed behavior
- Excel blocks the Data Streamer installation and displays a certificate error because the deployment manifest or its certificate location is not trusted.
Ensure you have administrative privileges on your Windows account, as modifying the Trusted Publishers certificate store requires elevated permissions.
Verify Add-in Status and Subscription Compatibility
Check if the Data Streamer add-in is already installed but disabled, and confirm your Excel version supports it.
Data Streamer is generally designed for Microsoft 365 subscribers. Standalone versions like Excel 2013 may lack native support, which frequently triggers installation or compatibility errors.
Launch Excel 2013, click the 'File' tab in the top-left corner of the ribbon, and select 'Options' at the bottom of the left-hand menu.
In the Excel Options dialog box, click on 'Add-ins' on the left sidebar to view all active, inactive, and disabled add-ins.
Look for Data Streamer in the 'Inactive Application Add-ins' or 'Disabled Application Add-ins' list. If it is disabled, select 'COM Add-ins' from the Manage dropdown at the bottom and click 'Go', then check the box next to Data Streamer to enable it.
If the add-in is completely missing or throws an error upon enabling, check your Office account settings (File > Account) to confirm your licensing. If you are not a Microsoft 365 subscriber, Data Streamer may not be supported.
Import the Publisher Certificate to Trusted Publishers
Manually trust the certificate used to sign the deployment manifest to resolve the SecurityException.
Try WPS Office for a Hassle-Free Spreadsheet Experience
If your legacy version of Excel does not support the modern add-ins you need, or if you are tired of dealing with subscription limits and complex certificate errors, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative to Microsoft Office.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up the software.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and instantly open your existing Excel files to continue working without compatibility interruptions.
Frequently Asked Questions
Why does Data Streamer say my certificate is not trusted?
Windows and Excel utilize a strict security model to prevent malicious code from executing. If the digital signature attached to the Data Streamer add-in's deployment manifest does not correspond to a certificate in your computer's 'Trusted Publishers' store, Excel throws a System.Security.SecurityException and blocks the installation.
Can I use the Data Streamer add-in for free in Excel 2013?
Generally, no. The Data Streamer add-in is a feature primarily developed and maintained for Microsoft 365 subscribers. Standalone legacy versions like Excel 2013 often lack the required backend support, which is a common reason installations fail.
How do I remove a certificate from Trusted Publishers if I made a mistake?
Open your Windows Start menu, type 'certmgr.msc', and press Enter. In the Certificate Manager, expand the 'Trusted Publishers' folder on the left, click on 'Certificates', find the specific publisher certificate you want to remove on the right pane, right-click it, and select 'Delete'.
