Pivot using 250,000 rows of data in Excel?
- Thread starter cac
- Start date
Becky
Webmistress
- Joined
- Mar 25, 2003
- Messages
- 7,424
- Reaction score
- 1,511
Hello and welcome to PCR 
Microsoft have a handy guide for the limits of Excel - choose which version of Excel you are using at the top, and scroll down to the Pivot Table section.
https://support.office.com/en-us/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3
TL;DR - it should be fine as long as you have enough memory available.
Microsoft have a handy guide for the limits of Excel - choose which version of Excel you are using at the top, and scroll down to the Pivot Table section.
https://support.office.com/en-us/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3
TL;DR - it should be fine as long as you have enough memory available.