Hi all, looking for some feedback and advice. Amazon has $50 off Office 2016 H&S tomorrow and I'm thinking of upgrading my 2007 version. I'm mainly interested in RDBMS capabilities to improve (VBA) lookup performance and data integrity in large lists (100K+ rows).

I would also hope for general performance improvements, e.g. in 2007 I have to clean up frequently to recover ability to insert rows, and lose Undo/Redo when moving relatively small amounts of data (despite running on a 16GB Core i7 box).

My app has outgrown Excel 2007 a bit but I don't want to rebuild it in Access or another platform - I'm hoping a 3-version jump in Excel will streamline things enough, and provide a lot of other worthwhile improvements...

Thanks,