Search results

There is an option in Pivot table "Refresh All" Pivot table when Opening File. Go to Pivot table Option > Click on this Option > save and close this file > re-open file. Try to do this hope it will work. Regards Istiyak

Thanks for Reply. I am ok with that if brand2 is not available. But pivot table should only display Actaul responses not errors. Please suggest. Regards Istiyak

anyone if working on this Please Update..

Namaste all, Have uploaded sample file so u can easily check what i desire. Unable to explain that in word. Hope you all can understand. Regards Istiyak

Hi, Pfa as requested. Regards Istiyak

@Xiq I have tried the same.

Amazing.... Thanks for Step By Step Istructions... Thanking for promp response. Regards Istiyak

Got What i needed. Still one confusion. Why two calculated fields are there? I Have to do the same by my self but it is not happening.? Regards Istiyak

Hi Team, I have one queary. Unable to creat Calculated Field in PVT which content Contribution of Each Category. Product Figures devided by TTL Grand Figures. Attaching File for the same. Regards Istiyak

sry NaraynK for become late.? Very much congo for acheiving a gr8 milestone. Be always sharing with us.@@ Regards Istiyak p.s. Always getting some fabulous answers 4m u.

Hi freinds, i have large data approx 50k rows. In last column i have a amount. I want some specification I.e. 1.5k-2k and so many others as i want this with the help of formula. I have used nested if and got sucess but as u know we are able to enter only 7 criteria. Is there any way so...

Still Facing Issue. Regards Istiyak

Agreed with all, Hats up to all, Regards Istiyak

Hi sir Solution is not provided.

i have uploaded a file on my website. www.istiyakshaikh.hpage.com > Downloads > Calendar.xls Kindly add the code in the file, so that calendar can popup with current date. Control : Calendar Control 11.00 Format : Excel 2003 Any query plz let me know. Regards Istiyak

Hey Hui.. Thnx for your great techniq....? I have used it working great. Bt still is it possible if more than one hyperlink available in same sheet. many thanks Regards Istiyak

Today i m working with macro and i acknowledged that i need to assign a macro to the hyperlink. After so many research i m zero...... Plz help me. Waiting. Regards Istiyak

Hi Dudeski, i have created one file as per your requirement. Kindly check http://istiyakshaikh.hpage.com > Dowloads > For_Solution_dudeski.xls Any query plz let me know. Regards !$T!

Hi, One of way is here. In Excel 2007. 1.Open file 2.Popup appear "Security-Link" 3.Do ---> "Enable Content". 4.Popup appear "Edit Links" 5.Here you can see the Sheet names where external Links are available. 6.Further you can check the external link on particular that sheet and...

Is anyone working on it..

Thanks Good to hear you got what you need. Obvsly u can change the part of formula. Happy to help. Keep visit. Regards Istiyak

hi xljgd Kindly dowload file from my website and check. http://istiyakshaikh.hpage.com > Downloads > For_Solution_xljgd.xls Plz do conditional formating as per your requirement or tell. Regards Istiyak

Hi Hui and xld, Thanks for response i m satisfied with answer of question 2 provided by xld becose my software is providing me data in only that manner. Sry hui i m not sable to use SUM() or Count(). Still i m facing issue with the Q1. I m using Calendar control 11.0 in xl 2003. Let...

Hi friends, I have two problems. 1. i have inserted one picture in my excel book when i m clicking on it is showing me caledar which i have added in VBA module. The query is that i want to popup that calendar with current date. i is not updating every day (Not showing current date by...

hi, Ya sure.. Your code is given output in Column A. I want output in Column AN (column no 40) where i have created Name range for smooth functioning. i have change cell address in your given code. and then i got the result where i want. Regards Istiyak