Skip to Content
avatar image
Former Member

Error in ClearAllCacheTo Get error in BPC reports

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 31, 2017 at 04:06 PM

    check sheet name in your code before refresh.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • May 31, 2017 at 06:11 PM

    For Epm functions enable events has to be true!

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

    Add comment
    10|10000 characters needed characters exceeded