Work Book not refreshing

[Former Member]

Dear Super user,

please help me with the below issue, I have workbook which has got only one BW query in it when I am refreshing I am getting below error message and not displaying any data. and I have got only one Nav Pane and Data provider as I should.

Kind Regards,

Shanmugam

[srikanth_rapur2]

Hi,

Can you confirm which version of sap GUI are you using

I mean Sap GUI 720/730/740?

Thanks

[former_member210321]

Hi,

Have you tried executing the Query which used by the workbook separately so as to check if the error exists in the Query.

Have you modified the query, then try to enter the query inside the workbook then save it so as to apply the changes on the workbook.

Regards,

[former_member198905]

Hi

Did you select the dimensions from available dimensions in navigation pane properties?

Did you checked the Refresh Workbook on open in Workbook setting?

Thanks

ISKhan

[Former Member]

Hi Imran

yes I have selected Dimensions from available Dimensions and I have refresh workbook on open ticked as well.

Kind Regards

[former_member198905]

It mean its a excel problem.

What GUI and Excel version you use? Use 32 bit version instead of 64 bit.

[Former Member]

user is using excel 2010

[former_member198905]

1) 32 bit version or 64 bit?? Use 32 bit version instead of 64 bit.

2) Goto Excel Options->Add Ins->at the bottom is a drop down box: select Manage Disabled Items-> And if your dimension is shows there, delete it and then check your workbook again.

[Former Member]

Hi Imran,

I don't know how to check Version 32 or  64

go to excel options- Add Ins - at the bottom is drop down box : I couldn't find the drop down box either.

Please guide me further.

Kind Regards

[former_member198905]

Hi

In Excel 2013

Goto File->Account->About Excel->Here you can find Version 32 or 64

Goto File->Options->Add Ins->following image show the drop down box appear there:

[Former Member]

thanks for detailed steps

we are using 32bit and my dimensions are not showed in disabled items.

[former_member198905]

Delete the old workbook and create a new one.

[Former Member]

user is doing that but trying to understand root cause thanks for your inputs...

[former_member198905]

You didn't mentioned SAP GUI version? and did you install SAP GUI patch?