Enable editing

[yogitagaikwad2206]

Hi, I have to read excel but excel need to enable editing. can anyone tell me how i enable editing in excel using UiPath

[AJ_Ask]

When you use “Excel Application Scope” activity. Or Excel Process Scope > Use excel File, It will work without problems.

[yogitagaikwad2206]

Again this kind of problen is come

[aquesada (Andres Quesada)]

Hi @yogitagaikwad2206

That error is not because of the enable editing, there is a problem with the software that allows UiPath to communicate with excel. Go to the home tab of UiPath studio and under tools there should be a “Repair tool for Microsoft Office Interop” as it says in the message, utilize that tool to try to repair the connectivity.

[AJ_Ask]

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen - Help / Activities - UiPath Community Forum

Try with this one:

[yogitagaikwad2206]

but after manually enable editing this file is read in UiPath

[Mohan_Reddy]

@yogitagaikwad2206

You can Turn Off Enable Editing by following the method.

1. Open the Excel
2. Click on the ‘File’ tab in the top left corner of the window.
3. Select ‘Options’ from the drop-down menu.
4. Go to the ‘Trust Center’ tab.
5. Find the ‘Trust Center Settings’ and click it.
6. Choose ‘Protected View’ from the left-hand side.
7. Uncheck all the boxes under Protected View settings.
8. Finally, click ‘OK’ to save the changes.