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.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,636
Messages
5,660,002
Members
418,541
Latest member
bugsoup

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top