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.
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.