Upgrade to New Excel Versions

The client in this case requested to upgrade a complex existing Excel application, which was originally designed by us using Excel 1997 to Excel 2010 and later to Excel 2016.

Features:

  • The replacement of the old style custom command bars with Ribbons – Commands proved challenging. But we could finally solve this through some innovative programming using Excel VBA and XML.
  • We were able to extend individual spreadsheets to use the full Excel worksheet capacity.
  • Our programmer changed links and named ranges to fit the new Excel syntax.
  • We encountered conditional formatting problems and also had to deal with performance losses, which at the end lead to improved speeds.
  • When updating to Excel 2016 we had to deal with a number of issues related to the new interface.

If interested in our services, please contact us for a free quote.

Excel Software Solutions