Pivot filters while workbook is shared

Tamer Hossam 1 Reputation point
2022-12-04T11:21:43.573+00:00

I need to know how to keep Pivot filters not locked after enabling "Share Workbook" option as it keeps returning the notification "cell or chart you're trying to change is on a protected sheet. to make a change , unprotect the sheet", once I remove the Share Workbook option filters are editable even when sheet is in protected mode still?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,640 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Charles Qi_MSFT 966 Reputation points
    2022-12-05T08:00:02.06+00:00

    Hi, @Tamer Hossam

    Could you please let us know which version of Excel are you using? Based on our test, pivot filter works when using Excel 365. We would suggest you go to Review->Unprotect worksheet to unprotect the worksheet and check the result. If you cannot unprotect the worksheet and you get the workbook from other users, I would suggest you contact with author of the workbook on the issue. For more information on protect worksheet you can refer to protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in email-notifications to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments