Hi,
I have an excel I need to update data to sheet3, Some times it is updating properly, but sometimes no data is updating. So when Im checking the excel Im getting this error message in the excel in all the sheets. If Im choosing Discard My changes option, What ever things I removed it is not removing.
Can anyone please suggest
1.Why data is not updating in the sheet every time .
2.How I can remove the error message at the top of the excel sheet.
I think the excel file is using by another application. Kill the process at starting of the program then it will execute correctly. If it will not work.
The excel is encrypted with password then remove the password.
Regards,
Is that a file from one drive/shared erive?
Then may be the file is opened by another user at the same time
One thing you can tey is to copy the file to local before updating and mcoe it back to network location once updates are completed
Also its advised not to keep the file open by other users when bot is ipdating or run ing
Cheers
Ya I already provided.
If the file is encrypted make sure to remove the password.
Give the password in the “Password” field in the Use excel file activity properties.
Try this and let me know if any queries.