Copying formulas from one workbook to another

G

Guest

We are using Office XP Standard. We used to be able to open two separate
workbooks, opened separately from a folder on our file server, then copy one
formula to the other. Now when we try to do it we can't even use "paste
special" to paste the saved formula. We get a menu that comes up "Source:
Microsoft Excel Worksheet Object" - with choices of "Microsoft Excel
Worksheet Object, Picture, Bitmap etc." When i use the MS Excell WS object it
comes into the worksheet as "=EMBED("Excel, Sheet "#,"").

Is there a way to get the feature back - "paste special" that actually just
pastes the formula?

Any help would be much appreciated.
 
G

Gord Dibben

This is typical behaviour when you have those two workbooks open in two separate
instances of Excel.

Close one instance and open both workbooks in one instance of Excel.


Gord Dibben MS Excel MVP
 

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

Top