Search results

Thanks for the information. However, it is unfortunate for me that I'll not be able to use power pivot :(

Thanks for reply Thangavel but I have already tried this. There is nothing in Com Add-ins. My office provides only 2013 version which doesn't has pre-installed Power Pivot and Power Query. Luckily, I was able to find Power Query and got this installed and using. But for Power Pivot, unable to...

I have excel 2013 which do not has Power Pivot add-in enabled. I searched google for add-in to download but nothing found. Please help me with the link where I can download it.

Thanks Marc L for your response however; I could not use it. I added "Microsoft ActiveX Data Objects 2.5 library" and tried but didn't get using it. Also, tried to read about it on Google but felt difficult to understand the examples. (http://www.motobit.com/tips/detpg_read-write-binary-files/)...

Hi, I have a few text files (.txt) which have data in English and Chinese languages. I am required to consolidate these files. I am able to do that successfully however; while reading Chinese language data and pasted it to Excel, Chinese alphabets becomes some special characters i.e. do not...

Dear All, I am trying to make similar charts as shown in the attachment but don't know to make them in Excel. Tried a lot searching on google but got no success. I viewed them on internet so don't have data so just uploading the picture that I captured from there. Hoping to get a solution...

Hi All, Thanks for your support :) I have already checked with the points mentioned in replies. However, still unable to solve it. Unfortunately unable to upload any sample workbook. Anyways, I have found few links on google and these have some concepts. Let me try them and if those...

Hi all, Yesterday one of my team member showed me an error he was getting in a report. This is very strange kind of error which I never heard from anyone nor faced it. Also, unable to replicate it. However, seen it on my colleage's system. We tried to fix it but no success :( 1. there are 4...

Sorry Luke, I don't know how to tag my post like that. I am unable to upload a sample file to elaborate my query so just requesting you to visit below mentioned link and read the last 2-3 paragraphs where a line graph has been explained (I hope you will be able to understand my query). I just...

Hi Faseeh, I think the file that I tried to upload was discareded by system (I am working on my office system). Please read the last paragraph in the page by accessing the link I provided in my 1st post. Thanks

Hi Faseeh, I am unable to understand the solution given in the last paragraph of the page for the line graph. I have also attached a file with the related pictures. I hope this will help to understand the issue. Thanks

Hi All, First time accessing this new version of the forum and happy to find that we can upload sample data now. It will help a lot in my future posts. Thank you so much Chandoo:) I was reading a topic on google (link ...

Hi All, Please help me with VBA code so that I can login to a web based application. For example, I need a code to login to my gmail account by running a macro in Excel. Thanks, Dheeraj

Hi SirJB7, I searched it on google now. The code that I needed was ?Application.StartupPath. Other details are available at http://www.rondebruin.nl/personal.htm. Thanks, Dheeraj

Dear Narayan, It seems that I did not explained my question clearly. Let me explain it again. Whenever we open any excel workbook, MS Excel opens another excel file in the backend. The name of that file is Personal.xls. This workbook is hidden and so we are unable to view it. However, we...

Hi Narayank991, Thank you so much for the link, however there is a one line code that we can write in immediate code to get this path. I am actually looking for that. Also, I want to add this workbook in Explorer Window so save my codes and make it available all the time. Thanks, Dheeraj

Hi All, Whenever we open an Excel Workbook, in backend another workbook named personal.xlsx opens. Kindly help me to find its path using VBA and make it visible so that I can save my VBA codes in its module so that they are available to me all the time. Thanks and regards, DJ

Hi Novice007, Select the range A5:D15 and type Ctrl+G, Alt+S+O and delete. This will delete all constants and keep the formulas. Dheeraj

Hi Hui, Thank you so much for the reply. I checked it again. Yes, it works with Excel 2003 but not working in 2007 version. Is there any other way to get this/such functionality in Excel 2007? Thanks again, Dheeraj

Hi All, Please help with my query. Thanks, Dheeraj

Hi, I tried using dynamic charting technique at below link but when I insert a picture and try to type namedrange, excel doesn't let me do it. http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/ However, when I copy the picture used in downloaded file from this link, it works...

Hi All, I have a situation in which based on a condition I need to get total from multiple columns. Below showing sample data: Column-A Column-B Column-C Column-D Person1 5000 10000 15000 Person2 5000 5000 10000 Person2 4500 20000...

Hi Luke, Yes, all PTs are based on the original data. Initially there were 2 to 3 pivots but as per the requests received from Operations Team on time to time to make changes in the report, number of pivots increased. Since every pivot was saving the original data (which is really bulky)...

Hi All, I use Excel 2007 and in my report can have data of over 800000 rows and 30 columns. We have created around 10 to 15 pivots using this data. I know creating these many of pivots is a sin but it is required. Since every Pivot table saves data with the table layout by default, file size...

Thank you so much Hui. Now I have better understanding of CountIf. Dheeraj