Link to home
Start Free TrialLog in
Avatar of agwalsh
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
Avatar of Alan
Alan
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agwalsh
agwalsh

ASKER

Brilliant! Am going to take all these on board...I do *love* Excel except when it starts doing this sort of crap :-)  @Roy Cox - any issues/limitations I should be aware of around saving as an xlsb? @Neil Fleming, have no UDFs in the file - just a dump from Power Query...@Alan - am going to move entire file to a different machine. Thanks for all the advice.
Avatar of agwalsh

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