License & Subscription Issues

Fix Visio Data Visualizer Missing & License Issues in Excel 2016

Steve KSteve K Nov 4, 2026 868 views

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.

Visio Data Visualizer License Requirements and Troubleshooting in Excel 2016
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 you start

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.

Solution 1Recommended

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.

1
Open Excel 2016

Launch your Microsoft Excel 2016 application and open any blank workbook.

2
Check sign-in status

Look at the upper-right corner of the Excel window. Check if your name or email address is displayed.

3
Sign in with the correct account

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.

4
Restart Excel

Close Microsoft Excel entirely and reopen it. Navigate to the 'Insert' tab to check if the Visio Data Visualizer add-in is now available.

Verify Microsoft Account and License Status
License Requirements: While basic viewing capabilities are broad, creating and editing diagrams with the Data Visualizer often requires a specific Microsoft 365 work or school account, or a standalone Visio Plan 1/Plan 2 subscription.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download and install the free version of WPS Office from the official website.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and open your existing data file or create a new one.
  3. 3. Insert a Flowchart: Navigate to the 'Insert' tab and select the 'Flowchart' or 'Shapes' tool to start visualizing your data instantly.
Free built-in flowchart and diagram makerFully compatible with Microsoft Excel (.xlsx) formatsLightweight installation with no complex add-in requirementsFamiliar user interface for quick adoption
QA img-9

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.