Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GreenInIowa
 
Posts: n/a
Default Why I am getting Error Message: "Cannot shift objects off sheet"??

Hi,

I have monthly data in columns from 1990 to 2005. I also have an annual
column which shows the total of 12-months data as summary. I grouped them
through (DataGroup and OutlineGroup) so that I can observe only annual
values by collapsing the monthly numbers with (+).

My problems is that for some reason some of the grouped columns do not
collapse and gives me this "Cannot shift objects off sheet" error although
some of the groups work just fine.

I was wondering why? Thanks.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot shift objects off sheets Bob Phillips Excel Worksheet Functions 1 March 6th 06 10:26 PM
Cannot Shift Objects off sheet Norman Jones Excel Worksheet Functions 0 January 26th 06 01:45 AM
Error Message: "Cannot shift objects off sheet." AndrewS Excel Discussion (Misc queries) 1 January 11th 06 05:09 PM
What does the message: "Cannot shift objects off sheet" mean? CTruesdale Excel Worksheet Functions 1 December 1st 05 07:18 PM
Using hide in excel get "cannot shift objects off sheet" snowbounduk Excel Worksheet Functions 1 November 22nd 05 03:15 PM


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"