Tip #17: Easily share spreadsheets with non-Zoho account users

Tip #17: Easily share spreadsheets with non-Zoho account users

With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do not have a Zoho account.
 
Say you run a wholesale ecommerce business and need to share your inventory data with your retailers. You want your retailers to view and edit the spreadsheet, make updates, and track inventory. Thanks to external share links, it's not necessary for your retailers, or anyone outside your business, to maintain a Zoho account. Simply use your external share links to share your sales data and facilitate seamless collaboration.



Set access limits

Zoho Sheet allows you to create multiple external share links for the same spreadsheet. You can set your preferred access settings for each link before sharing it with your collaborators.



Protect your file with a password

Password protection is highly recommended to prevent unauthorized users from accessing your file through external share links. This is crucial if you are sharing sensitive spreadsheet data with your collaborators.


Deactivate your external share link 

You may need to collaborate with external business users temporarily. In that instance, you can specify a date and time when the external share link will be automatically disabled.


Gather client details

The external share link settings come with an option to collect basic client details, like name, email address, and phone number. Clients must share the details in order to access the spreadsheet. 



Note: If you don't wish to collect client details, they will be considered "guest" users and will be referenced as such in the spreadsheet's audit trail and other collaboration tools.

In tandem with the above-discussed external share link settings, you can allow/restrict spreadsheet downloads. You can also change the link settings and add new collaborators anytime.

If you want your audience to view and interact with spreadsheet data, while keeping the source data intact, use the Publish option to publish the entire spreadsheet, a specific worksheet, or a cell range within your organization or externally. 

Explore the tips on internal collaboration features available in Zoho Sheet here.
 
Follow our Tips and Tricks forum to discover ways to leverage Zoho Sheet for your business. Also, join our Zoho Sheet community to stay updated with the latest product announcements and engage with other users.

    Access your files securely from anywhere


            Zoho Developer Community





                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                      • Ask the Experts



                                          Zoho Marketing Automation
                                                  • Sticky Posts

                                                  • Tip #18: 6 Trendlines and when to use them in your spreadsheet data?

                                                    Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that
                                                  • Tip #16: Ask Zia your data-related questions and get powerful insights

                                                    Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-related
                                                  • Tip #17: Easily share spreadsheets with non-Zoho account users

                                                    With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do not
                                                  • Tip #7: Four things you didn't know you can do with Conditional Formatting

                                                    Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets. If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats: Customize rules with formulas Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which are
                                                  • Tip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek

                                                    Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.


                                                  Manage your brands on social media



                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources



                                                            Zoho CRM Plus Resources

                                                              Zoho Books Resources


                                                                Zoho Subscriptions Resources

                                                                  Zoho Projects Resources


                                                                    Zoho Sprints Resources


                                                                      Qntrl Resources


                                                                        Zoho Creator Resources



                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • Help upgrading from Zoho Workplace

                                                                                                    Is anyone able to assist with upgrading from Zoho Workplace to Zoho One? There appears to be no clear upgrade path. Thanks.
                                                                                                  • So I am trying to get a button to open a form with specific data, basically goods we haven't received yet.

                                                                                                    So the column is Date_received and I want to pull the all the ones that haven't had the date received added as =isnull. Is this right way of doing this or do I need add more to it?
                                                                                                  • Post to Bot doesn't work for Clickup extension

                                                                                                    I correctly configurated the extension but i don't received the notifications in my bot when a task has an update. Can you help me?
                                                                                                  • How to associate email with record?

                                                                                                    Is there a way in Deluge or with the API to associate an email to a custom module record? I'm using the v2.1 Send Email method so I have the message_id of the email but don't see a way to add that to the Emails section of the custom module record because
                                                                                                  • Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

                                                                                                    Dear Customers, We hope you're well! By their nature, modern businesses rely every day on computations, whether it's to calculate the price of a product, assess ROI, evaluate the lifetime value of a customer, or even determine the age of a record. With
                                                                                                  • Private Project

                                                                                                    Hi, I would like to know if a user can create a Private project that only he's able to see it. Not even the ADMIN user. Thanks
                                                                                                  • Matching ZOHO Payments in Banking

                                                                                                    Our company has recently integrated ZOHO Payments into our system. This seemed really convenient at first because our customers could pay their account balance by clicking on a link imbedded in the emailed invoice. Unfortunately, we can't figure out how
                                                                                                  • The Social Wall: January 2025

                                                                                                    We're excited to get started with this year's monthly product updates through The Social Wall. Let's make 2025 a year filled with excited things to learn and explore. This month, we made some product enhancements in Zoho Social: Publish images on TikTok
                                                                                                  • Change Currency symbol

                                                                                                    I would like to change the way our currency displays when printed on quotes, invoices and purchase orders. Currently, we have Australian Dollars AUD as our Home Currency. The only two symbol choices available for this currency are "AU $" or "AUD". I would
                                                                                                  • Cannot Forward an email to a New contact

                                                                                                    Hello, As the title says, I Cannot forward any email to a new contact. In fact the autocomplete feature brings old or even deleted contacts and simply does not recognize the newly added contact. Those new contacts have definitely already been added to
                                                                                                  • New Module in Portals wont Edit

                                                                                                    I created a new modular in the CRM and put a sub-form in it for costing projects. It opens in Portals, and Portals has the Edit option turned on, but it won't let me edit the module in Portals after saving. Anyone know why this would be happening?
                                                                                                  • Multi-currency in Zoho CRM Forecast and Reports

                                                                                                    As a company we have branches in 4 different countries with as many different currencies. Our Sales Teams would like to work with their local currency as much as possible. The Forecast module using only 1 currency is practically usable only by the sales
                                                                                                  • Restructured the Company Information page into distinct sections

                                                                                                    Hello everyone, We’ve made significant updates to the Company Information page to enhance usability and streamline your experience. These changes are part of our ongoing efforts to restructure the feature pages across the product. What has changed? Previously,
                                                                                                  • The dark mode in CRM is here!!!

                                                                                                    Just by accident, I discovered that CRM now has the dark mode! I'm sooooo stoked! I tried so hard with various dark-mode Chrome extensions to make the huge database that I'm staring at all day look easier on the eye! Some work ok, but there were always
                                                                                                  • Subform Zoho Form to Creator

                                                                                                    Hi, I would like to be able to retrieve the values of a Zoho Form subform to create an entry for each in Zoho Creator. To send from Form to Creator, I use Zoho Flow. I have a custom function, which should normally retrieve each field value then create
                                                                                                  • Email Verification on Subdomain

                                                                                                    Hi, The latest guidelines for setting up an email newsletter are to set it up on a subdomain of your main domain so that if you get put in a spam block, it doesn't block all your company email. We have been trying to set this up and managed to get our
                                                                                                  • Is there anyway to get the columns to auto resize to the screen width?

                                                                                                    Hi, Is there a way of getting the columns to fit on one page in a creator app so it is easy to follow for the user.
                                                                                                  • Flow Error

                                                                                                    Hi Zoho Team, Any idea on this? This happens recently. Zoho Desk says "You are not authorized to access this resource."
                                                                                                  • Virus Scan Failing on Attachments

                                                                                                    Hi, Is anyone else having an issue with attachments being unable to upload? Virus scan takes forever and then fails, or just fails and says try again later Thanks
                                                                                                  • YET ANOTHER BUG: Client Script Flyouts no longer acting like Flyouts

                                                                                                    As per https://help.zoho.com/portal/en/community/topic/kaizen-157-flyouts-in-client-script one of the key benefits of a Flyout over a Popup is the ability to move it around the page. This no longer works. The "width" and "height" configuration settings
                                                                                                  • Global Subforms

                                                                                                    Hey 👋🏼 We have a few subforms to calculate detailed offers for customers of car dealerships. These subforms are used in different modules and we need to create snapshots of them in different cases for documentation reasons. For example, an approved
                                                                                                  • Migration not working

                                                                                                    I cannot set up a new email migration, this is the message: Oops! Something went wrong. Please contact support@eu.zohomail.com Can someone please suggest a fix?
                                                                                                  • [ADMIN CONSOLE BUG]: Selected users cannot be unblocked + cannot change user password

                                                                                                    Refer attachments: 1. Select users > click Unblock button > message keeps appearing at the top 2. Change user password > Click Change button > nothing happens
                                                                                                  • When an app is in stage, is any imported data save when its then published

                                                                                                    Hi, so I am just checking that any imported data during the stage part of app development wont be added when the app is published? Thanks.
                                                                                                  • Issue: Sales Order Not Closing After Converting to Invoice

                                                                                                    I am facing an issue while converting a Sales Order into an Invoice. Instead of using the original item from the Sales Order, I am removing it and adding it again from "Include Unbilled Items." However, after generating the invoice, the Sales Order status
                                                                                                  • GSTIN Public Search API

                                                                                                    Does zohobooks have an api using which i can search GST numbers and get their details?
                                                                                                  • Zoho Books | Product Updates | January 2025

                                                                                                    Hello users, Now that January is over, here are some exciting updates to make this new year even better. We’re back with new features and enhancements in Zoho Books, including comparing fields as criteria in workflow rules and a custom SMTP integration.
                                                                                                  • Audit Log for Zoho One Admin Panel

                                                                                                    Dear Zoho One Team, We would like to request the addition of an Audit Log feature in the Zoho One Admin Panel. This log should provide visibility into any changes made within the Zoho One admin panel and directory, including but not limited to: Adding,
                                                                                                  • [Announcement] Enhanced Merge APIs of Zoho Writer for automating document generation using Zoho Apps data

                                                                                                    Hi users, With the record_id parameter in Zoho Writer's Merge APIs, fields related to the given record id is automatically fetched from the Zoho app. You don't have to spend time manually mapping the records and fields in the Deluge code. Here is a sample
                                                                                                  • Important update for WorkDrive TrueSync users in China Data Center (CN DC) & Chinese language users in other DCs

                                                                                                    Dear WorkDrive TrueSync users, We recently identified an issue affecting users who have set their WorkDrive TrueSync app language to Chinese (Simplified/Traditional). During the auto-update process, the app would not restart automatically and unexpectedly
                                                                                                  • Why are these pages marked "restricted"?

                                                                                                    Access is denied with these pages saying "Sorry, this page is restricted". Why? https://help.zoho.com/portal/en/kb/projects/tasks/task-operations7-0/articles/log-hours-for-tasks-old https://help.zoho.com/portal/en/kb/projects/tasks/task-roll-up-7-0/
                                                                                                  • Zoho Email

                                                                                                    Hi, it looks like Zoho Mail services is currently having issues. Please update us with the current status resolution time frame. Thanks & regards,
                                                                                                  • Auto Copying an field from auto generated field in zoho crm

                                                                                                    I have products module in zoho crm, in which i have Part Number which is auto generated whenever the new product is created, i have made another field by name "SKU Number" i want that value of "Part number" should be auto copied to "SKU Number" whenever
                                                                                                  • Awful audio quality

                                                                                                    Hi guys I'm using Zoho Cliq (paid) with my team (remote team : France, Madagascar and Tunisia). Unfortunately, we encounter issues everytime on audio call (and more when we use screenshare) with sound quality, audio lag, etc. We spend loooot of time to
                                                                                                  • GST composition scheme dealer - treatment for client expenses reimbursement

                                                                                                    Hello, I am new to GST and need your help. I am registered as a composition dealer and attract 6% gst charges. In bill of supply, there are also expenses done on behalf of client for which I seek reimbursement AT ACTUAL with NO MARKUP. As I understand,
                                                                                                  • Deleting a single occurrence of an event leads to the deletion of the entire series

                                                                                                    As the title says: When I delete an event and click "this event", it deletes the entire series.
                                                                                                  • Custom CRM to close task when lead lost

                                                                                                    Hello, I am currently trying to create a workflow rule to close the tasks still opens of the lost leads. I tried the workflowrule and update the field but it does not work because they come from 2 different modules (task and lead). So I tried to write
                                                                                                  • Deluge Script In CRM To Deal With More Than 200 Records

                                                                                                    Hi, I have a Deluge script, which works perfectly. We have a custom field in the Campaigns module called Total_Raised which looks at the Donation_Amount field in the custom module, Donations. The idea is to sum up the total of all donation amounts. However,
                                                                                                  • Email Behavior in CRM

                                                                                                    At what level can you see recipient behavior when sending emails from Zoho CRM? We thought there was a way to see what links were clicked, how many opens, etc but can't seem to find that info now.
                                                                                                  • Deleting Salutation Field

                                                                                                    We have updated our lead input screen and 'Salutation' has appeared. This is not visible in the 'Edit Pgae Layout' screen so cannot be moved to 'List of Removed Fields'  Salutation is visible in the list in 'Customization - Fields' however I can only 'Edit' or 'Replace' I cannot delete and I do not need this field on my lead input screen.  Please can you advise how to get rid of this.  Screen shots can be provided if needed.  Thank you Tasha
                                                                                                  • Next Page