D
DTM_ADVA
Hi,
We have reports that used OWC 9 and have been changing them to use Version
10 (or 11). Version 9 of OWC, when exporting would open the Work book in an
already open Excel instance. So if we ran 3 reports, and exported each one
individually, they would all open on the same excel instance. Users could
then copy worksheets between work books.
With version 10 and greater, when you export, it opens up a new instance of
Excel. So if you export 3 reports, you get 3 instances. Excel does not permit
copying Work books, Formulas, etc between instances.
Is there anyway we can program around this behavior and have it all open in
the same instance, just like OWC 9 would do?
Thanks
We have reports that used OWC 9 and have been changing them to use Version
10 (or 11). Version 9 of OWC, when exporting would open the Work book in an
already open Excel instance. So if we ran 3 reports, and exported each one
individually, they would all open on the same excel instance. Users could
then copy worksheets between work books.
With version 10 and greater, when you export, it opens up a new instance of
Excel. So if you export 3 reports, you get 3 instances. Excel does not permit
copying Work books, Formulas, etc between instances.
Is there anyway we can program around this behavior and have it all open in
the same instance, just like OWC 9 would do?
Thanks