Fix Visio Data Visualizer Missing & License Issues in Excel 2016
Question details
The user wants to know if a separate Visio license is required to use the Data Visualizer add-in in Excel 2016, and how to fix issues where the feature is unavailable.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- Attempting to use the Visio Data Visualizer add-in in Excel 2016 to automatically generate flowcharts and organizational charts from data.
- Observed behavior
- The Data Visualizer feature or add-in is missing, unavailable, or fails to load despite the user having Excel 2016 installed.
Before troubleshooting, ensure you have an active internet connection to verify your license online and save any open Excel workbooks to prevent data loss during a potential Office repair.
Verify Microsoft Account and License Status
Ensure that Excel 2016 is signed in with the correct Microsoft account tied to your Office or Visio license, as the add-in checks this credential to function.
The Visio Data Visualizer add-in relies heavily on your account's subscription status. If you are signed out or using a secondary account that lacks the proper license, the add-in will be restricted or completely hidden.
Launch your Microsoft Excel 2016 application and open any blank workbook.
Look at the upper-right corner of the Excel window. Check if your name or email address is displayed.
If you are signed out, or if the wrong account is active, click 'Sign In' or 'Switch Account' and enter the credentials associated with your Office or Visio license.
Close Microsoft Excel entirely and reopen it. Navigate to the 'Insert' tab to check if the Visio Data Visualizer add-in is now available.

Repair the Microsoft Office Installation
If your license is correct but the add-in still fails to load or appears missing, repairing Office can fix corrupted installation files and broken add-in registries.
Create Flowcharts and Diagrams Easily with WPS Office
Struggling with Visio licenses and missing Excel add-ins? WPS Office offers a free, lightweight, and highly compatible alternative. With powerful built-in drawing and flowchart tools, you can visualize your data effortlessly without dealing with complex subscription plans or add-in troubleshooting.
- 1. Download WPS Office: Download and install the free version of WPS Office from the official website.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and open your existing data file or create a new one.
- 3. Insert a Flowchart: Navigate to the 'Insert' tab and select the 'Flowchart' or 'Shapes' tool to start visualizing your data instantly.

Frequently Asked Questions
Do I actually need a Visio plan to use Data Visualizer in Excel?
Basic Data Visualizer capabilities are available to Microsoft 365 subscribers for creating basic flowcharts and org charts. However, advanced editing, custom data mapping, and using the tool in older standalone versions like Excel 2016 typically require a Visio Plan 1 or Plan 2 license.
Why is the Online Repair option missing in my Windows Settings?
Depending on how Office was installed (e.g., via MSI installer rather than Click-to-Run), you might only see a standard 'Repair' option. Run the available repair option. If the issue persists, you may need to check for Office updates manually or reinstall the application.
Can I use the Visio Data Visualizer add-in on a Mac?
The Data Visualizer add-in is available in Excel for Mac for Microsoft 365 subscribers. However, older standalone versions like Excel 2016 for Mac may not fully support the add-in architecture required for it to run properly.




