How to edit excel file in sharepoint location.
Using excel application scope it gives error-illegal path.
Is the path which you specified is correct?
Do you have any *#& etc character like this in the path
As I guess, it is a sharepoint path, Excel application scope won’t recognize the path as it will look for the internal drives to get the file. So try downloading it and then update the required, then upload it back to sharepoint
I removed unnecessary part ,after that it give error that url format is not correct
We can use it …but sheet is going to be updated by multiple members at a time so if i download and upload it again it cause issue
Path is correct