Untested. Worked in 2010.
Go to the site that has the list view you want. Add a content editor webpart with the following:
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('div[allowExport="false"]').attr("allowExport","true");
});
</script>
Now you can export the webpart you want.
Next, open the .webpart file in notepad and look for
<property name="WebId" …>all_zeros_guid_here </property>
Replace the zeros with the GUID of the site the list is on. You can get it by going to _layouts/sitemanager.aspx When you hover over a site in the right side, the GUID is displayed at the bottom left of the window. ScreenCapture it and type it in.
Save and upload webpart
Thanks to: http://techtrainingnotes.blogspot.com/2009/03/sharepoint-one-library-multiple-sites.html
Gotchas apply and include:
Only within site collection; Not tested with all list/lib; Will error while you allow editing of content type on target list
Alternate methods to aquire site GUID, from Mike Smith's Tech Training Notes
1) Wiki home page:
Works for SP 2010 only: Display a Team Site home page (a wiki home page, home.aspx) that has at least one list web part, view the source of the page (right-view source) and search for "RelatedWebId" (you could temporarily add an Announcements or library web part to the page)
WebPartWPQ2_RelatedWebId="{f70832a4-5d0d-4265-a344-ea10a0007160}"
2) Tree View:
Works for both SP 2007 and SP 2010: Go to Site Actions, Site Settings, Tree View and enable Tree View. Then go to any page, view source and search for "ListNode:"
spNavigateHierarchy(this,'','30:ListNode:f70832a4-5d0d-4265-a344-ea10a0007160:740...