For unknown reason, my sheet starts to pop up this error message
"Can't shift objects off sheets" and I cant group any new rows. Here is a list of funny things about this issue,
a. my sheet has no comments at all
b. I can't insert new rows in new area of the sheet and it displays an error message "fixed object will move"
c. I can't group any rows in new area of the sheet
c. However, I can insert new column in new area of the sheet
d. I can group new columns without any problem
Any thoughts? I have been working on this model for a couple of days and nothings went wrong until this morning. This model is macro free and has nothing fancy(pivotTable/autofilter & etc) at all. Thanks a lot.
"Can't shift objects off sheets" and I cant group any new rows. Here is a list of funny things about this issue,
a. my sheet has no comments at all
b. I can't insert new rows in new area of the sheet and it displays an error message "fixed object will move"
c. I can't group any rows in new area of the sheet
c. However, I can insert new column in new area of the sheet
d. I can group new columns without any problem
Any thoughts? I have been working on this model for a couple of days and nothings went wrong until this morning. This model is macro free and has nothing fancy(pivotTable/autofilter & etc) at all. Thanks a lot.