Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phantom Data Validation | Excel Discussion (Misc queries) | |||
xls spreadsheet constantly calculating causing navigation issues | Excel Worksheet Functions | |||
Phantom links | Excel Discussion (Misc queries) | |||
phantom headers | Excel Discussion (Misc queries) | |||
phantom headers | Excel Worksheet Functions |