Workbook Issue

[Former Member]

Hi Experts,

I have created a workbook based on query. I will explain the steps how i created workbook.

I opened Q1 and from there i started creating workbook selected properties tab and check the refresh workbook option and column width do not adjust column width. and deleted the query results and edit - goto option specified a3 cell and saved it as new workbook.

Then i tried to insert the standard template for newly saved workbook that has been applied to all the queries except workbook.

How can i remove the workbook template that was assigned to queries.

Regards

Prasad

[Former Member · Accepted solution]

Inorder to refresh the workbook with the new changes in the query, just rtlcik on th eproperties and edit. then query designer will get opened, then click on tick. then the template you saved in the workbook will get changed

[Former Member · Accepted solution]

Hi Mathew,

Could you plz explain a little bit more on this.

Which option i have to tick.

Regards

Prasad

[Former Member]

in the query properties in BEx analyzer you can change the option. is it version 3.5?

[Former Member]

Hi,

Yes it is BW 3.5 version.

Regards

Prasad

[Former Member]

in BEx analyzer layout I think u can chage the setting "do not use default template"