manual

I'm having a tough time speeding up a macro that runs through a very long sequence of steps. What's strange is when I switch excel to manual calculation, it flies through the macro in 4-5 seconds but when I switch the code to reflect this (i.e. put in xlCalculationManual in the first line of...

Hi all, I currently have an ActiveX Combo Box set up with a dropdown list of values. I previously had these set up via Data Validation as normal dropdown lists, however, switched to Combo Boxes to allow the predictive text feature to be enabled. Now, I am wondering if it's possible to do...

Hi, I am working on a workbook that is a personnel managing tool. One of my sheets retrieves data from another sheet and displays it in cells d3-d6. All 4 cells use the same data source for their retrieval. Each cell represents a quarter of the year. When that quarter is completed I want to...

I have found a solution that may help others who, like me, could not get the well-documented fixes to work .... Scenario: Worksheet shows as 'Calculate' in Status Bar, despite Excel Options being set to Automatic, Pressing F9 or Calculate does a recalc but 'Calculate' reappears immediately No...

I have a computationally expensive cell formula that queries an online database. I'd like to have calculations set to automatic, except for the cells with my expensive formula, and write a macro that switches calculations on for those specific cells then switches them back off. I haven't been...

Hi! I have a problem as I need to present data with different data sources. I'd like the calculations to be as "automatic" as possible. The data consists of countries and regions and their sales pipe. The pivot table doesn't give me all the data that I need to present so I need to add extra...

I use Vlookup everyday, all day long. I have one set of data though for some reason that won't xref for me. Below is a sample of two spreadsheets TRAN ID dumps out with a "-001" after it, I only need the first 6 characters. So I use =LEFT to get the 6. Then I use the VLOOKUP to xref the...

To start with, I have no VBA experience and I've tried searching for a solution to applying manual calculation to only part of a sheet, while the rest of the workbook is automatic. I couldn't find anything out there. My situation is this: I have a workbook with about a dozen sheets. One of the...

I have created a pivot table on Excel 2010 but I want to get the drop down (manual) filter buttons on each heading. It only shows up on one heading (top of each column) instead of all of them. How do I add them??

My 300kb Excel 2007 spreadsheet won't calculate simple formulae like sums, additions and subtractions. The spreadsheet also has CSEs, sumproducts, iferrors, maxifs, etc. My setup: Computer: Compaq laptop NC8430 CPU: intel core duo, 2 ghz, 3gb RAM OS: XP service pack 3 Excel: 2007 I have...

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am having problems with returning a workbook to automatic calculation, I am using the below code<o:p></o:p> <o:p></o:p> Application.Calculation = xlManual<o:p></o:p> <o:p></o:p> Lots of...

Hello all, I feel very silly for this question, but here's my issue. I created a Pivot Chart, and I'm using TV dayparts as my rows. I'm using the titles for these dayparts (Morning, Daytime, Early Fringe, Prime Access, Prime, Weekend AM, Weekend PM, Total Day), and Excel 2007 auto-sorted...

Hi, </PRE> I am using XL03 & XP SP2. </PRE> I am trying to autofit rows, all of which one column has cells that contain anywhere from 0 - 1500 characters. No cells are merged on the worksheet. Each of these cells with content have manual linebreaks in them to designate seperate entries (each...