on 2007 Mar 15 6:03 PM
IS there a way to have a query resize automatically? We have noticed that for some usere it opens up and it sin't centered or taking up the whole excel area
MICK,
you could do that in two ways...
1. Use the query property , the user can initially format it and then the same format is kept on any change by way of refresh.
2. Use a macro to size the columns using sapbex.xla!SapBexOnRefresh() ( I think I have not got the caps right in the function specified !!!)
Arun
Hope it helps...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.