View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Inserting Rows with tabs grouped

Have you tried inserting to one tab at a time?

If one tab causes you the error, you can narrow down that way. It's
possible that one tab is using all rows to 65536.

Typically, attempting to add a row to this sheet would return an error
unable to shift rows off sheet, though I don't know how Excel would react if
multiple tabs are grouped and this occurs...

"AndrewEdmunds" wrote:

Hello,

I am working with Excel 2003. In one of my workbooks I have grouped all
tabs and then tried inserting rows (so that the rows would insert on all
tabs). Everytime I try it, the file automatically says that there is an
error and shuts down. I have tried the same thing in my other excel files
and it works just fine. I also checked to see if I had any data on the last
row on each tab and there was nothing. Would someone know why this is
happening? Also, I tried just adding data to a cell with all tabs grouped
and it worked fine.

Thanks,
--
Thank You
Andrew Edmunds