"Have you tried formatting these ranges as tables? This would had the same effect as dynamic ranges as Excel will automatically adjust the range's size.
The SUM formulae then become static, eg.; =SUM(Table1[Sales])
You can use Name…"
Hi,Does anyone know if it's possible to add a node in the user.config file for the repository path?We are using GPO to distribute the config file and it contains nodes for the DBServer, DBCatalog, DBUser, DBPassword, but no node for the path.ThanksPaulSee More