operation you are about to perform affects a large number of cells (when inserting a row)

K

kxkxkxx

New Member
Joined
Nov 27, 2013
Messages
10
Posting for my co-worker....she has a fairly large excel workbook, main tab feeds 3 other tabs. The main tab has 5,000+ rows.

She tried to insert a new row by highlighting the entire row and also tried just highlighting the cells and inserting, both times she got this error message.

http://tinypic.com/view.php?pic=2mq0w9s&s=9#.WpW032rwbeM

any help is appreciated.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Similar threads

S
  • Solved
VBA | Comparing Two Cell Values on Separate Sheets, Then Iterating by Row
Replies
3
Views
529
DanteAmor
DanteAmor
S
  • Solved
Seperate Data In One Cell Across Multiple Cells
Replies
6
Views
2K
Alex Blakenburg
A
G
  • Question Question
Excel VBA Macro steps through ok but when run it causes duplication
Replies
2
Views
4K
Gassy
G
A
  • Question Question
Insert Row based on Cell contents and copy data from Row above and paste data from another tab
Replies
0
Views
948
Andyjk1984
A
zookeepertx
  • Question Question
I THINK a worksheet change event is in order, but there might be a better way
2
Replies
12
Views
2K
Eric W
Eric W

Forum statistics

Threads
1,224,823
Messages
6,181,185
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top