Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 11-07-2022, 04:03 PM
AP41-at-OfficeFORUM AP41-at-OfficeFORUM is offline A 20k lines Sheet calculation takes 1,23 hours!! Windows 10 A 20k lines Sheet calculation takes 1,23 hours!! Office 2019
Novice
A 20k lines Sheet calculation takes 1,23 hours!!
 
Join Date: May 2021
Location: Italy
Posts: 23
AP41-at-OfficeFORUM is on a distinguished road
Default

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
Attached Files
File Type: xlsx P45cal-SAMPLE-last-.xlsx (463.7 KB, 8 views)
File Type: xlsx Fjns-new21000rows4digits.xlsx (450.5 KB, 7 views)
Reply With Quote
 



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
A 20k lines Sheet calculation takes 1,23 hours!! 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
A 20k lines Sheet calculation takes 1,23 hours!! Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft