I've got an Excel file (which has data set up from Power Query) which has 5 sheets, and one of the sheets with 300,000 plus rows. The data in the sheets has been formatted as a table. It's driving me nuts because it takes ages to open, everything takes ages and if I update any formula, it throws a tantrum and then I have a hissy fit :-) I'm currently storing the file in OneDrive. Any suggestions on optimising what I am doing? It's 32 bit Excel Thank you as always.