I created a List in a Site. I used a Content Query Web Part to access the List from a different site (within the same Site Collection). This is working as expected. I need to export the data to Excel, but CQWP does not allow me to export to Excel. Would it possible if I were to use another type of Web Part (e.g. DataView)? I realize a 3rd party tool (e.g. something through Bamboo) could be used, but I am trying to avoid having to pay for this functionality
Would this be feasible if I re-configured the List or did something different within SharePoint to acheive this? Ultimately, I need a List that is accessible from multiple sites within the same Site Collection and be able to export to Excel. .