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
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.
Perhaps there is way to do this using Office Scripts as part of Power Automate?