The situation is that if users want to copy some data from a larger workbook "~600KB" (with formated and function filled cells areas) to another workbook in separate instance of excel they get the following error message:
Microsoft Excel cannot paste the data.
with a clean workbook the error appears after 5 copy/paste, and if data is copied to another already filled workbook it appears after second attempt of copy/paste. this goes away only when completely closing excel.
I have already tried: repair office, disable any add-ons and even using the safe mode. error is presented in every situation. And i can reproduce this in every computer that uses Win7 and Office professional plus 2010
the point is that we need to be able to copy to another instance of excel with another workbook opened in it. (this way removes the functions and only copies the numeric data we need)
This is this way by default. (You said "in separete instance").
To avoid the problem open both Excel files in the same instance.
Just to check open 2 Excel files in separete instances and try to copy a cell with a formula from one file to another, you will see it's not possible, the cells will be paste as numbers, not formulas.(By design).
Hope it helps.
thanks for the reply but its not a solution we can accept, the same situation worked well on XP machine with the same files and same office
our data handlers use two large monitors and need to view workbooks separately so they can compare and if necessary make changes by copy/paste to another workbook
we even dont need formulas to be copyed but even with only numbers pasted the error pops up and messes up the workflow
l start over
one of our data analysts claim that she has used excel this way for 4 years now, that she can copy data from on workbook(on monitor 1) and paste it to another workbook ( on monitor 2), problem is that she got a new computer now with windows 7, and all the sudden nothing is as it was :P. i have tried to explain this to her but no use. i even have installed on fresh computer with XP SP3 and oddice 2010 pro Plus. have to admit the error is persistent.
to me its not important how the excel is working: in the same instance or different, we need to use it on two separate LCD monitors. easy-st way seemed to edit the registry with "%1" added so it would open directly in separate window
edit\ after rechecking the problematic computer i restored the registry settings to defaults, situation for now is that the workbooks still open separately but no errors anymore, atleast with the smaller files, i'll let you know tomorrow how its going