How to copy formula to another file

G

Gary_B

In Excel 2007 if I copy a formula from one file and paste 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?
 
D

Dave Peterson

My bet is that you have two instances of excel open and you're copying from one
instance and pasting into another.

Close one of the instances of excel and open the workbook in the first instance.

Then try the copy|paste.
 
G

Gary_B

Tahnk you! that was the issue.

Gary

Dave Peterson said:
My bet is that you have two instances of excel open and you're copying from one
instance and pasting into another.

Close one of the instances of excel and open the workbook in the first instance.

Then try the copy|paste.
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
Paste options button disappears 0
Generated text copies into another template 0
Embed the same Excel multiple times 0
Copy addition formula of non-consecutive horizontal cells 2
Outlook Backup issues 0
How to paste this down? 3

Top