agwalsh
asked on
Large Excel file - takes ages to open, or do anything with.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It's always the simple things isn't it? Great advice as always..
There are no issues with .xlsb, it would be interesting to know if it performs better before moving. Pleased to help
ASKER