I am trying to use a desktop computer with Windows 8.1 and am getting an error message when trying to copy cells from one tab to another in Excel 2010. I do not have the problem on my Win 7 laptop or a different Win 7 desktop.
I have a spreadsheet with a pivot table that I refresh weekly from an Access database. Each week I create a new tab by right clicking on the previous week's tab and selecting Copy. After renaming the new tab with the date, I go back to the previous week's tab, click the top left corner of the spreadsheet so that the entire sheet is selected, right click, select Copy, and then Paste Values. The last step prevents the previous week's data from getting updated when I refresh the pivot table on the current week's tab. There is no problem doing this with the exact same file on my Win 7 laptop or Win 7 desktop. It only happens on the Win 8.1 desktop. I initially had Office Pro 32-bit on the Win 8.1 desktop but I uninstalled it and installed the 64-bit version hoping that would resolve the issue, but it has not. The problem occurs when I select Copy - I get the message: Excel cannot complete this task with available resources. Choose less data or close other applications. This happens after a reboot with no other applications open. Also as I mentioned above it happens with 32-bit and 64-bit Excel.
My laptop has Win 7 SP1 64-bit, 6 GB RAM and Office 2010 Pro 32-bit. My desktop that works has Win 7 SP1 32-bit, 4 GB RAM and Office 2010 Pro 32-bit. The Win 8 desktop has Win 8.1 Pro 64-bit, 12 GB RAM and Office Pro 64 bit.
I hope I have provided enough detail to get some help with this issue. Thanks for your help.