| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why paste between workshhets yields values only
Excel 2007 - When coping an area of cells which contain formulas from one
spreadsheet to another the target spreadsheet results shows only values of the copied formulas. Copying and pasting within the same spreadsheet (between tabs in the same) retains the formula. WHY? What is happening in excel that kills the formula |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why paste between workshhets yields values only
Apparently you are running two instances of Excel.
Try this Open the first spreadsheet Open the second using the Open command from the Office Button so that both open in the same instance... Now try Copy/Paste... "CGCPA" wrote: Excel 2007 - When coping an area of cells which contain formulas from one spreadsheet to another the target spreadsheet results shows only values of the copied formulas. Copying and pasting within the same spreadsheet (between tabs in the same) retains the formula. WHY? What is happening in excel that kills the formula |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why paste between workshhets yields values only
Thank you Sheeloo,
On every occasion of my question regarding problems with the excel 2007 copy paste, the responses are consistently "you must be running two instances" , I promise there is only one instance and the 2nd worksheet was indeed opened using the "open" command. There must be a technical programatic reason why excel copy value only. It gray's me out of the copy paste menu where I should be able to select the paste special functions. May I ask out there in microsoftland - what is the solution when MS has no answer to very basic functional problems. Thanks "Sheeloo" wrote: Apparently you are running two instances of Excel. Try this Open the first spreadsheet Open the second using the Open command from the Office Button so that both open in the same instance... Now try Copy/Paste... "CGCPA" wrote: Excel 2007 - When coping an area of cells which contain formulas from one spreadsheet to another the target spreadsheet results shows only values of the copied formulas. Copying and pasting within the same spreadsheet (between tabs in the same) retains the formula. WHY? What is happening in excel that kills the formula |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why paste between workshhets yields values only
If you have the workbooks open each in a separate instance of Excel you will
get this behavior. Close one instance and open both books in one instance. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 12:31:03 -0800, CGCPA wrote: Excel 2007 - When coping an area of cells which contain formulas from one spreadsheet to another the target spreadsheet results shows only values of the copied formulas. Copying and pasting within the same spreadsheet (between tabs in the same) retains the formula. WHY? What is happening in excel that kills the formula |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why paste between workshhets yields values only
All I can say is that I am using Excel 2007 for more than a year now and I
have never faced this problem... I copy paste everyday and it works every time... Even between two instances PASTE SPECIAL works - though options available are limited like Text, HTML,... MS Excel is a great product... If I could, I would come to your PC and try to solve the problem... "CGCPA" wrote: Thank you Sheeloo, On every occasion of my question regarding problems with the excel 2007 copy paste, the responses are consistently "you must be running two instances" , I promise there is only one instance and the 2nd worksheet was indeed opened using the "open" command. There must be a technical programatic reason why excel copy value only. It gray's me out of the copy paste menu where I should be able to select the paste special functions. May I ask out there in microsoftland - what is the solution when MS has no answer to very basic functional problems. Thanks "Sheeloo" wrote: Apparently you are running two instances of Excel. Try this Open the first spreadsheet Open the second using the Open command from the Office Button so that both open in the same instance... Now try Copy/Paste... "CGCPA" wrote: Excel 2007 - When coping an area of cells which contain formulas from one spreadsheet to another the target spreadsheet results shows only values of the copied formulas. Copying and pasting within the same spreadsheet (between tabs in the same) retains the formula. WHY? What is happening in excel that kills the formula |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why paste between workshhets yields values only
Thank you Sheeloo, you are very kind for that thought ... I undertook the
laborous task of uninstalling one program at a time each of the many financial, math and accounting applications which I though may cause conflics. It appears at this point that the MS Net Framework installed by a Thomson Retuters application was the cause of the cut paste problem. This is a significantly important audit application for us as CPAs and we will have to consider the implications of the conflic issue. Thank you for your kind response. "Gord Dibben" wrote: If you have the workbooks open each in a separate instance of Excel you will get this behavior. Close one instance and open both books in one instance. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 12:31:03 -0800, CGCPA wrote: Excel 2007 - When coping an area of cells which contain formulas from one spreadsheet to another the target spreadsheet results shows only values of the copied formulas. Copying and pasting within the same spreadsheet (between tabs in the same) retains the formula. WHY? What is happening in excel that kills the formula |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why paste between workshhets yields values only
Thanks for your feedback...
Your observation will help many users. Apparently the add-in was written for Excel 2003 and is having problems with Excel 2007. You may pass on your findings to the creators and hopefully you will get an upgrade... Also maybe MS Network Framework has an higher version? "CGCPA" wrote: Thank you Sheeloo, you are very kind for that thought ... I undertook the laborous task of uninstalling one program at a time each of the many financial, math and accounting applications which I though may cause conflics. It appears at this point that the MS Net Framework installed by a Thomson Retuters application was the cause of the cut paste problem. This is a significantly important audit application for us as CPAs and we will have to consider the implications of the conflic issue. Thank you for your kind response. "Gord Dibben" wrote: If you have the workbooks open each in a separate instance of Excel you will get this behavior. Close one instance and open both books in one instance. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 12:31:03 -0800, CGCPA wrote: Excel 2007 - When coping an area of cells which contain formulas from one spreadsheet to another the target spreadsheet results shows only values of the copied formulas. Copying and pasting within the same spreadsheet (between tabs in the same) retains the formula. WHY? What is happening in excel that kills the formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i merge two workshhets in to one? | New Users to Excel | |||
| Formula to copy text from a column in different workshhets | Excel Worksheet Functions | |||
| Combining workshhets with different number of colums and column wi | Excel Discussion (Misc queries) | |||
| sum between workshhets | Excel Discussion (Misc queries) | |||
| merge/combine workshhets | Excel Discussion (Misc queries) | |||
Linear Mode
