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
|