workbook Question

[Former Member]

Hi,

How do I save the manual calculations ina workbook ! I mean how do I add a column in the workbook and do some calculations based on the Query data ! When I save and reopen it, my manual stuff should be in there!

[Former Member · Accepted solution]

As long as you don't insert the column in the middle of the results area and then refresh the workbook then it should work fine. If your report return spans columns A through to G then insert your manual formula or whatever in column H.

Save the workbook and your manual calculations will be unnaffected.

[Former Member · Accepted solution]

Can we do the same at Query view (Global view) level instead of workbook!

Edited by: rahul k on Aug 12, 2008 5:16 PM

[former_member205352 · Accepted solution]

Hey you can write a VB macro for your calculation and reference which ever cells you need for calculation in the macro.

Hope this helps.

[Former Member · Accepted solution]

You mean for Query view!

[former_member205352 · Accepted solution]

No in the workbook in VB editor of excel.

You can write under SAPBexOnrefresh().

To be exact.

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

End Sub

Edited by: Praveen G on Aug 12, 2008 11:44 AM

[Former Member · Accepted solution]

Can we have any VBA code for Query views!

[Former Member · Accepted solution]

Hi,

Go to macros in workbbok->Microsoft excel options->This workbook. In the right side select workbook and newcalculate(select the right one in drop down box).

Write code

Ex.

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

Set wb = Workbook

Set ws = Worksheet

Dim wb As Workbooks

Dim ws As Worksheets

Here use calculations depending on your requirement.

End Sub

Hope it will be useful.

Thanks,

Ashok

[Former Member]

save it as a view.

add local formula and save if you are in 7.0

[Former Member]

Im on BW3.x! Plz suggest!

[Former Member]

In 3.5 save it as a view.