Excel Spreadsheet running slow

[Skeen]

Does anyone know how to speed up an excel file? I have a lot of data that is running with several formulas, but I don't feel it should be this slow. I have other documents with more info that doesn't run this slow...

 

[Richard U]

Turn off automatic calculations.

1.Click the File tab, click Options, and then click the Formulas category.
2.Click on manual under "workbook calculation"

Click on "calculate" on the bottom of your sheet after making changes

 

[Skeen]

I've tried that and it didn't help any, I've also removed all of the formatting, still being extremely slow and spinning.

 

[sandy666]

post a link to this shared file

 

[Skeen]

How would I do that?

 

[sandy666]

How would I do that?

What?

shared link?

use GoogleDrive, OneDrive or any similar, share file , copy link to the post

 

[Skeen]

OneDrive - Macy's, Inc called Inventory Adjustment Audits

 

[sandy666]

OneDrive - Macy's, Inc called Inventory Adjustment Audits

????????????????????????????????????????????????

 

[Skeen]

I'm not sure what happened lol. I have the below formulas in 4 different columns, I have 27 columns and 11000 rows, but the rows will change. The spreadsheet is pulled from a report and I am determining whether locations or cases need to be audited based off if the units or $$$ match. I am also trying to get the count if formula not to show true or false but "Audit" if it would be false.

=IF(SUMIFS(S:S,$A:$A,$A4,B:B,$B4,AA:AA,AA4)+SUMIFS(U:U,$A:$A,$A4,B:B,$B4,AA:AA,AA4)>=500,"Audit",IF(SUMIFS(S:S,$A:$A,$A4,B:B,$B4,AA:AA,AA4)+SUMIFS(U:U,$A:$A,$A4,B:B,$B4,AA:AA,AA4)<=-500,"Audit",IF(SUMIFS(R:R,$A:$A,$A4,B:B,$B4,AA:AA,AA4)+SUMIFS(T:T,$A:$A,$A4,B:B,$B4,AA:AA,AA4)>=100,"Audit",IF(SUMIFS(R:R,$A:$A,$A4,B:B,$B4,AA:AA,AA4)+SUMIFS(T:T,$A:$A,$A4,B:B,$B4,AA:AA,AA4)<=-100,"Audit",""))))

=IF(SUMIFS(S:S,$A:$A,$A4,B:B,$B4,D:D,D4)+SUMIFS(U:U,$A:$A,$A4,B:B,$B4,D:D,D4)>=500,"Audit",IF(SUMIFS(S:S,$A:$A,$A4,B:B,$B4,D:D,D4)+SUMIFS(U:U,$A:$A,$A4,B:B,$B4,D:D,D4)<=-500,"",IF(SUMIFS(R:R,$A:$A,$A4,B:B,$B4,D:D,D4)+SUMIFS(T:T,$A:$A,$A4,B:B,$B4,D:D,D4)>=100,"Audit",IF(SUMIFS(R:R,$A:$A,$A4,B:B,$B4,D:D,D4)+SUMIFS(T:T,$A:$A,$A4,B:B,$B4,D:D,D4)<=-100,"Audit",""))))

=IF($A4="RV",IF(ISERROR(VLOOKUP(V4,'RV Adjustments'!A:B,1,FALSE)),"Check Adjustment",$A4),"")

=COUNTIF('RV Adjustments'!E1:E9,A4)=0

 

[sandy666]

don't use ranges type: A:A , define range like: A1:A1000 and it will increase excel speed