Skip to Content

Excel sheet Refresh button Run Time Error

Hi Expert,

I have an excel input template with two sheet, 1st is for one time input sheet(Cost of Production)+(Button Save and Refresh), 2nd one is for (Budgeted Consumption)+(Button Refresh). While Press the 2nd sheet refresh button getting an error.


Vb Script

Dim EPMObj1 As New FPMXLClient.EPMAddInAutomation

Sub Refresh()

EPMObj1.RefreshActiveSheet

End Sub

Kindly help me to solve this.

Regards

Vimal Raj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 29, 2014 at 10:07 AM

    Hi Vimal

    1.Try refreshing the report using the standard EPM refresh button.If it succeeds, go to next point. 

    2. Did you try the Debug option for the VBA script?

    3. If there is no error in above point, pl check the database table space.

    Regards

    Gaurav T

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Vimal,

      Could you please tell me in what dimension you have 007 as member.

      Also tell me about /CPMB/KQD6KOE dimension. There is an issue with 007 member with Dimension /CPMB/KQD6KOE.

      Regards

      Bhagyesh Ravange

  • Dec 29, 2014 at 08:30 AM

    Hi Vimal,

    Try to refresh template by using standard refresh button and confirm that it is refreshing properly.

    Shrikant 

    Add comment
    10|10000 characters needed characters exceeded