Pasting between workbooks, instead of getting the paste special options (i.e.
all, formats, formulas, etc), instead I'm getting the paste/insert object
function.

But paste special options work okay in other workbooks, just this one
workbook.

Same results in Excel 2003 and Excel 2007 for same workbook.

How can I turn this back on to get the proper paste special functions

Nadine, do you remain in the same Excel application (=instance of the program)?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Nadine" wrote:

Pasting between workbooks, instead of getting the paste special options (i.e.
all, formats, formulas, etc), instead I'm getting the paste/insert object
function.

But paste special options work okay in other workbooks, just this one
workbook.

Same results in Excel 2003 and Excel 2007 for same workbook.

How can I turn this back on to get the proper paste special functions

I do have 2 seperate sessions of Excel open so I can have one open on one
screen and the other on the other screen.

Unless there is another way I can run one session of excel but have 2
workbooks open one on each seperate monitors (using dual monitor display)

"Wigi" wrote:

Nadine, do you remain in the same Excel application (=instance of the program)?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Nadine" wrote:

Pasting between workbooks, instead of getting the paste special options (i.e.
all, formats, formulas, etc), instead I'm getting the paste/insert object
function.

But paste special options work okay in other workbooks, just this one
workbook.

Same results in Excel 2003 and Excel 2007 for same workbook.

How can I turn this back on to get the proper paste special functions

Okay, I see it works if I open both workbooks in the same instance of excel....

Do you know if there is a trick - when using dual monitor - to display the
workbooks on seperate screens, besides running 2 different excel sessions.
Excel 2007 or 2003

Thanks


"Nadine" wrote:

I do have 2 seperate sessions of Excel open so I can have one open on one
screen and the other on the other screen.

Unless there is another way I can run one session of excel but have 2
workbooks open one on each seperate monitors (using dual monitor display)

"Wigi" wrote:

Nadine, do you remain in the same Excel application (=instance of the program)?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Nadine" wrote:

Pasting between workbooks, instead of getting the paste special options (i.e.
all, formats, formulas, etc), instead I'm getting the paste/insert object
function.

But paste special options work okay in other workbooks, just this one
workbook.

Same results in Excel 2003 and Excel 2007 for same workbook.

How can I turn this back on to get the proper paste special functions

If you're using multiple monitors, you may want to review Chip Pearson's notes:
http://cpearson.com/excel/MultipleMonitors.aspx

Nadine wrote:

Okay, I see it works if I open both workbooks in the same instance of excel....

Do you know if there is a trick - when using dual monitor - to display the
workbooks on seperate screens, besides running 2 different excel sessions.
Excel 2007 or 2003

Thanks

"Nadine" wrote:

I do have 2 seperate sessions of Excel open so I can have one open on one
screen and the other on the other screen.

Unless there is another way I can run one session of excel but have 2
workbooks open one on each seperate monitors (using dual monitor display)

"Wigi" wrote:

Nadine, do you remain in the same Excel application (=instance of the program)?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Nadine" wrote:

Pasting between workbooks, instead of getting the paste special options (i.e.
all, formats, formulas, etc), instead I'm getting the paste/insert object
function.

But paste special options work okay in other workbooks, just this one
workbook.

Same results in Excel 2003 and Excel 2007 for same workbook.

How can I turn this back on to get the proper paste special functions

--

Dave Peterson