Prev: counting part numbers
Next: Search end/beginning of cell
From: Elgee on 28 Apr 2010 16:49
Thansk Bob - but - I get the same errors......

"Bob I" wrote:

> 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?!!?
>
> .
>
From: Bob I on 29 Apr 2010 09:00
Humm, perhaps r-click the worksheet tab and Copy the sheet to a new
workbook. Then see if the error is gone.

Elgee wrote:

> Thansk Bob - but - I get the same errors......
>
> "Bob I" wrote:
>
>
>>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: counting part numbers
Next: Search end/beginning of cell