We currently are using an legacy Excel workbook created over 14 years ago. It has many macros as well as formulas. It's used as an estimating tool for our large commercial masonry construction business. Is this something that in time will blow up on us and become obsolete? We are using it today as I stated with no issues. Is this something we need to be concerned about?
Thanks
If it ain't broke, don't fix it.
Microsoft has been known to "depreciate" some of their features from time to time. Usually, these are not widely-used functions. I have a lot of legacy stuff myself (back to pre-2010 - these are XLS files). I have not run into any issues. There are some functions that have been replaced with better (E.g. XLOOKUP vs. VLOOKUP and SUMIFS instead of SUMPRODUCT and array formulas) but the former are still supported.
From a VBA standpoint, I have code written in 2006 that still works.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
I agree with dflak. However, it might be worth looking into updating the file simply because there are newer, more efficient formulas available in later excel versions.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, at least update the file to XLSX, XLSM or XLSB as appropriate.
If I had to pick any target for replacement, it would be array formulas: they can generally be replaced with SUMIFS, COUNTIFS, AVERAGEIFS ... etc.
Array formulas eat up resources and runtime.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks