Dynamics AX: Copy+Paste vs Export to Excel
I had a question from a customer recently: "On a Details Form, copy+paste gives me more fields than Export to Excel, so why would I use Export to Excel?". Below was my answer...
Copy+paste will give you values for all the visible form fields from the current datasource.
Export to Excel will initially give you values for all the visible fields from the current grid. And with refreshable Export to Excel you can add any field (not just the visible ones) from the exported datasource that you are interested in.
So, refreshable export can give you every field you want… and once you have that workbook set up, to give you all the fields you care about, then you can reuse it very easily and also build up adhoc reports on the refreshable data set.