Recent content by smittal

its already in .xlsb format and containing the size of 12 mb:oops:

@ Deepak, its 12 MB file after zipped. have very less data and lots of graphics. Its good to share?

Hi All, Can anybody suggest a vba code in access, which enables macro automatically at open event of ms-access. Actually, in a project we are using ms-access as a front end tool containing some Autoexe macros. Everytime, whenever we open ms-access it shows an error because they disabled all...

Thanks Hui for the suggestion, no connection found.. :(

Thanks all for suggestions but :( none of the worked out for me, checked all graphics series and data none of the chart/graph contained link, and try to find with "[" but output shows no data found. My more reasons which stops me to break the link.

Hi All, I stucked at a place in excel from so long. we have a excel workbook contain external links, I tried to break the links with all the options available in the Data Menu>>edits links. I do good reserac on google as well and got options like: 1) Check Name Manager in formula and delete...

Thanks all for your support. Hui sir@ I am not able to upload file beacuse of Access Denied.. file upload by Azumi is perfect. shrivallabha@ code is perfect but showing error when drag to other columns. Thanks in advance for help.

Dear team, i am working on a excel dashboard where i need to do a certain operation:- Grade Name1 Name2 Name3 A anul suresh ahima B shweta X Y now i have a db like which i want to fill up with grade. this table need data maping from...

Hi Luke, I want to look out the vba code for same. I tried to open from the link given above but think so the website get revamped. and also when tried to search it out then not able to find the exact wat i was looking for. Can you please share the updated link for same or on some other...

Hi Coolkiran, My requiremnt is exactly same what you have and what you have mentioned in your thread opening line. Can you please share the VBA code to browse the file path for opening the xls/csv file through vba code. Thanks in advance for the same. Shweta

Dear All, would request you to please suggest:- In a dynamic excel pie chart, if we want to show category name with legends on graph, for only those values which are zero. is it possible? i am very confused here. Thanks in advance for same. file attached with dummy data for reference.

Dear Debraj, Thanks for your reply. but how can i select the checkbox. My Requirment is for dynamic chart based on checkbox selection and de-selection. (value and category have to be visible but colorless in case of de-selection) Also, i tried to achieve my requirement with a New Idea. I...

Dear Narayan Sir, Thank you so much for your response. i have learned a new property of checkbox.(linked) can you please clear few more doubts:- 1) ca we linked checkbox with different tab(in same worksheet) 2) it is possible that when we un-select any checkbox then its value will still...

Thanks both for your replies. looking for the same which replied by Narayank sir. but sir there is a question. 1) please suggest how we do it? 2) if we add any check box then, can it done automatically?

Hello All i am making a dashboard and need anybody's help to complete the same. in attached file there are two columns B and c, filled with data and pie chart value depends on these column data. for now pie chart is considering entire B & C column for chart data range but i want ... there is...