If it is just data you have then it is a database that makes the best
solution. Then you can better control the data and keep it away from the
unwashed masses. If that is just not feasable then put the data on a
protected sheet or maybe a very hidden sheet to stop the heathen from messing
up what they were not supposed to touch in the first place. Just a thought...
--
HTH...

Jim Thomlinson


"Alan" wrote:

"Jim Thomlinson" wrote in message
...

To the best of my knowledge you can't. That is why I never create
multiple instances of Excel. One instance is completely independant
of the other and the two can not interact.



Thanks for your quick reply.

If you avoid doing it that way, is there another route I could take?

The reason I was hoping to copy to another instance is that there are
a lot of settings tied down in the original application instance (cell
drag and drop / copy and paste - enough to render the application
fairly useless as an excel application but very safe for the data).

Of course, the best solution would be to move to a different tool
(Access probably), but that would incur a lot of time / effort that we
cannot really justify at this point.

Thanks again!

Alan.