Can file size alone (even when data is hardcoded) contribute to slow performance?

[d0rian]

I've spent a lot of time trying to optimize my workbook (which streams in a high-volume of real-time stock quotes) for speed, e.g.: (i) getting rid of resource-hogging dynamic functions, (ii) and particularly hardcoding values wherever possible (with macros that calculate formulas and then paste their values) so that I don't have unnecessary formulas constantly calculating in the background. Performance still not great, and wondering whether the mere fact that my file size is still large (7.5MB) can contribute to the lag. A few worksheets still have ~15,000 rows of data, and even though it's nearly entirely hardcoded data (and there aren't any active INDEX or LOOKUP formulas that are referencing those large data tables), can the mere fact that it's there and the file size is large contribute to slower performance?

 

[Zack Barresse]

Are you using Tables or is the data just on the grid? Tables can become clunky and slow, regarding both size and performance.