cancel
Showing results for 
Search instead for 
Did you mean: 

Reference given in Workbook does not refresh always

Former Member
0 Kudos

Hello Experts,

In my current project, I am working on BI 7.4 SP 008. . The customer's requirement was to create a report in the format they send to their management for which I have created workbooks in BI wherein I have to create 2 tabs in workbook. First tab is the main tab where data from BEx Query is displayed and the selection criteria for the workbook is Fiscal Year Period and Company Code.

In the 2nd tab I have given the reference of the 1st tab and have done some formatting of colours & borders in the way they report to their management. The issue is when I run the workbook, In the Main tab (First tab) the data gets refreshed according to the Fiscal Period entered in the selection criteria, But in the 2nd tab where the reference has been given, They are not changing always. Sometimes the numbers get changed according to the first tab but sometimes they remain the same as of when executed last time. That means the data doesn't get refreshed in the refrerence tab properly.

It would be appreciable If anyone could help me in this uncertainty issue. Appreciate your help in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

kohesco
Active Contributor
0 Kudos

Hi,

check properties of your workbook: Flag refresh workbook when opening

Former Member
0 Kudos

Hi Koen,

I have checked the settings in Workbook as 'Refresh on Open'. So I don't think that is the issue. Because the workbook gets refreshed but the reference given in workbook doesn't.

Thanks for your help. Is there anything else you can provide me with ?

kohesco
Active Contributor
0 Kudos

can share screenshot of your reference please?

Former Member
0 Kudos

Sure. Please find attached screen shot of both the tabs fr your reference.workbook-1st-tab-main-tab.jpgworkbook-2nd-tab-reference-tab.jpg

Thanks for your help.

kohesco
Active Contributor
0 Kudos

Hi,

check if the formula in your excel is set as automatic refresh

Former Member
0 Kudos

Hi Koen,

Thanks for your reply. Can you please provide the steps how to check the formula for the Automatic Refresh ?

Thanks

kohesco
Active Contributor
0 Kudos

Excel --> File --> Options --> Formulas --> Workbook calculation = automatic

Former Member
0 Kudos

Hi Koen,

I checked the settings in excel and is set to Automatic refresh only.

Thanks for your help.