Query View Workbook

You formatted a query view ( By changing Fonts/column width etc ) and saved as workbook in your favorites in the Browser.

When you execute the workbook thru the browser you get the format that has been saved. However, you loose the format when you click the Refresh Button.

How to set permanent settings so that formatting remains same as has been designed in the workbook?

You can do this :-

In Excel using BW, you have what I categorize as 2 different types of cells.

You have "Excel" Cells and "BW" Cells. You can determine which you are in by selecting a cell and right mouse clicking. If you get the BW options (Drilldown, Swap, Insert.....) then you are in a BW Cell. If you get the standard (Cut, Copy, Paste) you are in the Excel Cells.

If you are formatting an Excel Cell, Format using the option from the Excel Menu. If it is a BW Cell, Format using the option from the BW Toolbar (5th button from right).

When you refresh you will retain your settings.

Also, as a hint, you don't have to select all of your BW cells when formatting. Select a characteristic and format using the BW toolbar and all characteristics will format. Same goes for key figures, Free characteristics etc.

BW uses the "BW Style Tool"to format. For more detail and customization follow the below steps:

1. Download OSS Note #300570.

2. On your machine
Find / Execute SAPBEXS.XLA -> Click Enable Macros.