Quote Originally Posted by Elijah View Post
Unless it's the sheer total size of this new linked table which is the main problem and that splitting them up would help regardless of the total being greater?

Okay. This is interesting (please don't remove the quote, Ali, as it is necessary).

On this new workbook which takes 15 seconds to load I decided to split this new linked table in two such that it's similar to the original workbook:

The result: Load time = 10 seconds , i.e., 5 seconds faster than 1 linked table.

How can this be?

The only answer I can think of is that total table size per table is what matters.

It still does not explain why my new workbook is 6 seconds slower than my original as the content is the same...

I also tried to remove all conditional formatting from the entire workbook and it amounted to pretty much nothing.