Copying formulas from one workbook to another

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.

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


On Fri, 20 Jul 2007 11:34:02 -0700, Brendas
wrote:

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.