I kept on getting error when i tried to reference the same excel sheet using the same name. What could be wrong? I have checked the scope. It is a demo on the academy program that i am tryi g to replicate. Building excel automation using modern activities.
Ensure proper closing:
If using Excel Application Scope, make sure each scope ends properly before a new one starts.
Use different resource names:
In Use Excel File, each time you open a file, give it a different resource name, like Excel1, Excel2, even if it’s the same file.
Reuse the Workbook variable:
If you already have an Excel file open, do not open it again — just use the existing reference.
Check for “Read Only” settings:
If the file is being opened multiple times, set “Read Only” to True if you don’t need to write into it every time.
1 Like
Hi @Martins_Micheal ,
- Make sure every Excel operation (Read, Write, etc.) is inside the same Use Excel File container OR
- If you have multiple containers, use the exact same resource name.
Please if you still face issue please share with us the workflow or screenshot from it to help you 
I wanted to copy a column from 2 different excel sheet to a particular output folder but after i used the folder in the first use excel file, I wouldn’t referance the output file with the same name anymore.
- List item After you save or modify your Output Excel File the first time.
- Start a new Use Excel File activity for the second operation and make sure for both:
1- You browse again to the file OR use the same file path variable (if you saved it)
2- Assign a new or the same resource name, but fresh Use Excel File instance.
Please try above and update us if there is an issue
1 Like
Possible duplicate
1 Like