If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem copying formula to range of cells
Is there a setting in excel 2002 to turn off the copying of formulas? I'm
working on a support call where I have no problems with the worksheet doing this, but he does (same document). When he tries to copy the formula, it copies the value from the cell that has the formula to all the rest of the cells. I also had him try a new excel worksheet and it doesn't work there either. Here's what we have tried: Move or copy a formula (from excel help): When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based on the type of reference used. 1. Select the cell that contains the formula. 2. Verify that the cell references used in the formula will produce the result you want. Switch to the type of reference you need. 3. On the Edit menu, click Copy. 4. Select the cell you want to copy it to. 5. To copy the formula and any formatting, on the Edit menu, click Paste. 6. To copy the formula only, on the Edit menu, click Paste Special, and then click Formulas. I have also run the detect and repair back to the default settings without any luck. I did find one tip that works for him, but would like to fix the problem. If he selects the cells he wants to copy the forumla to, types the formula and then presses CTRL+Enter and it will paste the formula correctly. I didn't find anything useful in the knowledge base on this either. |
#2
|
|||
|
|||
Ellen
As you copy, do the cell references change but value does not? Do values change if you hit F9? If so, check ToolsOptionsCalculation and check "Automatic" Gord Dibben Excel MVP On Mon, 25 Oct 2004 11:37:05 -0700, "Ellen" wrote: Is there a setting in excel 2002 to turn off the copying of formulas? I'm working on a support call where I have no problems with the worksheet doing this, but he does (same document). When he tries to copy the formula, it copies the value from the cell that has the formula to all the rest of the cells. I also had him try a new excel worksheet and it doesn't work there either. Here's what we have tried: Move or copy a formula (from excel help): When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based on the type of reference used. 1. Select the cell that contains the formula. 2. Verify that the cell references used in the formula will produce the result you want. Switch to the type of reference you need. 3. On the Edit menu, click Copy. 4. Select the cell you want to copy it to. 5. To copy the formula and any formatting, on the Edit menu, click Paste. 6. To copy the formula only, on the Edit menu, click Paste Special, and then click Formulas. I have also run the detect and repair back to the default settings without any luck. I did find one tip that works for him, but would like to fix the problem. If he selects the cells he wants to copy the forumla to, types the formula and then presses CTRL+Enter and it will paste the formula correctly. I didn't find anything useful in the knowledge base on this either. |
#3
|
|||
|
|||
Thank you. He was very happy to get this working again. I figured it had to
be a setting somewhere but wasn't sure which one. Ellen "Gord Dibben" wrote: Ellen As you copy, do the cell references change but value does not? Do values change if you hit F9? If so, check ToolsOptionsCalculation and check "Automatic" Gord Dibben Excel MVP On Mon, 25 Oct 2004 11:37:05 -0700, "Ellen" wrote: Is there a setting in excel 2002 to turn off the copying of formulas? I'm working on a support call where I have no problems with the worksheet doing this, but he does (same document). When he tries to copy the formula, it copies the value from the cell that has the formula to all the rest of the cells. I also had him try a new excel worksheet and it doesn't work there either. Here's what we have tried: Move or copy a formula (from excel help): When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based on the type of reference used. 1. Select the cell that contains the formula. 2. Verify that the cell references used in the formula will produce the result you want. Switch to the type of reference you need. 3. On the Edit menu, click Copy. 4. Select the cell you want to copy it to. 5. To copy the formula and any formatting, on the Edit menu, click Paste. 6. To copy the formula only, on the Edit menu, click Paste Special, and then click Formulas. I have also run the detect and repair back to the default settings without any luck. I did find one tip that works for him, but would like to fix the problem. If he selects the cells he wants to copy the forumla to, types the formula and then presses CTRL+Enter and it will paste the formula correctly. I didn't find anything useful in the knowledge base on this either. |
#4
|
|||
|
|||
Hi Gord
Your information on my problem of not being able to paste formulas, was really helpful. Is there any site where we can learn more about the Excel VBA programming. Thanks msethi "Gord Dibben" wrote: Ellen As you copy, do the cell references change but value does not? Do values change if you hit F9? If so, check ToolsOptionsCalculation and check "Automatic" Gord Dibben Excel MVP On Mon, 25 Oct 2004 11:37:05 -0700, "Ellen" wrote: Is there a setting in excel 2002 to turn off the copying of formulas? I'm working on a support call where I have no problems with the worksheet doing this, but he does (same document). When he tries to copy the formula, it copies the value from the cell that has the formula to all the rest of the cells. I also had him try a new excel worksheet and it doesn't work there either. Here's what we have tried: Move or copy a formula (from excel help): When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based on the type of reference used. 1. Select the cell that contains the formula. 2. Verify that the cell references used in the formula will produce the result you want. Switch to the type of reference you need. 3. On the Edit menu, click Copy. 4. Select the cell you want to copy it to. 5. To copy the formula and any formatting, on the Edit menu, click Paste. 6. To copy the formula only, on the Edit menu, click Paste Special, and then click Formulas. I have also run the detect and repair back to the default settings without any luck. I did find one tip that works for him, but would like to fix the problem. If he selects the cells he wants to copy the forumla to, types the formula and then presses CTRL+Enter and it will paste the formula correctly. I didn't find anything useful in the knowledge base on this either. |
#5
|
|||
|
|||
msethi
Don't know how you got involved in this thread of Ellen's, but for VBA programming basics and links to sites see David McRitchie's "getting started" site. http://www.mvps.org/dmcritchie/excel/getstarted.htm Gord On Fri, 19 Nov 2004 07:49:04 -0800, msethi wrote: Hi Gord Your information on my problem of not being able to paste formulas, was really helpful. Is there any site where we can learn more about the Excel VBA programming. Thanks msethi "Gord Dibben" wrote: Ellen As you copy, do the cell references change but value does not? Do values change if you hit F9? If so, check ToolsOptionsCalculation and check "Automatic" Gord Dibben Excel MVP On Mon, 25 Oct 2004 11:37:05 -0700, "Ellen" wrote: Is there a setting in excel 2002 to turn off the copying of formulas? I'm working on a support call where I have no problems with the worksheet doing this, but he does (same document). When he tries to copy the formula, it copies the value from the cell that has the formula to all the rest of the cells. I also had him try a new excel worksheet and it doesn't work there either. Here's what we have tried: Move or copy a formula (from excel help): When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based on the type of reference used. 1. Select the cell that contains the formula. 2. Verify that the cell references used in the formula will produce the result you want. Switch to the type of reference you need. 3. On the Edit menu, click Copy. 4. Select the cell you want to copy it to. 5. To copy the formula and any formatting, on the Edit menu, click Paste. 6. To copy the formula only, on the Edit menu, click Paste Special, and then click Formulas. I have also run the detect and repair back to the default settings without any luck. I did find one tip that works for him, but would like to fix the problem. If he selects the cells he wants to copy the forumla to, types the formula and then presses CTRL+Enter and it will paste the formula correctly. I didn't find anything useful in the knowledge base on this either. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
INDEX & MATCH formula problem | securityman | Worksheet Functions | 5 | September 6th, 2004 04:25 AM |
Copying Notes as well as cells | JJ | General Discussion | 1 | September 2nd, 2004 11:58 PM |
Copying CONCATENATE formula to other cells in column | Tim | Worksheet Functions | 2 | June 18th, 2004 03:24 PM |
Arrary formula for Average includes blank cells | jan | Worksheet Functions | 4 | May 14th, 2004 11:19 PM |