Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
Something happened. Now I can't copy and paste a formula from one cell to
another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
Are you copying and pasting between workbooks perhaps. If so then check to
see if the workbooks are in seperate instances of XL. That would cause the behavior you are describing... -- HTH... Jim Thomlinson "Bill B" wrote: Something happened. Now I can't copy and paste a formula from one cell to another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
No. I am copying from one cell in a column to the next cell in the column.
I only get the value from the previous cell (not the new value computed from the new column with the copied formula. Also no formatting is copied. Thanks for your speedy response. "Jim Thomlinson" wrote: Are you copying and pasting between workbooks perhaps. If so then check to see if the workbooks are in seperate instances of XL. That would cause the behavior you are describing... -- HTH... Jim Thomlinson "Bill B" wrote: Something happened. Now I can't copy and paste a formula from one cell to another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
Didn't say that quite right. Should have said "copying from one cell in a
column to the adjacent cell in the next column" "Bill B" wrote: No. I am copying from one cell in a column to the next cell in the column. I only get the value from the previous cell (not the new value computed from the new column with the copied formula. Also no formatting is copied. Thanks for your speedy response. "Jim Thomlinson" wrote: Are you copying and pasting between workbooks perhaps. If so then check to see if the workbooks are in seperate instances of XL. That would cause the behavior you are describing... -- HTH... Jim Thomlinson "Bill B" wrote: Something happened. Now I can't copy and paste a formula from one cell to another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
That is very odd. Can you drag the formulas? Can you select paste special?
Can you copy and paste via Ctrl+C and Ctrl+V? -- HTH... Jim Thomlinson "Bill B" wrote: Didn't say that quite right. Should have said "copying from one cell in a column to the adjacent cell in the next column" "Bill B" wrote: No. I am copying from one cell in a column to the next cell in the column. I only get the value from the previous cell (not the new value computed from the new column with the copied formula. Also no formatting is copied. Thanks for your speedy response. "Jim Thomlinson" wrote: Are you copying and pasting between workbooks perhaps. If so then check to see if the workbooks are in seperate instances of XL. That would cause the behavior you are describing... -- HTH... Jim Thomlinson "Bill B" wrote: Something happened. Now I can't copy and paste a formula from one cell to another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
I'm using Excel 2003. Have been an Excel user since it first came out.
No. Can't drag the formulas. When I select paste special it gives me two options: paste as text or paste as unicode text. Ctrl+C and Ctrl+V do the same as the menu bar and the right mouse menu. I noticed this problem on two existing spreadsheets today that I've been using for months. I also tried creating a simple new little spreadsheet but got the same problems. "Jim Thomlinson" wrote: That is very odd. Can you drag the formulas? Can you select paste special? Can you copy and paste via Ctrl+C and Ctrl+V? -- HTH... Jim Thomlinson "Bill B" wrote: Didn't say that quite right. Should have said "copying from one cell in a column to the adjacent cell in the next column" "Bill B" wrote: No. I am copying from one cell in a column to the next cell in the column. I only get the value from the previous cell (not the new value computed from the new column with the copied formula. Also no formatting is copied. Thanks for your speedy response. "Jim Thomlinson" wrote: Are you copying and pasting between workbooks perhaps. If so then check to see if the workbooks are in seperate instances of XL. That would cause the behavior you are describing... -- HTH... Jim Thomlinson "Bill B" wrote: Something happened. Now I can't copy and paste a formula from one cell to another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
I can only think of a few possibilities:
1) Did I accidentally click some strange Excel setting? 2) Is my copy of Excel corrupted? 3) Is this some sort of virus? "Bill B" wrote: I'm using Excel 2003. Have been an Excel user since it first came out. No. Can't drag the formulas. When I select paste special it gives me two options: paste as text or paste as unicode text. Ctrl+C and Ctrl+V do the same as the menu bar and the right mouse menu. I noticed this problem on two existing spreadsheets today that I've been using for months. I also tried creating a simple new little spreadsheet but got the same problems. "Jim Thomlinson" wrote: That is very odd. Can you drag the formulas? Can you select paste special? Can you copy and paste via Ctrl+C and Ctrl+V? -- HTH... Jim Thomlinson "Bill B" wrote: Didn't say that quite right. Should have said "copying from one cell in a column to the adjacent cell in the next column" "Bill B" wrote: No. I am copying from one cell in a column to the next cell in the column. I only get the value from the previous cell (not the new value computed from the new column with the copied formula. Also no formatting is copied. Thanks for your speedy response. "Jim Thomlinson" wrote: Are you copying and pasting between workbooks perhaps. If so then check to see if the workbooks are in seperate instances of XL. That would cause the behavior you are describing... -- HTH... Jim Thomlinson "Bill B" wrote: Something happened. Now I can't copy and paste a formula from one cell to another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy formulas in a worksheet
Well, as a last resort I rebooted my computer.
Guess what - Excel is working normal now. I had restarted Excel several times but that was not the problem. When will I ever learn??? Reboot, reboot, reboot, reboot,reboot..................................... ............ Anyway, thanks for your help Jim. "Bill B" wrote: I can only think of a few possibilities: 1) Did I accidentally click some strange Excel setting? 2) Is my copy of Excel corrupted? 3) Is this some sort of virus? "Bill B" wrote: I'm using Excel 2003. Have been an Excel user since it first came out. No. Can't drag the formulas. When I select paste special it gives me two options: paste as text or paste as unicode text. Ctrl+C and Ctrl+V do the same as the menu bar and the right mouse menu. I noticed this problem on two existing spreadsheets today that I've been using for months. I also tried creating a simple new little spreadsheet but got the same problems. "Jim Thomlinson" wrote: That is very odd. Can you drag the formulas? Can you select paste special? Can you copy and paste via Ctrl+C and Ctrl+V? -- HTH... Jim Thomlinson "Bill B" wrote: Didn't say that quite right. Should have said "copying from one cell in a column to the adjacent cell in the next column" "Bill B" wrote: No. I am copying from one cell in a column to the next cell in the column. I only get the value from the previous cell (not the new value computed from the new column with the copied formula. Also no formatting is copied. Thanks for your speedy response. "Jim Thomlinson" wrote: Are you copying and pasting between workbooks perhaps. If so then check to see if the workbooks are in seperate instances of XL. That would cause the behavior you are describing... -- HTH... Jim Thomlinson "Bill B" wrote: Something happened. Now I can't copy and paste a formula from one cell to another in my worksheet??? It only want's to paste text. Even with paste special, I have lost the old dialog box and have a new one that only allows pasting text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent copy of formulas on a worksheet | Excel Discussion (Misc queries) | |||
Copy Worksheet With Formulas | Excel Discussion (Misc queries) | |||
How to copy worksheet or workbook without formulas | Excel Discussion (Misc queries) | |||
copy worksheet with formulas but not data | Excel Discussion (Misc queries) | |||
copy formulas to different cells in another worksheet | Excel Discussion (Misc queries) |