Problem with SAPBEXpauseOff

[Former Member]

Hi all,

I've a problem with automatic refresh on Bex.

I stop automatic refresh on BEX (on a workbook with 3 queries). I set filter values on ONE query and when I set again "automatic refresh", ALL QUERIES of a workbook are refreshed!

Also with VBA the behaviour is the same.

PS:I've patched GUI

one week ago....(SAP GUI 6.40 patch 21 and BEX 3.50 Patch 10).

[Former Member]

Hi Samuele,

This is not a "bug". The problem you describe happens only if the other queries have been saved as "detracted" (i.e., Tools >> All queries in workbook >> Delete results).

So, if you save your workbooks with results this will not happen.

I have also noticed that the problem is bigger than you describe. Not only do ALL (detracted) queries in the active workbook refresh; but, so do ALL (detracted) queries in every workbook that you have open in that Excel session. This can really irritate users!

One trick I have found ... if you go to the (very) hidden worksheet named "SAPBEXqueries", and in column E, change every "FALSE" to "TRUE", this will overcome the problem. This, obviously, is not an option for most users who are setting the Pause On and Off manually. But, as long as you are in VBA, this is simple to do.

If you want more details, post again.

- Pete

[Former Member]

Thank you very much,

you are a very Bex/VBA guru!

I try to post you another doubt.

When I insert my VBA code on workbook, memory occupation increase significantly (about 50-60 MB).

Is there any trick for release memory directly by vba code?

[Former Member]

Hi Samuele,

Thank-you for the kind words.

Not sure I understand the memory occupation question.

What are you seeing that tells you memory is being used? File size on disk? Task Manager CPU usage? Something else?

[Former Member]

Hi Peter,

50/60 MB are referred to Task Manager CPU usage.

[Former Member]

Very interesting. I do not notice this, even with a very large file I use to store interesting code examples (it has over 40 code Modules packed with code). But, there are many things that can affect Excel memory usage, and no way that I know of to recover it without closing Excel.

You might try looking at:

http://www.decisionmodels.com/memlimitsd.htm

http://www.mvps.org/dmcritchie/excel/slowresp.htm

http://www4.ableowl.com/ableowl/pdf/Indepth_Excel/Mag118_sample.pdf#search=%22excel%20memory%20usage...

- Pete

[Former Member]

Thank you very much.