$$Excel-Macros$$ Re: Clean - clear pivot cache Excel 2003

2009-11-12 Thread MKamal
hi arnsto , Well well well! Hope you're familiar with vba ... I've got this issue and I've solved it this way enjoy it : Public Function Report0() As Integer Report0 = 1 On Error GoTo errorhandler Dim db As String Dim sql As String Dim pt as PivotTable db = "The database full p

$$Excel-Macros$$ Re: PLEASE SOLVE THE PROBLEM IN FILE ATTACHED

2009-11-12 Thread MKamal
This will help you! Enjoy it! You didn't supply info about session Sub Unpivot() Dim row As Long Dim col As Long 'Where to put the unpivoted array ' Should be in another sheet but you've put it on the same ..?!. Dim row_dest As Long row_dest = 10 'To simplify the algo Dim PROGRAM, ROLLNO, C

$$Excel-Macros$$ Re: Clean - clear pivot cache Excel 2003

2009-11-13 Thread MKamal
Hello again! This VBA code create 4 pivot table based on the same data cache; This is exactly what you have asked ! >Want: >a) vba routine to ensure that all pivots are based on the same pivot >cache >b) select one "mother pivot" cashe to be used by all pivots table Regards --

$$Excel-Macros$$ Re: Problem.Pls help

2009-11-15 Thread MKamal
There is no explanation in your worksheet! -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.

$$Excel-Macros$$ Re: PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file

2009-11-15 Thread MKamal
Hello, I think i did some effort to solve your problem take a look at this post : http://groups.google.com/group/excel-macros/browse_thread/thread/29083fc9f3da2cdc Hope this helps you -- -- Some important links for

$$Excel-Macros$$ Re: please solve my problem in attached file

2009-11-16 Thread MKamal
Dear Excel User, You have submitted this issue in several post. It's not a good practice Some users have already responded to your request. I think that you should maintain one post for your issue so you can capitalize the suggested solutions. Best regards On 14 nov, 09:33, Jitender wrot