Jun 7, 2004 · Hi everyone, My formulas were working just fine until today. I think some setting somewhere in Excel has gone haywire, but I don't know what or how. I've got a column of data and …

May 1, 2008 · My Excel is not copying properly. When I copy paste 1A +1B, to the next line It's still giving me 1A + 1B rather than 2A + 2B. Also, it is suddenly not recalculating values. So when I put in …

Aug 21, 2010 · I have a column of cell with the date, e.g., 08/21/10 I want to be able to drag the cell without incrementing the date to 08/22/10 Is there some way of doing this?

Oct 19, 2004 · Need to copy (drag) a formula that references pivot table data. eg formula calculates a percentage for each row in a pivot table output. When I type the...

Aug 8, 2007 · I simply am trying to copy a formula from a sheet in one workbook (Ex: "Main" sheet from workbook "WB1") to another workbook (Ex: WB2). Unlike some of the other posts about copying …

Feb 11, 2006 · Hello, I'm hoping that there's someone out there that can help with this problem. I'm trying to count values in one column so that I have an amount of each for a distribution. For example: …

Mar 25, 2010 · I've entered a vlookup formula and when I copy it to another cell, sometimes it copies the formula correctly into the other cells and comes up with the correct (and different) results but …

Jan 23, 2004 · Then when I put the formula to generate another number, for example, putting the formula in cell B1, the value in A1 would change >_< Is there a way to stop this automatic update …

Feb 7, 2008 · Can anyone please help me, I am trying to copy a formula =(sump1:p3) from one worksheet into a new worksheet. When I go to paste the formula the only thing that comes up is …

May 21, 2008 · -- Biff Microsoft Excel MVP whats does the G1 represent in your formula? i'm trying to use this formula and my data is is array e7:e62 on sheet 1 and i need to put in a formula on a sheet 2 …