You are reading a single comment by @Sam_w and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Sam_w
NurseHolliday
I find xlsb only speeds up opening (and shrinks the file) it doesn't actually speed up operations within it.
Another killer for calculation speed is vlookups.
If it's a long-term thing and the data is just going to get bigger it may be worth looking at PowerPivot. It's relatively simple to learn the basics and is a lot faster. Definitely more complicated though.