Make Excel Exports Static By Disabling the Refresh Option

Originally posted on Dynamics AX Tip Of The Day:

The Export To Excel function within Dynamics AX is a powerful tool, because it gives you a live link back to the database, allows you to add additional fields, and also allows you to refresh the data. But for some people that is just too much power. For those users you can easily turn the Export To Excel from a power tool to a simple screen scrape utility just with a flick of a option flag.

I would never suggest that you do this as an April Fool...