Excel Error -Excel cannot complete this task with available resources. Choose less data or close other applications. Continue with Undo?"

[Geeta2014]

this occurs when copying and pasting from one worksheet to another worksheet (impossible for me to confirm but I strongly believe the sheet being copied from was created in 2003 Version and is being pasted into file created in 2010 Version - if that matters. Also integrated with a database.

Is there somewhere I can find a list of ALL the possibilities that can generate this error? I noticed someone else asked this question on this board a few years ago but no one responded.

"Excel cannot complete this task with available resources. Choose less data or close other applications. Continue with Undo?"

It is very unlikely this error has anything to do with available memory.

 

[RoryA]

It is very unlikely this error has anything to do with available memory.

Based on what?

Are you using 64bit Excel, or 32bit?

 

[Geeta2014]

32-bit

 

[RoryA]

So on what do you base your statement that it is unlikely to do with available memory? Have you checked to see how much memory the Excel process is using at the time (given that 32 bit Excel is limited in how much memory it can access, regardless of available RAM)?

 

[Geeta2014]

I used larger files containing similar functions to re-test. Unfortunately, for this file, I am not allowed to look at it. So, I am not able to watch the memory process - its why i wanted to know if there is a list somewhere that says what items can cause this. I won't be surprised if someone added borders to every single cell (used or unused) within this workbook - (Don't ask! : ))