Fixed object will move ??

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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?
 
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.
 
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!
 
I don't have any more guesses.

Good luck.
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!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed objects will move warning in excel 2003 2
Warning message: "Fixed Objects will move" What is its meaning? 2
Living hell in moving Outlook 2002 to new machine 6
Excel 2003 worksheet doesn't auto calculate 4
Problems with Auto Filter 2
Auto Filter - "Fixed Objects Will Move" 2
Have you had a problem with Auto Filter freezing? 2
Cannot shift objects off sheet - message 1

Back
Top