on 08-12-2008 2:36 PM
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
save it as a view.
add local formula and save if you are in 7.0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.