Skip to Content
avatar image
Former Member

Error in ClearAllCacheTo Get error in BPC reports

May 31, 2017 at 03:11 PM | 61 Views

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)
SAP Business Planning and Consolidation, version for SAP NetWeaver
SAP Business Planning and Consolidation, version for the Microsoft platform
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Vadim Kalinin
    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
      May 31, 2017 at 04:40 PM

      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

  • avatar image
    Vadim Kalinin
    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