Been searching around and it seems folks are pretty split. Figured I would see what you all say.
I am in the process of building out a workbook that unfortunately has to fit a pre-determined visual layout (thanks sales). As a result I will have one large database worksheet that will continue to grow with time, and multiple worksheets referencing this data. As of now that would amount to roughly 5k formulas referencing the data, and that will grow with each new year. In the hopes of minimizing inefficiencies, I was wondering what would be the best setup for the database worksheet. Just reference the data via a dynamic named range utilizing index/match, or have that database built as a table. Are the differences between the two significant enough to notice, or are they close enough either is fine? Any info is greatly appreciated!!