Phantom Objects causing issues

  • Thread starter Thread starter peterpeter
  • Start date Start date
P

peterpeter

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?
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
Thanks for the tip, it helped now and no doubt in the future.

Gord Dibben said:
Probably the Comments are the culprit(s)

See this KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211769


Gord Dibben MS Excel MVP

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?
Click to expand...
Click to expand...
 
Back
Top