Forum Discussion
Excel can't handle big data
We are trying to organize a project with ten sheets on one file and fourteen on another and Excel won't let me do something as simple as copying and pasting columns from one file to another. Maybe th...
Sorry to hear about your bad experience. I don't think it should make much of a difference, but have you tried using power pivot? Power Pivot allows you to use more rows than the maximum allowed in Excel, it may be worth giving it a try in this case.
Hi Zachary,
I didn't catch the idea, how Power Pivot could help with copy/paste from one worksheet to another?
- My suggestion was referring to the fact that PowerPivot can handle up to 1,999,999,997 rows, as opposed to Excel's limit of 1,048,576. This can be seen here: https://msdn.microsoft.com/en-us/library/gg413465(v=sql.110).aspx
I don't think that Powerpivot was the solution to copy and paste, but was giving him a second option to see if it might work better. In my experience, Powerpivot is leaner than Excel and can thus work faster. Since his computer was working very slowly, I though it may be worth giving it a try.Yes, but Power Pivot is analysis only tool which is not instead of Excel sheet, it's on the top of it. As for the performance it very depends on how the data model is built.
- Thanks for clarifying