VBA & Macro Problems

Fix Excel Office Scripts Slicer selectItems Not Implemented Error

WPS Content Manager Sep 25, 2026 869 views

Question details

The user needs to resolve an issue where an Excel Office Script fails when attempting to select date values using slicer.selectItems().

How to Fix Excel Office Scripts Slicer selectItems Operation Not Implemented Error

Product: Microsoft Excel
Device & OS: not provided
Scenario: Automating slicer selections for date values using TypeScript in Excel Office Scripts.
Observed behavior: The script execution fails and returns an 'Operation Not Implemented' error, despite verifying the slicer name, date array, and correct date formats.

Before you start

Before proceeding, ensure you have an active internet connection, as Office Scripts execute in the cloud. Double-check that your date array strings perfectly match the slicer item keys in your workbook.

Solution 1Recommended

Escalate the Issue to the Office Development Community

Since the 'Not Implemented' error often points to an underlying API limitation or bug within the Office Scripts backend, seeking guidance from the official developer community is the most direct path to a resolution.

Office Scripts is an evolving feature, and certain methods or overloads (like handling specific date slicer hierarchies) may not be fully implemented in the current API version. Reporting it helps Microsoft engineers identify and patch the missing functionality.

Gather your script details

Copy your complete TypeScript code, note your Excel platform (Web or Desktop), Excel version, and copy the exact 'Not Implemented' error message.

Navigate to the support community

Go to the official Microsoft Tech Community for Office Development or open Stack Overflow and search for the 'office-scripts' tag.

Submit a detailed report

Create a new post including your script, the specific slicer type (e.g., Timeline or standard Slicer), and the verified date array format to request a targeted workaround from API developers.

Escalate the Issue to the Office Development Community

Include formatting details: Always specify how your dates are formatted (e.g., MM/DD/YYYY) in the forum post, as date serialization is a common cause of API rejections.

Solution 2

Use a VBA Macro Workaround

If Office Scripts cannot perform the action due to missing API features, you can fall back on traditional VBA macros to automate slicer selections on desktop versions of Excel.

Free Microsoft Office alternative

Try WPS Office for Reliable Spreadsheet Automation

Dealing with unimplemented cloud API errors in Microsoft Excel can halt your productivity. WPS Office offers a powerful, lightweight alternative with comprehensive local VBA macro support, allowing you to automate advanced workbook tasks without relying on incomplete cloud scripts.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing Excel workbook.
3. Run macros locally: Enable macros and use WPS Office's built-in VBA editor to automate your slicers and data processing reliably.

Completely free and lightweight office suiteSeamless format compatibility with Microsoft Excel (.xlsx, .xlsm, .xls)Robust local VBA macro execution for complex automation tasksFamiliar spreadsheet interface requires zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does the slicer.selectItems() operation return 'Not Implemented'?

This error occurs when the Office Scripts TypeScript API encounters a data type or object hierarchy—such as grouped date timeline slicers—that the backend services do not yet fully support.

Can I automate Excel slicers on the web without Office Scripts?

Office Scripts are the primary way to automate Excel on the web. However, if a feature is unsupported, you may need to open the file in the desktop application and use VBA, or filter the dataset directly instead of using slicers.

Are Office Scripts the same thing as VBA macros?

No. Office Scripts are written in TypeScript and execute in the cloud, designed primarily for Excel on the web. VBA (Visual Basic for Applications) is a traditional, locally executed scripting language used in desktop versions of Microsoft Excel and WPS Office.

Excel & Data Problems