I’m having an issue using an Excel add-in although believe the issue is down to an Excel setting rather than the tool itself as this cannot be replicated on anyone elses machine.

The tool should automatically pull data and produce graphs based on these tables, however I have an issue whereby graphs and tables do not populate. The issue appears to be because formulas are not being applied to the whole table, I am therefore required to drag down the table manually (as demonstrated in screenshot below) to apply formulas to the whole table and then clicking refresh under the data tab for graphs to display.

The tool should do this automatically as part of the report. Any ideas how to correct this?

Screenshot
https://skydrive.live.com/redir.aspx...FRQBYZUbCV0%24