Excel sheet Refresh button Run Time Error

[former_member307359]

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

[former_member212095]

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

[former_member307359]

@Shrikant Jadhav, Gaurav Tipnis

while refreshing through standard EMP Refresh button I'm getting and error.

[former_member212095]

Hi Vimal

Please check your network connection.There is a possibility that due to network connection failure you are facing this error.

Regards

Gaurav

[former_member307359]

Hi Gaurav Tipnis,

This is the error im getting while I'm refreshing through standard refresh button.

Regards

Vimal Raj

[Shrikant_Jadhav]

Hi Vimal,

I think this error is for related to server, it's not for only that template. Kindly confirm you are connected to server and able to refresh other report.

Shrikant

[former_member212095]

Hi Vimal

While refreshing the report there are chances that due to poor network connection you are facing this issue.

Kindly check your network connection and refresh the report again.

Regards

Gaurav

[former_member186498]

Hi Vimal,

please put ujo_read_exception_018 in the search for SAP notes you will found 11 notes about this error, you need to correct some instructions.

Regards

     Roberto

[former_member307359]

Hi Shrikant Jadhav,

Yes i can able to refresh other template sheets.

Regards

Vimal Raj

[Shrikant_Jadhav]

Hi Vimal Raj,

Pleae refer this note 1676767 and 1032461

Go through through the following link may be helpful

Shrikant

[bhagyesh_ravange]

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

[Shrikant_Jadhav]

Hi Vimal,

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

Shrikant