When I try to cut and paste a table from Monarch into Excel, it takes all of
the column values and pastes into one Excel cell.
What is the option that prevents this from happening? Our company just
updated to 2007 yesterday and this is slowing me down tremendously.

Thanks.

Is this what "Monarch" is?

Monarch Professional
http://www.datawatch.com/_products/monarch_pro.php

Seems to do it natively according to this excerpt:

Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls)
spreadsheets so you can work with your data in the format you want

dugoutAK wrote:

When I try to cut and paste a table from Monarch into Excel, it takes all of
the column values and pastes into one Excel cell.
What is the option that prevents this from happening? Our company just
updated to 2007 yesterday and this is slowing me down tremendously.

Thanks.

Yes, that's the Monarch.
It hasn't done it natively in the past, the Xp version allowed to paste just
like the data was, in columns, not into just one cell.

"Bob I" wrote:

Is this what "Monarch" is?

Monarch Professional
http://www.datawatch.com/_products/monarch_pro.php

Seems to do it natively according to this excerpt:

Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls)
spreadsheets so you can work with your data in the format you want

dugoutAK wrote:

When I try to cut and paste a table from Monarch into Excel, it takes all of
the column values and pastes into one Excel cell.
What is the option that prevents this from happening? Our company just
updated to 2007 yesterday and this is slowing me down tremendously.

Thanks.

Perhaps you may ask their tech support? I've never used the software so
I can't tell what you are "copying" from.

dugoutAK wrote:

Yes, that's the Monarch.
It hasn't done it natively in the past, the Xp version allowed to paste just
like the data was, in columns, not into just one cell.

"Bob I" wrote:


Is this what "Monarch" is?

Monarch Professional
http://www.datawatch.com/_products/monarch_pro.php

Seems to do it natively according to this excerpt:

Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls)
spreadsheets so you can work with your data in the format you want

dugoutAK wrote:


When I try to cut and paste a table from Monarch into Excel, it takes all of
the column values and pastes into one Excel cell.
What is the option that prevents this from happening? Our company just
updated to 2007 yesterday and this is slowing me down tremendously.

Thanks.