cancel
Showing results for 
Search instead for 
Did you mean: 

BEx - Column Width Adjustment

Former Member
0 Kudos

Hi BEx Gurus,

Do you know of a way to default the queries in Bex so that the column widths do not adjust with each navigation step?

If you bring up the context menu and choose Properties, you can manually choose "Do not adjust column width" but that setting is for the specific query per specific user. Is there a general setting somewhere to that the setting is applied to multiple queries for any user?

Help.sap.com didn't have a thorough explanation of this request. And I couldn't quite find a setting on transaction /rsrt nor Visual Basics Editor in the Excel Macros setting.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello,

Thanks for your responses - it has been quite insightful!

Hopefully this is the last question, but how do I go about and create a worksheet template that locks the size of the excel cells?

I can active SAP Protection (from Tools) but this only limits the user from changing the worksheet - ie, Format and Layout options from the BEx toolbar functions are not available. But once I perform any navigational steps, the column widths are again altered to fit the texts in each cell.

I understand that once I create this worksheet that locks the column cells, I can choose it as my default permanent template. Just a matter of formatting the template.

Any suggestions?

Rhonnie

Former Member
0 Kudos

Is there not a setting in BW somewhere? Rather than creating a workbook to cover this issue?

Just wondering..

Former Member
0 Kudos

Not to my knowledge

regards,

Hari

Former Member
0 Kudos

May be you can create a 'Workbook' for this case. So that that setting will become global for everyone..

regards,

hari

former_member188325
Active Contributor
0 Kudos

ya thats good option to use work book and make it as permanent template for all work books..

thnaks