Skip to Content
avatar image
Former Member

SAP PCO Excel Read Only Mode

Hello Experts,

I am in a scenario to read a excel file from shared location. I have created a OLE DB connector in PCo. Now I come across 2 scenarios:

  1. Password protected file: If the file is password protected, I gave the password of file in Connection tab in specified username and password section. Still Test connection option throws me a error.
  2. If file is already opened by another user by connection fails even when I access it in Read mode. It throws error as "it is opened exclusively by another user or you do not have permissions to view or write its data". In this scenario, can we force file to open in Read Only mode just as I would do when I open it manually?
  3. If I remove the password and close the file, then data is properly browsed without any issue.

Please provide your inputs.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers