"Refresh Workbook on open" does not work

[marco_simon2]

Hi Experts,

using BEx Analyzer 7 SP 901 and 902 we experience the problem that most of our workbooks do not refresh after the opening.

The workbook-setting "Refresh Workbook on open" is set for the workbooks in question and they are BEx7 workbooks (not migrated from 3.5). The workbooks use the standard SAP-Default-Workbook.

If such a workbook is opened it "flickers" a few time (which seems not to be normal) and does not refresh.

The refresh-toggle-button from the BEx-Analyzer toolbar is deactivated (it was definetly activated before the workbook was saved and closed). When the refresh-toggle-button is clicked, the query is refreshed - but that's cerainly not the idea of the "Refresh Workbook on open" feature.

Did you experience similar?

Is there any reason you can imagine for this behaviour.

[hai_murali_here · Accepted solution]

Hi,

Are you saving the workbook in a server or in your local system, after setting "Refresh Workbook on Open".

If you save the workbook in server with "Refresh Workbook on Open" is set,and reopen then the workbook should get refreshed on opening it.

But if you save the workbook locally with "Refresh Workbook on Open" is set,and reopen then the workbook will not get refreshed on open.You have to manually refresh it.

Rgds,

Murali

[marco_simon2 · Accepted solution]

Hi Murali,

yes - you're right. I could verify your information and the above described behaviour is indeed only true for locally saved workbooks.

So: Is this behaviour a wanted one? Is it by design? Shouldn't a local workbook refresh on open as well if the option is enabled?

Is there any reason why this doesn't happen? Are there any notes about that topic, or some documentation? Or is it a bug?

[hai_murali_here · Accepted solution]

Dear Marco,

Yes, opening a workbook locally does not trigger an automatic refresh. But this is as it should be. I know that it is not well documented.

Rgds,

Murali

[marco_simon2 · Accepted solution]

>

> But this is as it should be.> 

I cannot image why this is a wanted behaviour.

Could you perhaps gimme some hint why this feature isn't possible or wanted for local workbooks?

I don't think that this does not work without any concrete reasons behind.

Do you have some additonal information about that?

[hai_murali_here · Accepted solution]

Hi Marco,

The option "Refresh Workbook on Open" under Workbook Settings will be applicable for workbook which is retreived from Server.This option is specific to that workbook which lies on the server.So when you open the local workbook,it is just an excel file with data which is no way related to backend server.So manual refresh needed to map the workbook with backend.

I guess the reason behind this known by the experts who design this application...:-)

Rgds,

Murali

[marco_simon2 · Accepted solution]

>

> I guess the reason behind this known by the experts who design this application...:-)

I hope so !!!

You're right - it is just an Excel file but one which contains BEx-Macros and therefor it is recognizeable by a running BEx-Analyzer. The analyzer can read the selection saved with the workbook, so it should be able to read the BEx-related workbook-settings as well (if they're saved with the workbook). If it finds the "refresh on open" flag, the analyzer could initate the refresh-process exactly as the user could do that manually.

Whatever - I'm sure there is some reason...