Which Formulas are Slowing Down my Sheet?

The_Snook, thank you. Now that you mention it, I do remember that rule of thumb. What do you recommend? Creating dynamic named ranges? Or is there a way to say "look in this row as far as the table it is in extends"?

TMS, I think you are on to something. Yes, I just tried opening this sheet with the source sheet open and it loaded instantly. Is there anything that can be done to increase the speed with the source workbook closed?

My thanks to you both for the help so far!

Originally Posted by shirleyxls

If you create a named range based on column(s) in the table, that range will always extend to the last row of the table. Useful for data validation lists too

Aha, very good to know.

What about for pivot tables? I realized that in order to make a dynamic named range for pivot tables, I end up using a helper cell that references an entire column anyway... COUNTA(A:A)-3... minus 3 for the pivot report filter, column title and grand total. That gives me the dynamic figure that I put in my OFFSET named range formula to know how far to go down. So if I'm using a full column reference anyway, I don't think I'm speeding anything up.

Thanks!