Dynamics Corporate Reporting Management explains Management Reporter – Quick tips on linking to Microsoft Excel workbooks
Management Reporter – Quick tips on linking to Microsoft Excel workbooks – Dynamics Corporate Performance Management – Site Home – MSDN Blogs
Tips & Hidden FeaturesReporting & BIExcel & Office
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.