Slow Excel Spreadsheet

Question

Hi guys&nbsp;I have a couple of big lists like the below where each cell has a defining name cell reference against it which is making my spreadhsheet super slow. Is there a way to speed up my spreadsheet like saving it as a different file? Its currently saved as a&nbsp;Microsoft Excel Binary Worksheet (.xlsb).&nbsp;

nikolinode · Answer

jonoross&nbsp;how long has the file been around or since when has it been added / changed?why xlsb / xlsm if no macros in it?Ever tried to create this file again?How many volatile functions are used?(Volatile functions are functions whose results are permanently recalculated).Volatile functions are:OFFSET, TODAY, INDIRECT, RANDBETWEEN, etc.However, if you use complex, extensive calculation models, the performance could noticeably deteriorate when using the functions mentioned. You should just keep in mind that this problem exists and that in the event of performance problems (among other things) you should look specifically for volatile functions and replace them with alternatives if possible.&nbsp;Of course, inserting the file (please, without sensitive data) would help a lot to determine more precisely where it comes from.Excel version and operating system would be an advantage.I hope that I could help you with this information in your projects.&nbsp;&nbsp;&nbsp;I would be happy to know if I could help.&nbsp;NikolinoDEI know I don't know anything (Socrates)

jonoross · Answer

Hi NikolinoThanks for your response. Is it okay if I send it to your personal email as the spreadsheet is case sensitive. I am happy to pay for you to have a look and make any amendments necessary. My email is jonoross@outlook.comThanks

nikolinode · Answer

jonoross&nbsp;Thank you in advance for your trust, I will have a look at it in the next few days if my time allows and inform you accordingly. For your information, I never take any money for the help I have provided(... otherwise it would not be of any help). Do my best to help people here in the sense of helping people to help themselves. Sometimes my best is enough and sometimes not :), that's why there are much better specialists here than me. Anyway, if you send it to me I'll try to give you a concrete solution ... or not :)). &nbsp;* You can send me your file here in the forum as a private message. Just click on my name and a "Message" button will appear in the top right corner. &nbsp;Will keep you updated when the time comes :).&nbsp;Thank you for your understanding&nbsp;NikolinoDEI know I don't know anything (Socrates)

jonoross · Answer

Hi NikolinoSorry for the delay. I'm just thinking about it

Forum Discussion

Slow Excel Spreadsheet

4 Replies

Resources