Share via

Cannot get applyValuesFilter to work

Win, Stacy 10 Reputation points
2023-06-06T21:12:28.9466667+00:00

Working on an ExcelScript and I cannot get the applyValuesFilter method to work. I keep getting this error "Filter applyValuesFilter: You cannot perform the requested operation."

I created used the Record action and I created a custom script with the applyValuesFilter method. Both return the above error.

Is there something wrong with Excel or is there something wrong with my script.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,072 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,739 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michelle Ran 346 Reputation points Microsoft Employee
    2023-06-06T23:33:12.8466667+00:00

    Thanks for reporting this issue! I believe this has the same root cause as the issue we're currently investigating on this thread: https://learn.microsoft.com/en-us/answers/questions/1295289/broken-excel-script-please-help-me-troubleshoot

    In short, certain scripts are failing on recent builds of Excel for Windows. The Office Scripts team is working on a fix; in the meantime, you can try to run your script in the browser instead. We apologize for the inconvenience!

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.