Using Excel to deal with a more than 40000 of the 2007 form, in the form of the first row or column added, a "lack of available resources, Excel to this task, please reduce some data or shut down other applications" error, including the form, paste copied more
Has taken to replace the version of office, and change the virtual memory, clear clipboard operations, but still can't solve this problem,
Seek and advice solution,

CodePudding user response:

Please try the following method can solve the problem:

1. Remove all screening function temporarily, and eliminate all formats (if allowed)
2. Copy the file to the system partition again after operation
3. Save the file as.xls
4. Use the original version Office2013 or 2016
5. The temporary closure of firewall and antivirus software

CodePudding user response:

Change is the most convenient computer

If they were not, try looking for array formula, to correct them,
Or have a choice of the whole column formula, to a limited area