A 20k lines Sheet calculation takes 1,23 hours!!

AP41-at-OfficeFORUM · #1 11-07-2022, 04:03 PM

hi, P45cal, I find it difficult to understand what happens on my PC, an Acer Aspire with an I7-5500u and 8GB ram ... your solution depending on type of changes sometimes works sometimes not ... e.g. when I try to modify the filter limit o to free the first line to insert a description. Due to limits for uploadable files I re-attach only a small part of the real file (6,5 GB) with your solution ... , can you please verify yourself? thank you.
Dear Fjns, the same happens with your solution with the full 20k lines file ... also for you re-attached part of related file (8GB). You not being able to see the real file will probably make useless any effort to solve the problem ... try to increase yourself the file up to 20k lines ... and hope to identify the problem and solve it ... In any case, Thank you both very much for your help. AP

fjns · #2 11-08-2022, 03:24 AM

Hi, 10000 cells are required in columns J-K regardless of the other columns.

p45cal · #3 11-13-2022, 07:20 AM

Quote:

Originally Posted by AP41-at-OfficeFORUM

sometimes works sometimes not ... e.g. when I try to modify the filter limit o to free the first line to insert a description.

I'm not sure what you mean by this statement?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to adjust Project Duration for Summer and Winter Hours - based on number of hours per day	Lou C	Project	2	10-03-2021 09:35 AM
Complicated calculation of hours worked	APreston	Excel	1	05-09-2016 04:42 AM
Very complicated calculation of total hours worked (PLEASE HELP)	APreston	Excel	1	05-08-2016 02:58 AM
Complex calculation from multiple sheets to master sheet	inreality01	Excel	49	01-06-2016 03:09 PM
Help with 'hours worked' calculation...	Snvlsfoal	Excel	1	08-11-2011 05:54 AM