My workflow is using Call Web Service for copyAs Excel file.
Sheets/areas in this Excel document must be locked for specify person(autentification via domain).
For example in sheet1 only can be used by personA, but in sheet2 only personB can change something.
I set in Excel document locked sheets(by password).
In Nintex i have 3x Call Web Service(open session, copy document, close session).
How can i make Nintex/Excel when i have to use Excel with locked cells/sheets?
First Call Web Service cannot open session for Excel document with locked sheets.
Thank you a lot for help.
Hi Dawid Magdon,
In a web service you can use Workflow constant for credentials.
You can create the Workflow Constant on Farm level as well.
The account you specify for the Workflow Constant should have permissions on both sheets so that it can execute all actions.
I'm using my own Workflow Constant but still cannot open session with Excel document with locked sheets.
I have error, check image below.
Did you capture the whole error? The history only logs 255, thus you could e-mail it. If you already did, does it mention the protected sheets?
If you want to copy the Excel file, can you not just use copy to sharepoint?