Share via

Excel Online Questions

Bikram Pal 80 Reputation points
Mar 19, 2025, 3:26 PM

Hi Everyone,

Our team uses Excel Online through SharePoint and below are the information requested by them, can any body help me with the answers.

  1. is it possible to lock excel cells while opening excel in SharePoint(Through Browser).
  2. Can we disable the Edit in Excel option, to ensure everyone is working only with browser version of excel.
  3. Is it possible to work with Macro enabled excel sheet in sharepoint

thank you so much.

Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
687 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua 18,045 Reputation points Moderator
    Mar 20, 2025, 7:15 AM

    Hi @Bikram Pal

    Question 1: Do you want to protect worksheets? You may click Review > Manage Protection, turn on Protect Sheet.

    User's image

    Question 2: We can only set open worksheets via browser as default in SharePoint Library Settings > Advanced Settings.

    User's image

    User's image

    Question 3: A workbook with macros can be opened on Excel online, but macros do not run in a browser window.

    For more about features on Excel online, please refer to: Differences between using a workbook in the browser and in Excel


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.