Forum Discussion
Solved
Excel script run with error since today (Range Delete)
I have a script that manipulates an excel table by deleting columns and adding new ones. The script that yesterday worked correctly today stops working and i get these errors: Range delete: You cann...
I guess that's this sample ExcelScript.DeleteShiftDirection enum - Office Scripts | Microsoft Learn
"delete" doesn't work in Excel Desktop. If you run exactly the same script in Excel for web it shall work.
SergeiBaklanthanks a lot, indeed on Excel web is working.
The strange thing is that until yesterday it worked for me also on Excel Desktop. I suppose an update was released for Excel Desktop that block these operations.
StefanMogyorosi , you are welcome.
Yes, that's quite seldom but some script functionality which works on Excel for web doesn't work in Excel Desktop. Not sure why so, the point is to check everything on web version first.
- I had the same thing happen. Exact same script that worked a few days ago does not work today in desktop Excel, but does seem to work in Excel online or running through Teams. This seems odd to me. why work one day and the next not in desktop?
Sorry, I have no idea why that happens.
