The issue has been resolved
After the reinstall you need to deactivate the Layout generator Add-in (under the excel options) and restart excel. It will auto-execute and the task pane should show up
Sage Intelligence is an additional reporting module for most sage products. It extracts data from the core program (the one you're having the account reconciliation issue with) and pushes all that data into excel where you can design…"
This information can be found in the sage data dictionary
Go to help - sage 50 help
When the help window loads, go to the index tab
Search for "data"
Look for the "data(DAT files)" result
You should see the…"
"Oh I see what is going on here.
You are trying to the get the name and location of the file to update according to the months.
The internal workings of sage intelligence won't let you do this unfortunately.
Essentially, if you want…"