Pasting from 1 workbook to another

[charlesloves2read]

Hi I have workbook A and workbook B.

I have some formulas (e.g. some if functions and some referencing formulas) in some cells in workbook B which i want to paste into workbook A. However I am unable to paste them into workbook A.

However if it's within the same workbook I am able to do so.

Any advice to solve this problem is appreciated. Thanks in advance.

 

[G2K]

Hi Charles,

Ms-Excel won't allow you to paste formula from other excel instance. Not only formula but you would not be able to apply Lookup and other functions as well.

To solve this problem open excel in same instance (Multiple file in one excel instance)

 

[charlesloves2read]

Hi Gautam thanks for your prompt reply. Do you know the reason why MS excel disallows people to paste formula from other workbooks?

 

[grizz]

try this
highlite your formula and click "COPY" X-out your workbook and when you are prompt to save changes click "CANCELL" now minimize your workbook and open another book and paqste your formula

 

[G2K]

Charles,

I don't know the exact reason for this. I came across this problem many times earlier and got that idea. But i am sure excel gurus will definitely answer your question here.
For more information around this please check below link

http://excel.tips.net/Pages/T003404_Copying_Between_Instances_of_Excel.html

Hope this helps.

 

[charlesloves2read]

Wow Gautam,

Thanks for your help man. The link was real useful. Now i can get around it by tilling the windows. Cool stuff.

Thanks once again.