cancel
Showing results for 
Search instead for 
Did you mean: 

workbook Question

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

You mean for Query view!

former_member205352
Active Contributor
0 Kudos

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
0 Kudos

Can we have any VBA code for Query views!

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

save it as a view.

add local formula and save if you are in 7.0

Former Member
0 Kudos

Im on BW3.x! Plz suggest!

Former Member
0 Kudos

In 3.5 save it as a view.