XRefs nested 15 DEEP!!!!!!
Holy Cow!!!
This sounds like an Awful mess to work with or undo if needed!!
Is this done often?
sure it does...
and it really isn't that difficult to manage...consider that in the end the "Sheet" file will have at most, some layout tabs, a few notes, and view ports...all the model data is modeled in the correct file (standards are not optional), and edits are done only by the originator, etc. So one is rarely working with all that data other than to plot; or in this case figure out why it's so hard to get their end users to create some layer states.
Yes, it happens a lot and we have NO control over it. These files are from other people (other consultants, surveyors, landscape architects, the architects, etc.), so we have no control over the standards either. Some stuff is drawn in paperspace (that we actually need for some departments, such as room names and apartment numbers), the xrefs are overlaid into the "sheet" file (this wouldn't be bad, but they are numerous unit plans combined together to make an entire building), everything is drawn on one layer, things are drawn at a 1/4"=1'-0", they use ArchiCAD, Microstation or other semi-compatible programs. Now not all of this happens every time, but every last one of these things have happened and add this layer mess into the mix and you can imagine the grief that I get.
All of this creates a major mess most of the time that I as the CAD Manager am supposed to fix without the people doing the actual drafting expending any extra effort to even save layer states. Although, I think I have finally convinced them to use layer states (I made it easy via shortcuts for them, takes 20 seconds to save, 20 seconds to restore, we shall see, they are resistant to change though).