How to copy formula to another file

G

Gary_B

In Excel 2007 if I copy a formula from one file and pate it in another, only
the result is copied.

If I go to "paste special" it is disabled. I can paste between sheets on the
same file fine.

Any suggestions?
 
G

Gord Dibben

The usual cause of this is having two workbooks open in separate instances
of Excel.

Close one instance and open both workbooks in one instance.


Gord Dibben MS Excel MVP
 
G

Gary_B

Thank you! that was the issue.


Gord Dibben said:
The usual cause of this is having two workbooks open in separate instances
of Excel.

Close one instance and open both workbooks in one instance.


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
How to copy formula to another file 2
Generated text copies into another template 0
Embed the same Excel multiple times 0
How to copy files from Onedrive account to another 2
Copy addition formula of non-consecutive horizontal cells 2
Paste options button disappears 0
Outlook Backup issues 0

Top