Phantom Objects causing issues
 

I have a fairly large but simple [Excel 2003] spreadsheet with simple
formatting (number, text & date) with some comments inserted. No formulae are
in use.
I have recently 'shared' the workbook.
I want to hide some columns, however i get the error message "cant shift
objects off page".
This did not happen prior to sharing & even when i have 'unshared' it i
still get the message.
There are no objects that i can see.
Is there a way to check if and where an object may be or does anyone have
any ideas what could be causing my problem?

Phantom Objects causing issues
 

hi
excel has lost it's used range reference. this happen now and then. to reset
your used range reference, see this site.
http://www.contextures.com/xlfaqApp.html#Unused

shows a way to manually reset or programicly reset.

regards
FSt1

"peterpeter" wrote:

I have a fairly large but simple [Excel 2003] spreadsheet with simple
formatting (number, text & date) with some comments inserted. No formulae are
in use.
I have recently 'shared' the workbook.
I want to hide some columns, however i get the error message "cant shift
objects off page".
This did not happen prior to sharing & even when i have 'unshared' it i
still get the message.
There are no objects that i can see.
Is there a way to check if and where an object may be or does anyone have
any ideas what could be causing my problem?

Phantom Objects causing issues
 

Probably the Comments are the culprit(s)

See this KB article

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 15:44:00 -0800, peterpeter
wrote:

I have a fairly large but simple [Excel 2003] spreadsheet with simple
formatting (number, text & date) with some comments inserted. No formulae are
in use.
I have recently 'shared' the workbook.
I want to hide some columns, however i get the error message "cant shift
objects off page".
This did not happen prior to sharing & even when i have 'unshared' it i
still get the message.
There are no objects that i can see.
Is there a way to check if and where an object may be or does anyone have
any ideas what could be causing my problem?

Phantom Objects causing issues
 

thanks for that, deleting all the extra columns & rows seems to have worked,
however my 614Kb document is now 31.4Mb....this seems extreme.

"FSt1" wrote:

hi
excel has lost it's used range reference. this happen now and then. to reset
your used range reference, see this site.
http://www.contextures.com/xlfaqApp.html#Unused

shows a way to manually reset or programicly reset.

regards
FSt1

"peterpeter" wrote:

I have a fairly large but simple [Excel 2003] spreadsheet with simple
formatting (number, text & date) with some comments inserted. No formulae are
in use.
I have recently 'shared' the workbook.
I want to hide some columns, however i get the error message "cant shift
objects off page".
This did not happen prior to sharing & even when i have 'unshared' it i
still get the message.
There are no objects that i can see.
Is there a way to check if and where an object may be or does anyone have
any ideas what could be causing my problem?

Phantom Objects causing issues
 

Thanks for the tip, it helped now and no doubt in the future.

"Gord Dibben" wrote:

Probably the Comments are the culprit(s)

See this KB article

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 15:44:00 -0800, peterpeter
wrote:

I have a fairly large but simple [Excel 2003] spreadsheet with simple
formatting (number, text & date) with some comments inserted. No formulae are
in use.
I have recently 'shared' the workbook.
I want to hide some columns, however i get the error message "cant shift
objects off page".
This did not happen prior to sharing & even when i have 'unshared' it i
still get the message.
There are no objects that i can see.
Is there a way to check if and where an object may be or does anyone have
any ideas what could be causing my problem?