Forum Discussion

Copper Contributor

Jun 01, 2023

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

excel

Office Scripts

SergeiBaklan
Jun 01, 2023
StefanMogyorosi

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.

SergeiBaklan

Diamond Contributor

Jun 01, 2023

StefanMogyorosi

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
Copper Contributor
Jun 02, 2023
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.
- SergeiBaklan
  Diamond Contributor
  Jun 02, 2023
  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.
  - Michael Waters
    Copper Contributor
    Jun 03, 2023
    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?