Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How do you copy rows from worksheet that's protected in Excel file A into a non-protected table in Excel file B?

I'm trying to take data from a protected excel file I get once a week, but I'm unable convert it to a table and 'add a row' in the excel file B. 


Whats the best approach to get data from the protected worksheet since 'create table' is being blocked from the protection?


manually this is what I would do....

1.) select the range

2.) copy

3.) create new worksheet in excel A

4.) paste into a new worksheet

5.) turn what was just pasted into a table


getting the data into excel B I think I have down for the automation part, just need help on getting around the protected sheet part

Dual Super User
Dual Super User

You can't use Power Automate to process protected Excel files.  You could try building a UI Flow to scrap the information off the screen while you are in Excel and send it to Flow.  But that's the only real workaround at this point.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Advocate I
Advocate I

Perhaps there is way to do this using Office Scripts as part of Power Automate?

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,682)