Why paste between workshhets yields values only

[CGCPA]

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

 

[Sheeloo]

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]

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

 

[Gord Dibben]

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

 

[Sheeloo]

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]

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.

 

[Sheeloo]

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?