Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed object will move ??
I get the above message when using the auto-filter in Excel 2003 whilst
working with really voluminous data. I am worried that info might not be accurate if something is indeed moving. Can anyone advise what it means please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed object will move ??
Do you have pictures/buttons/comboboxes/other objects in the rows that are are
autofiltered? Maybe excel is warning you that when you apply the filter, at least one of these objects will move??? If you do have objects in those rows, you may want to make sure that they're entirely in a single row. And with some objects, you can make sure that they move or size with cell (some objects don't support this feature). If you hit F5 (or edit|goto or ctrl-g), you can click special and choose objects. It may help you find them. Ayo wrote: I get the above message when using the auto-filter in Excel 2003 whilst working with really voluminous data. I am worried that info might not be accurate if something is indeed moving. Can anyone advise what it means please? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed object will move ??
Hi Dave. I am quite sure that I haven't got any objects in the spreadsheet...
I have also used the F5 key to be double sure - thank you very much anyway! "Dave Peterson" wrote: Do you have pictures/buttons/comboboxes/other objects in the rows that are are autofiltered? Maybe excel is warning you that when you apply the filter, at least one of these objects will move??? If you do have objects in those rows, you may want to make sure that they're entirely in a single row. And with some objects, you can make sure that they move or size with cell (some objects don't support this feature). If you hit F5 (or edit|goto or ctrl-g), you can click special and choose objects. It may help you find them. Ayo wrote: I get the above message when using the auto-filter in Excel 2003 whilst working with really voluminous data. I am worried that info might not be accurate if something is indeed moving. Can anyone advise what it means please? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed object will move ??
I don't have any more guesses.
Good luck. Ayo wrote: Hi Dave. I am quite sure that I haven't got any objects in the spreadsheet... I have also used the F5 key to be double sure - thank you very much anyway! "Dave Peterson" wrote: Do you have pictures/buttons/comboboxes/other objects in the rows that are are autofiltered? Maybe excel is warning you that when you apply the filter, at least one of these objects will move??? If you do have objects in those rows, you may want to make sure that they're entirely in a single row. And with some objects, you can make sure that they move or size with cell (some objects don't support this feature). If you hit F5 (or edit|goto or ctrl-g), you can click special and choose objects. It may help you find them. Ayo wrote: I get the above message when using the auto-filter in Excel 2003 whilst working with really voluminous data. I am worried that info might not be accurate if something is indeed moving. Can anyone advise what it means please? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Fixed reference but move on colums Ref# | Excel Worksheet Functions | |||
Fixed objects will move warning in excel 2003 | Excel Discussion (Misc queries) | |||
error messages fixed object will move | Excel Discussion (Misc queries) | |||
error message fixed objects may move | Excel Discussion (Misc queries) | |||
Warning - "Fixed objects will move" | Excel Worksheet Functions |