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...
Hi Eric,
Dozen of sheets and few thousands of rows is not big data for Excel, if only you don't have few megs of text in each cell. Most probably the problem is not with clipboard buffer size, something else which could be found only with real data in actual environment. That could be related to Windows search index (try to rebuild it), temporary files (remove all), hardware acceleration (on laptops, switch off), network shared files, whatever.
First questions here are do you have same effect on all available computers or you didn't try; is the same effect for safe mode (Win+R=>excel /safe) or not; how your resources are consuming during copy/paste based on at least Task manager or better Resource monitor,...