Write range excel error (Protected View)?

[fairymemay (noona)]

I want to read and write excel but file file have protected view as below.

Please guide me about it.

[diega.iqbal.mardana]

You can try to setting your Ms. Excel application.

Goto File > Option.
Open Trust Center > Trust Center Setting.
Open File Block Setting > Uncheck all, like below:

Then click ok.

You can try to run your project now.

[fairymemay (noona)]

@diega.iqbal.mardana If I don’t want change setting.

Can you have any idea ?

[diega.iqbal.mardana]

If your operation is only read and write to excel file, you can try using this activity:

Else, you must setting your Ms. Excel application.

[THIRU_NANI (NaNi)]

Hi!

You can use the workbook activities instead of Excel activities…

If it is not works for you let me know!

Regards,
NaNi

[fairymemay (noona)]

@THIRU_NANI Now I use Excel Process Scope , It work

[THIRU_NANI (NaNi)]

Hi!

Yeah, if you’re using Modern design experience the Excel process scope will be available…

If your using Classic design experience Excel Application scope will be available…

But the workbook activities will avIlabe in Modern and Classic design experience.

Regards,
NaNi