Edit a shared excel workbook

Help
1

Hi all,

I want to edit a shared excel workbook. But when i open the file via excel application scope with the edit password as property, it seems to open standard in read-only.

Is there an easy way to open the file with the edit right?

Thanks!

2

Do you see any “enable edit” option ? If yes, can you click that & see what happens ?

3

I don’t. It opens really nicely, but immediately in read-only. I never receive any pop-up or yellow bar

4

Another reason could different password to read and edit. Can you check that ?

5

Could it be that your user account doesn’t have edit permissions in that file even though you have used correct password?

6

If I replicate the process manually, this is the 1st pop-up that appears:

image

After filling in the password and clicking OK, i get this pop-up

image
image695×112 6.81 KB

It seems that’s where the robot selects ‘Yes’ by default

7

Or is it clicking the “Read Only” button on the password box instead of “OK”?

8

Could be. But I can’t see either one of those pop-ups, it just opens straightaway as read-only :roll_eyes:

9

Perhaps using Start Application may provide more luck than Excel application?