Can't insert rows in excel 2007

[daniel2008]

Hi,

I'm trying to insert rows in a large spreadsheet in excel 2007 (row limit not exceeded though)... When I try to insert rows I have started getting the error message: "excel cannot complete this task with available resources. Choose less data or close other applications"

Does anyone know how I can resolve this?

 

[BrandonWLH]

Its telling you that you don't have the resources. Its not trying to fool you.

How many rows are you inserting?
How much data is in there rows?
Are you running a ton of programs at once?
Whens the last time to rebooted the PC and attempted to insert the rows?
You check task manager and see what the memory usages of Excel is and your PCs available memory?

 

[daniel2008]

only trying to add a few rows.... its possible towards the bottom of the sheet - butnot near the top

 

[RSXchin]

don't know if it'll help, but try changing the calculation to manual first. insert the rows, then change it back to automatic.

 

[BrandonWLH]

How many rows are you inserting?
How much data is in the rows? Are they blank inserts? Are you Copy Inserting?
How much data is in the spreadsheet your working on?
Are you running a ton of programs at once?
Whens the last time to rebooted the PC and attempted to insert the rows?
You check task manager and see what the memory usages of Excel is and your PCs available memory?