Pasting from 1 workbook to another

charlesloves2read

Board Regular
Joined
Aug 11, 2010
Messages
53
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.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

G2K

Active Member
Joined
May 29, 2009
Messages
355
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

Board Regular
Joined
Aug 11, 2010
Messages
53
Hi Gautam thanks for your prompt reply. Do you know the reason why MS excel disallows people to paste formula from other workbooks?
 

grizz

Active Member
Joined
Jul 28, 2009
Messages
400
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
 

charlesloves2read

Board Regular
Joined
Aug 11, 2010
Messages
53
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.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,933
Messages
5,508,215
Members
408,670
Latest member
lhmwnrexcel

This Week's Hot Topics

Top