If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scrollbar Problem
Hi, I'm having the age-old problem of having a billion rows on my worksheet for some reason (44327 to be exact), when this particular sheet only uses 263 rows. I've searched for solutions and already tried both the manual and the macro solutions at www.contextures.com and niether are working. Any idea why / another solution? I've tried deleting the rows in every way I can think of... it's just not working.
|
#2
|
|||
|
|||
Scrollbar Problem
Hi
the solutions describe in the website www.contextures.com work. Have you saved directly after deleting the rows and closed the Excel file? -- Regards Frank Kabel Frankfurt, Germany The Wonder Thing wrote: Hi, I'm having the age-old problem of having a billion rows on my worksheet for some reason (44327 to be exact), when this particular sheet only uses 263 rows. I've searched for solutions and already tried both the manual and the macro solutions at www.contextures.com and niether are working. Any idea why / another solution? I've tried deleting the rows in every way I can think of... it's just not working. |
#3
|
|||
|
|||
Scrollbar Problem
It won't even let me delete the rows. It's giving me a "cannot shift objects off sheet" error.
"Frank Kabel" wrote: Hi the solutions describe in the website www.contextures.com work. Have you saved directly after deleting the rows and closed the Excel file? -- Regards Frank Kabel Frankfurt, Germany The Wonder Thing wrote: Hi, I'm having the age-old problem of having a billion rows on my worksheet for some reason (44327 to be exact), when this particular sheet only uses 263 rows. I've searched for solutions and already tried both the manual and the macro solutions at www.contextures.com and niether are working. Any idea why / another solution? I've tried deleting the rows in every way I can think of... it's just not working. |
#4
|
|||
|
|||
Scrollbar Problem
here's a link to a kb article that's kind of close.
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 do you have shapes/comments on your worksheet? and another link: http://google.com/groups?threadm=1c4...0a %40phx.gbl The Wonder Thing wrote: It won't even let me delete the rows. It's giving me a "cannot shift objects off sheet" error. "Frank Kabel" wrote: Hi the solutions describe in the website www.contextures.com work. Have you saved directly after deleting the rows and closed the Excel file? -- Regards Frank Kabel Frankfurt, Germany The Wonder Thing wrote: Hi, I'm having the age-old problem of having a billion rows on my worksheet for some reason (44327 to be exact), when this particular sheet only uses 263 rows. I've searched for solutions and already tried both the manual and the macro solutions at www.contextures.com and niether are working. Any idea why / another solution? I've tried deleting the rows in every way I can think of... it's just not working. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|