I’m facing an issue while automating an Excel file. The goal of the automation is to refresh and filter pivot tables in an Excel file. When trying to type into the filter field I’m getting the following message:
Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “1/2/2023” has a wrong format;
► Excel is busy or you are currently editing a cell;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.
I’ve already checked the 4 possible reasons and none of them apply. I’ve also tried using modern and classic Excel activities.
Below is the field where I need to add the filter (previous date).
I’ve already tried:
- Modern and classic write cell activity;
- Type into activity;
- Filter pivot table (modern activity)
None of the above worked.
Any help is really welcome.
Thank you and a lovely 2023!