Skip to Content
0

Error in ClearAllCacheTo Get error in BPC reports

May 31, 2017 at 03:11 PM

54

avatar image

Hi Everyone,

I have one work book and have below code to refresh for all the sheets when sheet is active.

When I switch from EPMFormattingSheet to any sheets then i am getting below error Please see below SS.

-------------------------------------------

Private Sub Worksheet_Activate()

Application.EnableEvents = False

Dim epm As New FPMXLClient.EPMAddInAutomation

epm.RefreshActiveSheet

Application.EnableEvents = True

End Sub

-----------------------------------------

Can you please help me is there anything problem in my code?

Note: I cleared cache but i am still getting same error and,works fine if i dont have above code for all sheets.

Thanks,

Vishu

capture1.png (16.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin May 31, 2017 at 04:06 PM
0

check sheet name in your code before refresh.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi vadim,

As you suggested i tried with below code but i am still getting same error.

Private Sub Worksheet_Activate()

If ActiveSheet.Name Like "EOP CO by Scenario" Then

Dim EPM As New FPMXLClient.EPMAddInAutomation

EPM.RefreshActiveSheet

End If

End Sub

0
Vadim Kalinin May 31, 2017 at 06:11 PM
0

For Epm functions enable events has to be true!

And the idea to refresh report on activate worksheet is not good in general.

Share
10 |10000 characters needed characters left characters exceeded