Skip to Content
0

Reference given in Workbook does not refresh always

Mar 20, 2017 at 08:52 AM

177

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Mar 20, 2017 at 10:22 AM
0

Hi,

check properties of your workbook: Flag refresh workbook when opening

Show 7 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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 ?

0

can share screenshot of your reference please?

0
Former Member

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.

0

Hi,

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

0
Former Member

Hi Koen,

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

Thanks

0

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

0
Former Member

Hi Koen,

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

Thanks for your help.

0