Readrange password not working for xls file

Learn Academy Feedback
10

HI @Dave,

interesting: for me xlsx file works… What error do you get for both ?

I dont want to use the excel application scope because it gets stuck randomly when it opens the files I’m using because of the links in in. This behavior seems to be a known issue. See How to handle excel pop up when opening the excel files for the details.

Edit: Also, if the excel is in “open as read-only” mode, the excel application scope doesn’t save the changes and doesn’t fail. so we don’t know that it was not saved…
we have those 2 options set on the destination excel file for business reasons and can’t remove them.