View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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?