Sharing Spreadsheets

You can share spreadsheets using the Share feature available in Google Sheets.

Google Sheets provides a Share feature using which you can share your spreadsheets with your team. The Share button is located at the top right corner, next to your user profile icon. When you share a spreadsheet, all its contents and sheets are shared. You can set editing access and share the spreadsheet either through email or by copying and sending its link to the recipients. For more information on how to share a spreadsheet, see Google's documentation on Share files from Google Drive.

When recipients access the shared spreadsheet, they can view the sheet contents but need the Smart View add-on extension installed to work on it. If the recipients do not have the Smart View add-on extension installed in their Google Sheets, they can install it from Google Workspace Marketplace. In the Extensions menu, select Smart View for Google Workspace, and then select Install. For more information on installing the Smart View add-on extension, see Getting Started with Oracle Smart View for Google Workspace.

In the shared spreadsheet, the recipients can initially view the full contents, irrespective of their access to dimensions and members. However, when they try to perform an operation such as refresh or submit, they are prompted to log in and start a new session. After logging in, the recipients can refresh the spreadsheet to view data as per their access privileges and preform further operations. Multiple users can continue working on the same spreadsheet simultaneously.