I can't seem to submit a new idea to the Idea Pond, the button is there but clicking it does nothing. Anyhow, if this issue has already been documented feel free to delete this post.
Annoyance really - when using the quick export feature and selecting Active Instance of Excel as your target, the list of excel targets is being cluttered with otherwise "hidden" roaming profile instances that I don't believe anyone is actually intended to select:
Any chance the instance harvesting methods could be tweaked to ignore workbooks coming out of places like /Excel/XLSTART/ ? Should solve both the Roaming and Local instances.
Steps to reproduce (in my case)
- Run a query via Editor that outputs any result set.
- Right click on the result-set grid, select Quick Export > **Excel Instance **> **Excel Instance at Active Cell **(or any of those 3 choices, really)
- Dialog box pictured above appears, which includes active opened workbooks, but also includes roaming and local profile personal.xlsb instances.