Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2022, 10:59 AM
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

Dear Fjns, I've noted that apparently you gave me the same function as suggested previously, but this time the 20k lines calculation went surprisingly and satisfactorily fast:
2 seconds by changing the minimum selection limit value, 4 minutes to eliminate or insert a line, also 4 minutes to change a formula in a cell! Which factor has triggered such a beautiful result will remain for me a distressing mistery! Yet the solution of this very penalizing problem of mine make me greatly happy. ... also the solution suggested by P45cal worked equally fast ... therefore a very very very big thank to both. Your grateful AP
Reply With Quote
Reply



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 12:11 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