I have a dashboard with a couple of list boxes that change a chart depending on the list box selections. I have been asked to export the underlying data. When i right click and Export to excel it only gives me the list box I right clicked on.
Create a straight table with the data that you want to export. The table doesn't have to be visible.
Create a button for the user to export the data to Excel.
Excellent. Thanks for the advice. I think the step I was missing was that I needed to create a "table" object "straight table" 1st and then I could export. I appreciate the help.
Retrieving data ...