Skip to Content
avatar image
Former Member

WorkBook Issue

Hi Everyone,

I have executed a Query and Saved it as a Workbook. Before Saving it a a Workbook , I changed the Layout of the Workkbook, by bringing the KeyFigures next to the relevant characteristics .Basicallly The keyfigures are displayed towards the Right End of the Query Result or in the BEx Report. So, I changed the layout int he Workbook in such a way that the first few columns conatin Characteristics adn then Keyfigures,then Characteristics.

Now when I execute the workbook Initiallly it displays the Same Layout with whatever Data I have loaded during the Last Execution of The Report.

But when I refresh the Query or when i change the Variable Values, It again goes back to the query Layout and My Layout is not Saved.

How do I save my Workbook Layout Permanently so that even if it is Refreshed or the Variable Values are changed, The Layout Remains the same?

Thanks and Regards,

Samir

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 08, 2010 at 08:11 AM

    After changing the workbook layout, you have to save it using Save the workbook as "exisitng workbook".

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      All these things are done. But still, The Workbook when Refreshed or The Variable Values are changed, It goes back to the query format.

      Any Procedure to follow when savung Workbooks so that Layout of the Workbook does not change. Basically the User wants KeyFigures in between the characteristics .So , I have done the changes adn saved it as a workbook.

      But once the user refreshes, it goes back to Query Format.

      Regards,

      Samir

  • avatar image
    Former Member
    Apr 14, 2010 at 03:05 AM

    Closed as No Solution as been arrived at.

    Add comment
    10|10000 characters needed characters exceeded