Prev: How do you link list boxes
Next: counting part numbers
From: Elgee on 28 Apr 2010 15:45
Help! I was so excited to have '07 until...
I have a very simple worksheet in a work book -
This very simple worksheet takes up 78 rows and 16 columns. Minimals
formats / formulas etc.
I would like to insert additional rows but I get the error message which
says "Large Operation. The operation you are about to perform affects a
large # of cells and may take a significant amount of time to complete. Are
you sure you want to continue? Note: This operation will be performed in 60
seconds if no response is received".
I have tried to select "OK" as well as wait until my 60 seconds are up - and
then I get this error message: "Excel cannot complete this task with
available resources. Choose less data or close other applications".
I only have MS Office document open and that is this one - in addition to
Lotus Notes and 1 IE window.
Is this bizarre or what?!!?
From: Bob I on 28 Apr 2010 16:08
Perhaps Goto Last Cell and see where the sheet really ends, then delete
the rows of nothing.

Elgee wrote:

> Help! I was so excited to have '07 until...
> I have a very simple worksheet in a work book -
> This very simple worksheet takes up 78 rows and 16 columns. Minimals
> formats / formulas etc.
> I would like to insert additional rows but I get the error message which
> says "Large Operation. The operation you are about to perform affects a
> large # of cells and may take a significant amount of time to complete. Are
> you sure you want to continue? Note: This operation will be performed in 60
> seconds if no response is received".
> I have tried to select "OK" as well as wait until my 60 seconds are up - and
> then I get this error message: "Excel cannot complete this task with
> available resources. Choose less data or close other applications".
> I only have MS Office document open and that is this one - in addition to
> Lotus Notes and 1 IE window.
> Is this bizarre or what?!!?

 | 
Pages: 1
Prev: How do you link list boxes
Next: counting part numbers