I thought I could defeat the linking by erasing the link related to the paste/linked area from the formula bar in Excel......no such luck. I got hit by exactly what you are describing. All of a sudden, my neatly aligned bad looking graphs pasted in Excel were replaced by a totally different view of the Mathcad sheet.....quite remarkable. For some reason Paste/Link is broken right now, but based on what I just experienced corroborated by your own experience, I am not going to waste more time trying to fix it, although is was by far the best looking and fastest solution of all these cumbersome round about ways. Google didn't lead to a definite answer on how to get rid of these links.
I see exactly what you mean by a "specific area" in the document. The link is of the form "Selection 40 4632 409 4931' which looks more topographical rather than an intelligent link to a defined object.
The pasting with enhanced metafile format you mention is what I am using for the transit via Word. I tried the enhanced metafile transit via Mcad as suggested but the end result is sharper with a transit through Word (still no match to the no-click pasting from 2001....and there is still extra work required as the Mcad region transfers over with no fill or frame....unlike the no click 2001..... ).
***************************************************************************************************************************************************************************************
Let me try to offer option 3 on the good Dr Professor.
-- As an educator in a Master's program, he is most likely expecting a certain level of maturity from us, the students, which unfortunately is often lacking. In previous years, the Professors in the department have shown a lot of trust in our ethics. But as usual, some have abused the system, with some blatantly copying HWs, including the name on the original work! It is very easy to detect non original work in Excel spreadsheets, specially when Roger's still has links to Rolf's harddrive.
So I think that treaceability to original work is the key here for this Excel scheme. As a matter of facts, I turned in a HW with some of the steps done in Mathcad on something that made no sense for me to be done in Excel, fully expecting sanctions for not respecting the submission format. It could have been one of the few correct submissions because it came back with extra credits! But the key here is to document the Mathcad work clearly enough, as he doesn't know Mathcad. Hence the need to transfer graphs and equations in a neat way.
