cancel
Showing results for 
Search instead for 
Did you mean: 

How do I resize a query when it displays

Former Member
0 Kudos
42

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184494
Active Contributor
0 Kudos

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...

Former Member
0 Kudos

thanks, I have awarded points.