Question
Capgemni
IN
Last activity: 16 Oct 2018 12:03 EDT
Getting an error as "Operation is not allowed while Microsoft Excel is in the 'Edit Mode'" while accessing data from excel sheet please help to resolve it
Hi Team,
getting "Operation is not allowed while Microsoft Excel is in the 'Edit Mode'." while getcell value or export data from excel sheet
***Updated by Moderator: Marissa to update categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
AU
Hi Balakrishna,
The screen print doesn't show any issues. Is your excel sheet or some of the columns are right protected?
Regards,
Basavaraj
Accenture Services PVT Ltd
IN
@harisankarm9655..... That is Z25 , not 225.
Plus I am facing the same issue where 3 out of 4 excel connectors work. I am getting the above error for the 4th one.
I am pointing all of the 4 connectors to the same excel sheet at the same location. This issue has popped up once a "Copy" was done from the sheet by Enabling the Edit option in MS Excel. Is there a way to revert to the previous excel configuration?
I have tried both Create and Open modes for the connector.
Pegasystems Inc.
IN
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.