# Why MS-Excel is got slowed down when there is large data sets?

When I use excel sheets for very large data set, it goes slow down. But work very fine for small to medium data sets.

##### Post Metadata
- Posted at: over 6 years ago
- Author title: SAP S/4 HANA Certified Sourcing and Procurement Consultant| Lead Consultant at Wipro Ltd | Ex TCSer | Ex Infoscion
- Net upvotes: 1


## Comments
### Comment 1

Usually excel is supposed to take on large data sets, but in some cases it does slow down. Inline the 32 bit version, the 64 bit is not RAM constrained. Slow down does happen though if you use too many formulas or complex calculations. If you have too many sum products or auto calculations, you might be recalculating on every step, hence the slowdown. It could also be because you are linking the sheet to external sources. 

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Team Lead / Business Consultant at Accenture Interactive




## Related Product
[Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews)

## Related Category
[Spreadsheets](https://www.g2.com/categories/spreadsheets)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4