I added a 2nd sheet to a report but the report has the 2nd sheet cells locked. Please help.

Joel Turlington

I added a 2nd sheet to a report but the report has the 2nd sheet cells locked. Please help.

Mike Wilday

Do those cells have a formula? Formula cells are not editable in a report.

Joel Turlington

Nope the cells are in a report. I have columns from 2 sheets in this report. I can edit all the columns pulled from the first sheet but the all the cells in the columns from the 2nd sheet are locked.

Mike Wilday

Probably a silly question, but are you an editor in the second sheet? Are the sharing permissions for both sheets the same? @Paul Newcome @Andrée Starå ever see this behavior before?

Paul Newcome

The cells in the actual sheet (not in the report)...

Do they have formulas?

What type of columns are they in?

Are they being referenced in dependency settings?

Are the columns and/or rows locked?

Are you the owner of the sheet?

Are you the owner of the report?

How exactly are you accessing the report?

Mike Wilday

Paul Newcome

@Mike Wilday Haha. Figured I would go ahead and cover as much as I could since my day ends in a little over an hour. After that I won't be back on until tomorrow.

Mike Wilday

Yep! sometimes the answer isn't found till the right question is asked!!! :D