This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Data is approximately 75K lines of data. Using no macros or formulas. Have created two pivot tables.
Get to a point in editing the file where I receive a large operation message indicating the operation includes a large number of cells and to make a smaller selection. This is followed by an error indicating the task cannot be completed with available resources. I may only have selected one row and Excel may be the only program open. Makes no difference.
I've run diagnostics and have also tried using the open and and repair option. The pc was only issued (work) about 10 days ago.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
"The operation you are about to perform affects a large number of cells and may take a signficant amoun ot time to complete"
Then I get an error "Excel cannot complete this task with available resources"
For now, you may to copy all your text from a sheet to another one.
I don't know why is this happen, but this is a way to solve problem with document.
Cheers
I have exactle the same problem in my file just occur now. Where you able to resolve this? Cannot insert row.
Provide the exact error message in order to assist you better.
Also create a new test file, perform the same operations and verify the status.