If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Warning message: "Fixed Objects will move" What is its meaning?
I get the warning message Fixed Objects will move in an Office 2000 Excel spreadsheet.
This occurs when filtering. To proceed with the filter operation I have to answer OK to the dialog box many many times. I cannot find any references to this warning on the web or in Excel help. Does anyone have an explanation? Specifically - What are these fixed objects? How can I identify them and to where they have been moved? How can I avoid the warning and the need to press return 100's of times? Regards -- John |
#2
|
|||
|
|||
Warning message: "Fixed Objects will move" What is its meaning?
The following MSKB article may help:
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default.aspx?id=211769 Also, Dave Peterson posted this advice: '================ Someone with the same problem posted back that their comments were getting resized causing the trouble. Maybe enabling: Tools|Options|View|Comment and indicator (at least for a little bit will help.) '======================== Or, perhaps William's suggestion in the following posting will help: http://groups.google.com/groups?hl=e...%40tkmsftngp09 He advised the following: '======================= "if you have a button on your worksheet, right click on the button, select "Format Control", select "Properties" and then select "Move and Size with cells" '======================== John Rogerson wrote: I get the warning message Fixed Objects will move in an Office 2000 Excel spreadsheet. This occurs when filtering. To proceed with the filter operation I have to answer OK to the dialog box many many times. I cannot find any references to this warning on the web or in Excel help. Does anyone have an explanation? Specifically - What are these fixed objects? How can I identify them and to where they have been moved? How can I avoid the warning and the need to press return 100's of times? Regards -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Warning message: "Fixed Objects will move" What is its meani
Thanks Debra, deleting some comments seems, on a quick test, to have solved the problem. Testing will continue...
-- John "Debra Dalgleish" wrote: The following MSKB article may help: XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default.aspx?id=211769 Also, Dave Peterson posted this advice: '================ Someone with the same problem posted back that their comments were getting resized causing the trouble. Maybe enabling: Tools|Options|View|Comment and indicator (at least for a little bit will help.) '======================== Or, perhaps William's suggestion in the following posting will help: http://groups.google.com/groups?hl=e...%40tkmsftngp09 He advised the following: '======================= "if you have a button on your worksheet, right click on the button, select "Format Control", select "Properties" and then select "Move and Size with cells" '======================== John Rogerson wrote: I get the warning message Fixed Objects will move in an Office 2000 Excel spreadsheet. This occurs when filtering. To proceed with the filter operation I have to answer OK to the dialog box many many times. I cannot find any references to this warning on the web or in Excel help. Does anyone have an explanation? Specifically - What are these fixed objects? How can I identify them and to where they have been moved? How can I avoid the warning and the need to press return 100's of times? Regards -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|