Cut & Paste Performance Issues

[MatrixUSA]

Using Excel 2007 in Vista w/4G RAM w/Intel Dual Core.

Getting "Not Enough System Resources" or continuous delay when trying to copy a full page of heavly formatted investment data to a new sheet. Avail mem at 60% when making attempt to copy data to new sheet.

Possible issues and solutions appreciated.

 

[Weaver]

I guess you could try copying it in chunks - maybe a few columns at a time?

 

[MatrixUSA]

Thanks for the info.

I have started to copy the values first, and then copy the formattting afterwards to solve the problem. I tried increasing the Virtual Disk size but that didn't solve the problem. Does Excel 2007 perform better in Windows 7 ?

 

[Weaver]

Thanks for the info.

I have started to copy the values first, and then copy the formattting afterwards to solve the problem. I tried increasing the Virtual Disk size but that didn't solve the problem. Does Excel 2007 perform better in Windows 7 ?

Not having used xl2007 in any other environment than win7, I don't know for sure, but it wouldn't surprise me at all.

 

[MatrixUSA]

Thanks