I am creating an excel document that is pulling data from an Excel Pivot Table. When attempting to copy a tab over I've been receiving several error messages. The tab that I am trying to copy over has 4791 rows and 122 columns. I've tried right click tab and copy over, that didn't work. I tried to manually copy and paste on a new sheet and that didn't work either.
The error messages I've been receiving are...
- Excel cannot complete this task with the available resources. Choose less data or close other applications.
- Excel cannot complete this task with the available resources. Choose less data or close other applications. Continue without Undo?
- An unexpected error has occured. AutoRecover has been disabled for this session of Excel.
- Not enough system resources to display completely.
- The operation you are about to perform affects a large numbe rof cells and may take a significant amount of time to complete. Are you sure you want to continue? Note: This operation will be performed automaticaly in 60 seconds if no response is received.
I initally began working on this on Excel 2007 on an intel Core 2 duo Windows XP, which is on my companies Network. Then, I took the worksheets and put them on my personal laptop, which is Windows 7/Intel Core i7 and Excel 2007.
Should I use something other than Excel to perform the needed task or do I need more memory?
