I have a spreadsheet that, after running Subtotals from the Data menu,
returns the error message quot;Cannot shift objects off sheetquot; when I try to
condense the spreadsheet. There are no comments on the spreadsheet. I
selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
text. After running Subtotals, there are a total of 2,374 roows. What gives?
--
I know enuff to be dangerous.
Another possibility is that you might already have the maximum number of
columns (not rows). Hit Ctrl End and see where you end up. If it is in
column IV, there is the problem--remove any unneeded columns.
quot;RealGomerquot; wrote:
gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; --
gt; I know enuff to be dangerous.
Actually, I got myself turned around in my initial response. Try Ctrl End
and see what row you end up in. You may have something in the last possible
row (possibly a space in a cell). Also see if, by removing several rows, you
can add subtotals.
quot;RealGomerquot; wrote:
gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; --
gt; I know enuff to be dangerous.
Did you solve your problem, if so please tell me what to do. I have the same
error .
quot;RealGomerquot; wrote:
gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; --
gt; I know enuff to be dangerous.
Did anyone solve this problem?
I have exactly the same issue - I have checked the end of the spreadsheet
and its not in column IV. I have also deleted all rows and columns beyond the
range of the sheet but still get the error mesage.
Interestingly I still get the error message when I try to hide a column.
Also is the mention of quot;objectsquot; significant?
quot;Louquot; wrote:
gt; Did you solve your problem, if so please tell me what to do. I have the same
gt; error .
gt;
gt; quot;RealGomerquot; wrote:
gt;
gt; gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; gt; --
gt; gt; I know enuff to be dangerous.
I've got that same problem when I try and hide columns. Having so much
trouble sorting it! gt;_lt;
quot;hackneymnquot; wrote:
gt; Did anyone solve this problem?
gt; I have exactly the same issue - I have checked the end of the spreadsheet
gt; and its not in column IV. I have also deleted all rows and columns beyond the
gt; range of the sheet but still get the error mesage.
gt; Interestingly I still get the error message when I try to hide a column.
gt; Also is the mention of quot;objectsquot; significant?
gt;
gt; quot;Louquot; wrote:
gt;
gt; gt; Did you solve your problem, if so please tell me what to do. I have the same
gt; gt; error .
gt; gt;
gt; gt; quot;RealGomerquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; gt; gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; gt; gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; gt; gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; gt; gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; gt; gt; --
gt; gt; gt; I know enuff to be dangerous.
returns the error message quot;Cannot shift objects off sheetquot; when I try to
condense the spreadsheet. There are no comments on the spreadsheet. I
selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
text. After running Subtotals, there are a total of 2,374 roows. What gives?
--
I know enuff to be dangerous.
Another possibility is that you might already have the maximum number of
columns (not rows). Hit Ctrl End and see where you end up. If it is in
column IV, there is the problem--remove any unneeded columns.
quot;RealGomerquot; wrote:
gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; --
gt; I know enuff to be dangerous.
Actually, I got myself turned around in my initial response. Try Ctrl End
and see what row you end up in. You may have something in the last possible
row (possibly a space in a cell). Also see if, by removing several rows, you
can add subtotals.
quot;RealGomerquot; wrote:
gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; --
gt; I know enuff to be dangerous.
Did you solve your problem, if so please tell me what to do. I have the same
error .
quot;RealGomerquot; wrote:
gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; --
gt; I know enuff to be dangerous.
Did anyone solve this problem?
I have exactly the same issue - I have checked the end of the spreadsheet
and its not in column IV. I have also deleted all rows and columns beyond the
range of the sheet but still get the error mesage.
Interestingly I still get the error message when I try to hide a column.
Also is the mention of quot;objectsquot; significant?
quot;Louquot; wrote:
gt; Did you solve your problem, if so please tell me what to do. I have the same
gt; error .
gt;
gt; quot;RealGomerquot; wrote:
gt;
gt; gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; gt; --
gt; gt; I know enuff to be dangerous.
I've got that same problem when I try and hide columns. Having so much
trouble sorting it! gt;_lt;
quot;hackneymnquot; wrote:
gt; Did anyone solve this problem?
gt; I have exactly the same issue - I have checked the end of the spreadsheet
gt; and its not in column IV. I have also deleted all rows and columns beyond the
gt; range of the sheet but still get the error mesage.
gt; Interestingly I still get the error message when I try to hide a column.
gt; Also is the mention of quot;objectsquot; significant?
gt;
gt; quot;Louquot; wrote:
gt;
gt; gt; Did you solve your problem, if so please tell me what to do. I have the same
gt; gt; error .
gt; gt;
gt; gt; quot;RealGomerquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet that, after running Subtotals from the Data menu,
gt; gt; gt; returns the error message quot;Cannot shift objects off sheetquot; when I try to
gt; gt; gt; condense the spreadsheet. There are no comments on the spreadsheet. I
gt; gt; gt; selected all cells and pressed quot;Deletequot;. The susbtotal range is below any
gt; gt; gt; text. After running Subtotals, there are a total of 2,374 roows. What gives?
gt; gt; gt; --
gt; gt; gt; I know enuff to be dangerous.
