Creating a Dynamic Link to Excel to import budget - 250 g/l accounts and 450 reporting units


I am trying to learn how to link my extremely large budget spreadsheet into management reporter. But, I can’t seem to find any solid answers on the end goal.

I need the budget to also be run in management reporter by location and by account.

As I’m looking at how to set up the excel link, I don’t see any mechanisms that would allow this to automatically happen in management reporter. Right now it looks like I’m going to have to manually link each cell in my spreadsheet to a reporting unit and a g/l account. This could result into having to make 112,500 manual links. If this is the case, I need to find another way to do this.

If you have any insight into this, I would really appreciate it. Thank you!

Is this on Finance and Ops or AX? I don’t think it’s possible to link to an Excel sheet anymore in Dynamics 365 Finance and Ops.