Individual Excel spreadsheets can be complicated and confusing enough but, when links to multiple other spreadsheets are also involved in FP&A modelling, problems can increase dramatically.

In a recent webinar run by the ICAEW in association with Synapse on how to resolve FP&A modelling challenges, some interesting insights were revealed during an online poll.  File linkages and broken formulae came out on top with 44% of respondents saying they see this as a major challenge, followed closely behind by 36% of respondents citing creation and maintenance as their main worry.