reduce

Problem: I have a customer complainingthat every time they manipulate a pivot table in the workbook, that the workbookstarts calculating, which takes a long time and freezes the users Excel untilcalculations are finished. My Thinking on a Solution: My thinkingis to use a workbook level event...

Dear All, Can you please help me in reduce the below formula please.. I appropriate you in advance to look my query..

Hi, I have a worksheet called DATA in Excel files (called Master) where I load data from others excel files. Sometimes I need to load a huge amount of data (about 10.000.000 cells) but the most of times I just need about 100.000 cells. The point is that once I loaded a big amount of data...

Hi, I have had an extensive search of the net but am having trouble solving my predicament. I am running into a dilemma with my research. Its regarding gait analysis. I want to be able to present joint angles at a percentage of gait cycle in increments of 1 or 2%. Right now, through...

Good Day, For my first post I'd like to know if it is possible to use the "drill down" feature of a pivot table within a cell out side of that pivot table. I am using Excel 2010, on Windows 7. The end user(s) will have these (at a minimum) or newer. I have a report that tracks inventory a...

Hi. This question is purely for my own learning experience. I have the code below which works perfectly for what I want. I’m just interested in knowing if there’s a way to optimize the code even further and reduce the number of lines. The code checks which of the three checkboxes I have listed...

Hi guys, Running Win 7 64 with Xl 2010, still getting into the flow of the code here. I have working code here but it is sloppy....any suggestions on cleaning it up? I know I should be building in a loop to run through the cell references but my brain just cant quite get there! Thanks! Dim...