Office Settings & Configuration

How to Fix the New Spreadsheet Option Disabled in OneNote

Nimra Malik Oct 21, 2026 868 views

Question details

The user is unable to use the 'New Spreadsheet' option to insert an Excel workbook into OneNote.

How to Fix the New Spreadsheet Option Disabled in OneNote

Product: Microsoft OneNote
Device & OS: not provided
Scenario: Attempting to insert a new Excel spreadsheet directly into a OneNote notebook page.
Observed behavior: The 'New Spreadsheet' option under the 'Spreadsheet' menu is greyed out or completely disabled.

Before you start

Ensure that you have an active internet connection and that both Microsoft OneNote and Excel are closed before attempting to repair or update your Office installation.

Solution 1Recommended

Verify Excel Installation and Update Microsoft Office

The most common reason for this issue is a missing, corrupted, or outdated Microsoft Excel installation on your system.

OneNote relies on a local installation of Microsoft Excel to embed and create new spreadsheets. If Excel is missing or the Office suite is outdated, the integration will fail.

Check if Excel is installed

Open your Windows Start menu and search for 'Excel' to ensure the application is correctly installed and accessible on your computer.

Update Office apps

Open any Office application like Word or Excel, go to File > Account, click on 'Update Options', and select 'Update Now' to ensure you have the latest versions.

Restart OneNote

Close Microsoft OneNote completely, reopen it, navigate to the Insert tab, and check if the 'New Spreadsheet' option is now available under the Spreadsheet drop-down.

Verify Excel Installation and Update Microsoft Office

Restart Required: Always restart OneNote after updating Office applications to ensure the newly applied background integrations take effect.

Solution 2

Verify Notebook Permissions and Test OneNote for the Web

If you are working on a shared notebook, restricted permissions might disable the ability to insert new files like Excel spreadsheets.

Solution 3

Run an Online Repair for Microsoft Office

If Excel is installed but the integration with OneNote is broken, repairing the Office suite can fix damaged background components.

Free Microsoft Office alternative

Use WPS Office as a Seamless and Free Alternative

If Microsoft Office components like OneNote and Excel are frequently causing integration issues or require complex repairs, consider switching to WPS Office. It provides a lightweight, highly compatible suite for all your document, spreadsheet, and presentation needs without the heavy resource usage or syncing errors.

1. Download WPS Office: Visit the official WPS website and download the free installation package.
2. Install the software: Run the installer and follow the quick setup wizard to install the suite on your device.
3. Open your spreadsheets seamlessly: Launch WPS Spreadsheets and open any existing .xlsx or .xls files directly.

Highly compatible with Microsoft Excel (.xlsx) and Word formatsLightweight installation that avoids severe system and background service conflictsFree to use with a familiar, tabbed user interfaceBuilt-in robust tools for seamless document and spreadsheet integration

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Spreadsheet option greyed out in OneNote?

This typically happens if Microsoft Excel is not installed on your computer, if your Office apps are outdated, or if you only have read-only permissions for the current notebook.

Can I insert an Excel spreadsheet into OneNote without having Excel installed?

No, the desktop version of OneNote requires a local installation of Microsoft Excel to embed and create new Excel spreadsheets directly within a page.

Does repairing Office delete my OneNote notebooks?

No, running an Online Repair or Quick Repair from the Windows Control Panel only fixes the application files. Your notebook data, which is saved locally or on OneDrive, remains safe and untouched.

How do I check if my OneNote has editing permissions?

Right-click the notebook name in OneNote and check its properties, or try typing standard text on the page. If the notebook shows 'Read-Only' at the top of the window, you lack editing permissions.

Office App Problems