EVDRE - Unable to get the Text property of the Range class

[Former Member]

Hi,

An EVDRE is returning a message after expansion - "#ERR: 1004-Unable to get the Text property of the Range class"

Does anyone have any ideas as to possible causes of this error.

Regards,

Mark

[Jeffrey_Holdema]

We found from some previous customers who have reported the same error message, that

this issue occurs when there are formulas, named ranges, or cross sheet references

in ranges referenced by EVRNG functions or in the EVDRE function AppName

parameter.

Error message : "unable to get text property of the range class..."

The work around is either to reduce the number of such elements,

or starting the Refresh / Send actions from a command button where the

worksheets calculation is set to Manual before starting the action and restored to

Automatic at the end of the process:

Sub RefreshAndSend()                                                     
  Application.Calculation = xlCalculationManual                          
  Application.Run "MNU_ETOOLS_REFRESH"                                   
  Application.Run "MNU_ESUBMIT_REFRESH"                                  
  Application.Calculation = xlCalculationAutomatic                       
End Sub                                                                                
Sub Refresh()                                                            
  Application.Calculation = xlCalculationManual                          
  Application.Run "MNU_ETOOLS_REFRESH"                                   
  Application.Calculation = xlCalculationAutomatic                       
End Sub

[Jeffrey Holdeman|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/jeffrey+holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

[Former Member]

Hi!

I encountered the same problem (which also resulted in not being able to send values from formulas with the evdre sheet while typed numbers were sent to the database without problems).

Your solution above works just fine. I haveonly one remark.

If you run the refresh-makro before the sending-makro you are prompted if you want to delete the input data. As you probably do not want to delete the data you just want to send to the database, you will press "No". But then the refresh-makro aborts without doing anything. So you can just leave it out to make sure you do not delete data you just entered.

Best regards and many thanks!

Hartmut

[Former Member]

Hi Jeffrey,

Will you please advise if having that error there instead of EVDRE(OK) in the template will cause any issue?  I am not able to correct or remove that error out of EVDRE function.  Everything else in the sheet is populating fine. I have code embedded in the report for grouping and ungrouping rows based on two conditions so I added a command button with macro to refresh.  I am only concerned if this error could cause any issue.  I have not tested this template by sending data and only worked on retrieve so far.  I put the code

Application.Calculation = xlCalculationManual                         

  Application.Run "MNU_ETOOLS_REFRESH"                                  

  Application.Calculation = xlCalculationAutomatic                      under macro called refresh and assign macro to the command button but did not eliminate the error. Please advise, appreciate your help.

Thanks and Best Regards,

Di