|
#1
|
|||
|
|||
Calculating Threads_very slow on calculation
Hi, I have a large data file roughly about 18,000,000 lines. I put in a vlookup function and it took around 15 mins to calculate. When I tried to save the work book, the calculating threads start again. Is there a way to resolve this issue please? Thank you |
#2
|
|||
|
|||
Sorry it's not 18,000,000 lines but 18,000 lines instead.
|
#3
|
|||
|
|||
It depends on you table(s) structure(s), and on your formula. My advice is, post a copy of your workbook with a minimal amount of [mocked up] data (enough of it to get the formula working), and with your formula, here. Without this info, nobody can advice anything!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sum not calculating automatically | Mark Turner | Excel | 1 | 10-15-2019 03:02 AM |
Calculating Tax in Word Doc | DORFER | Word | 4 | 12-21-2016 08:21 PM |
Slow internet = Slow Word... | User12344321 | Word | 4 | 09-21-2015 12:54 PM |
earned value not calculating | ketanco | Project | 3 | 08-16-2012 02:13 PM |
Calculating dates | Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |