Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
While working on a worksheet I tried to copy a formula from one cell to the
adjacent cell by clicking and dragging the black box in the lower rt. corner of the first cell to the adjacent cell. I have been doing this for years w/o a problem. Now when I try to do it I can only AUTOFILL the new cell. The only way the formula is transferred is to then click on the new cell which shows that the formula has in fact be transferred and then hit "Enter." After I do this the formula is activated! Prior to last night I was able to just click on the black box, drag it to the adjacent cell, and click; at which point the formula was activated and the new data presented? What am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
Hi
maybe calculation is set to Manual ToolsoptionsCalculationautomatic -- Regards Roger Govier "Woodie6" wrote in message ... While working on a worksheet I tried to copy a formula from one cell to the adjacent cell by clicking and dragging the black box in the lower rt. corner of the first cell to the adjacent cell. I have been doing this for years w/o a problem. Now when I try to do it I can only AUTOFILL the new cell. The only way the formula is transferred is to then click on the new cell which shows that the formula has in fact be transferred and then hit "Enter." After I do this the formula is activated! Prior to last night I was able to just click on the black box, drag it to the adjacent cell, and click; at which point the formula was activated and the new data presented? What am I doing wrong? __________ Information from ESET Smart Security, version of virus signature database 4535 (20091023) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4535 (20091023) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
Sounds like you have calculation mode set to manual.
Change to Automatic. Now you're going to ask how it got that way. The first workbook opened during a session of Excel will set the calculation mode for all subsequent opened workbooks no matter what calc mode they were saved in. You have to watch out for this at all times. Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 16:56:09 -0700, Woodie6 wrote: While working on a worksheet I tried to copy a formula from one cell to the adjacent cell by clicking and dragging the black box in the lower rt. corner of the first cell to the adjacent cell. I have been doing this for years w/o a problem. Now when I try to do it I can only AUTOFILL the new cell. The only way the formula is transferred is to then click on the new cell which shows that the formula has in fact be transferred and then hit "Enter." After I do this the formula is activated! Prior to last night I was able to just click on the black box, drag it to the adjacent cell, and click; at which point the formula was activated and the new data presented? What am I doing wrong? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
On Thu, 22 Oct 2009 17:25:22 -0700, Gord Dibben <gorddibbATshawDOTca
wrote: Sounds like you have calculation mode set to manual. Change to Automatic. Now you're going to ask how it got that way. The first workbook opened during a session of Excel will set the calculation mode for all subsequent opened workbooks no matter what calc mode they were saved in. You have to watch out for this at all times. Gord Dibben MS Excel MVP IF they are opened while that workbook is open, or IF they are opened while that excel session in up? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
If they are opened while first workbook with manual calculation is still
open they will be manual. Close that wb before opening another one and calc mode will be that of next wb opened. Gord On Thu, 22 Oct 2009 19:10:41 -0700, CellShocked <cellshocked@thecellvalueattheendofthespreadsheet. org wrote: On Thu, 22 Oct 2009 17:25:22 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Sounds like you have calculation mode set to manual. Change to Automatic. Now you're going to ask how it got that way. The first workbook opened during a session of Excel will set the calculation mode for all subsequent opened workbooks no matter what calc mode they were saved in. You have to watch out for this at all times. Gord Dibben MS Excel MVP IF they are opened while that workbook is open, or IF they are opened while that excel session in up? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
Cool... I hope you feel that the clarification request was valid.
On Fri, 23 Oct 2009 08:15:49 -0700, Gord Dibben <gorddibbATshawDOTca wrote: If they are opened while first workbook with manual calculation is still open they will be manual. Close that wb before opening another one and calc mode will be that of next wb opened. Gord On Thu, 22 Oct 2009 19:10:41 -0700, CellShocked <cellshocked@thecellvalueattheendofthespreadsheet .org wrote: On Thu, 22 Oct 2009 17:25:22 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Sounds like you have calculation mode set to manual. Change to Automatic. Now you're going to ask how it got that way. The first workbook opened during a session of Excel will set the calculation mode for all subsequent opened workbooks no matter what calc mode they were saved in. You have to watch out for this at all times. Gord Dibben MS Excel MVP IF they are opened while that workbook is open, or IF they are opened while that excel session in up? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
Burglars took more than $40,000 in -'*TIFFANY BRACELETS*' (http://www.onsaletiffany.com/BRACELETS-1.html) jewelry- from three homes in Glenview last week, authorities said.Someone entered a home in the 2300 block of Lily Lane late last week and took $41,000 worth of -jewelry-, according to police. In addition, a resident in the 2000 block of Sunset Ridge Road reported that a $500 bracelet had been stolen on May 1, and a resident of 1300 block of Pleasant Lane told police $500 worth of -jewelry- had been stolen on the same day.Police sent a flier to residents about the '*TIFFANY CUFF LINKS*' (http://www.onsaletiffany.com/CUFF_LINKS-1.html) burglaries. -- love1314 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas from one cell to another
Yes, it was a valid request for clarification.
Closing the first workbook before opening a second workbook will give Excel a chance to pick up the calc mode from the next workbook opened. Unless.............always one of these<g You close the wb that has set global calc mode to manual then open a NEW workbook. The NEW workbook will be in manual mode because it has no saved calc mode setting yet. Gord On Fri, 23 Oct 2009 20:30:55 -0700, CellShocked <cellshocked@thecellvalueattheendofthespreadsheet. org wrote: Cool... I hope you feel that the clarification request was valid. On Fri, 23 Oct 2009 08:15:49 -0700, Gord Dibben <gorddibbATshawDOTca wrote: If they are opened while first workbook with manual calculation is still open they will be manual. Close that wb before opening another one and calc mode will be that of next wb opened. Gord On Thu, 22 Oct 2009 19:10:41 -0700, CellShocked <cellshocked@thecellvalueattheendofthespreadshee t.org wrote: On Thu, 22 Oct 2009 17:25:22 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Sounds like you have calculation mode set to manual. Change to Automatic. Now you're going to ask how it got that way. The first workbook opened during a session of Excel will set the calculation mode for all subsequent opened workbooks no matter what calc mode they were saved in. You have to watch out for this at all times. Gord Dibben MS Excel MVP IF they are opened while that workbook is open, or IF they are opened while that excel session in up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cell formulas | Excel Discussion (Misc queries) | |||
copying formulas and changing cell references | Excel Discussion (Misc queries) | |||
Copying Cell Results, Not Formulas, Between Worksheets | Excel Worksheet Functions | |||
Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
copying formulas to another cell | Excel Worksheet Functions |