Report builder refreshing error - excel auto protection workbook issue

baspol

New Member
Joined
Jul 25, 2014
Messages
1
Hello,

It seems my Adobe Report Builder v.5.0.4 doesn't refresh any reports anymore in Excel v.14. I see 2 errors, I think one due to the other:

1) If I hit the refresh all button in the Add-in tab or in the Request Manager all my tabs in the workbook jump to protected view.
2) If I refresh a list of reports in my workbook I get an error. In the request manager under Last Run it says Error ..

Ad 1)
The interesting part is that when I hit the refresh all button in the Add-in tab or in the Request Manager all my tabs in the workbook jump to protected view automaticly. Excel shows me a message that it can't update protected sheets so I logically click unprotect on every workbook (or under the file tab). Unfortunately Report Builder will now update 1 or maybe 2 reports. Since I run mutiple reports a manual update on every report defeats the purpose.

I also went to Trust Center and unchecked all Protected view options to no succes.

Ad 2)
So when the reports try to refresh and when I unprotect every workbook as soon as possible I get maybe 1 or 2 reports in. All other reports give an error under the column Last Updated part in Report Manager. This is due to the protected view issue in my opinion.

Does anyone has a solution for this? Any help is greatly appreciated!

Thanks,

Bas
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,215,221
Messages
6,123,699
Members
449,117
Latest member
Aaagu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top