PDA

View Full Version : "FIXED OBJECT WILL MOVE" ERROR IN EXCEL



cosmicsyzygy
09-18-2007, 09:22 AM
Hi there

I am trying to use the auto filter in my spreadsheet & each time I click the combo box to filter information, I get a dialg box displaying the above message. I've tried clicking the OK button & that does not work and the only way I can get rid of the error message is by terminating Excel in the task manager, else the message continues looping and does not allow me to exit or do anything in the program.

I had a logo on the spreadsheet which I have deleted and still get the same error. I have comments which I have checked to ensure they do not overlap the print areas. Other than that, there are no other objects.

I have no idea what to do. :dunno

Any suggestions/ideas would be great.

Thanks in advance
Cosmicsyzygy.

Oorang
09-26-2007, 10:23 AM
From Dave Peterson:
Tools|options|Edit tab|
Uncheck the "cut, copy, and sort objects with cells"

http://www.officefrustration.com/showthread.php?t=55264