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.
- 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
- Data Mapping Tool
- Day Trader Analysis Tool
- Integrated Contractor’s Administration and Accounting Tool in Excel
- Investment Portfolio Recommendation Tool
- Management Reporting Tool
- Multi-Currency Cash Book in Excel
- Payroll and Personnel Costs Planning Tool
- Quotation Tool using Excel VBA
- Sales Forecasting Tool
- Workflow Automation For Personnel Planning