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.

• Topic Participants

• Subashree Ramamurthy

  

• 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.

• Recent Topics

• Global Sets for Multi-Select pick lists

  When is this feature coming to Zoho CRM? It would be very useful now we have got used to having it for the normal pick lists.

• 550 5.4.6 Unusual sending activity detected. Please try after sometime. <a href=https://www.zoho.com/mail/help/usage-policy.html target=_blank>Learn more.</a>

  Please help me with this. Sending of mails is blocked.

• The Social Wall: November 2024

  Hey everyone, As we move into December, we're excited to share all the updates that went live in Social during November. View, monitor, and respond to your WhatsApp and Telegram messages from Inbox Take your communication a step further by integrating

• Segmenting Contacts Based on Product Purchased

  I am trying to organize our main Marketing Automation email list in a way that segments contacts based on products they have purchased (for example in this case it is 3 different products). To my knowledge, this would require the sync from Zoho CRM to

• Urgent Assistance Needed with DKIM Verification

  Hi, I have been trying to verify the DKIM for the past month using your instructions as well as other resources. Unfortunately, I have not been able to resolve the issue, and it remains persistent. I need to address this problem as soon as possible so

• How do I attach tasks from one task to other tasks in the same project

  How do I attach tasks from one task to other tasks in the same project

• Incorrect Handling of XLSX data

  Trying to import an XLSX schedule of bills into Zoho Books I ran across the problem of date formatting. To replicate: Build a CSV file with bill dates in whatever format you like and import it - this should work if you match the "dd/MM/yyy" etc. format

• Zoho Books Invoice Salesperson: requires ID but there is no "Fetch salesperson" action

  Hi, I am trying to attach a Salesperson to a Zoho Books invoice. In Zoho Flow, the salesperson field required an ID. However, I only have the salesperson name, I need to fetch salesperson by name and then provide the ID. There is no option to fetch salesperson...

• Change format of quantity format

  Hi,  I would like to change the qunatity format from 1,00 to 1.  Is this possible?   thanks!

• Ticket Views: filter criteria -> dynamic date values in relation to the current date

  Hello all, It would be very helpful if you could build custom views in such a way that you do not have to adjust the criteria daily or at whatever interval in order to change the fixed date value as needed. For example, I would like to create a view that,

• Captchas: No support for Google reCAPTCHA or similar

  Hi all, The current captcha integrated into Creator is very basic, and often near-impossible to read. I'm building an app for a charity which includes a couple of public-facing forms, and this is a real issue for people with dyslexia and related conditions - it's effectively excluding them if you want any form of spam protection at all on your published forms (and that being said, the current captcha doesn't even seem very effective - bots can often read it more easily than humans). I've raised this

• Maintain consistency in ticket responses with shared snippets

  Hello everyone! We are excited to announce that our highly anticipated snippet sharing feature is now available to all users. As you know, snippets are pre-defined message templates, or canned messages, that help agents respond to tickets with efficiency.

• Tickets - Zoho Desk

  Hi Team, My Clients need to see their tickets created and the status of the ticket in the Zoho Support Desk itself. How can I do this? My Client doesn't have a Zoho Account. They need to access the ticket by the provided link without signing in.

• Automatically assign Contacts to Account owners

  Hi, I have a finite number of accounts set up in the CRM, and each new contact that comes in is automatically assigned to an Account according to a rule I set up. I want the Contact owner in the Contacts module to be assigned to the relevant Account owner.

• Making Copies/Duplicates of Zoho Forms (Shared)

  Question to the community: is there a way to take a 'shared form' , make a duplicate copy and save under My Forms, so that i can use that which was already created as a template to make updates to and use as a test form and be able to have full access,

• Using IMAP configuration for shared email inboxes

  Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configure

• Can you help us creating a customised form with payment link?

  I would like to create a customised Transport form where the user will be asked to make payment basis the drop/ pick up they select.

• Deleting or disabeling predefined ticket list views

  Is it possible to delete or disable predefined views or is this still not possible? For instance, we are not using the chat function and therefore have no use for the "Missed Chats" view. Thanks!

• Email an Invoice from API

  When calling the API to email an invoice, it seems it does not actually send it. Below is a screen shot where I used an API call for the bottom record, and it updated its' status to "Due Today", but no email was actually sent. The top record, I hit the

• Unable to load your extension. Please check your plugin-manifest or Resources.json.

  Hi Team, I am using the config module with multiple fields of different types, such as checkboxes and picklists. However, I am encountering the following issues: Error Message: When loading the extension, I get the error: "Unable to load your extension.

• Layout Rules / Quick create

  Hello, is there a way to create a layout rule for quick create option? Regards, Katarzyna

• Issue with Create Note Button and Popup Form in Leads Module

  Hello Zoho Community, I am trying to implement a "Create Note" button in the Leads module with the following functionality: 1. When the button is clicked, a form should pop up with fields to add notes. 2. After filling out the form and clicking Send,

• Finding draft ticket replies

  Is there a way to see all tickets which have draft replies?

• Guidance on Making Zoho Desk Connections Available for All Data Centers

  Hi Team, I’m currently developing an application using Zoho Desk connections to manage OAuth for my third-party products. Could you please advise on the steps required to make it available across all data centers? Looking forward to your thoughts on

• Able to change project on timelog entries

  Ability to move the timesheet entry from one project to another. When a user adds a wrong entry a manager can change/update the timesheet entry to the correct project.

• Caso de Uso | Menos trámites, más salud: Clínicum optimiza sus recursos con Zoho One

  "La automatización del proceso de solicitud de bajas y su trazabilidad a través de Zoho nos ha supuesto una mejora en el ROI." - Carol Rodríguez, Responsable de Experiencia del Cliente interno y externo en Clínicum ¡Hola a todos! Estamos emocionados de

• How do I stop getting notified about upgrading to Upgrade now and save big!

  How do I stop getting notified about upgrading to Upgrade now and save big! There is no way to clear this notification, and EVERY Day I get alerted to upgrade, but there is no permanent way to dismiss this alert! How can I permanently dismiss this a

• Double opt-in notifications and customizable confirmation messages for your webforms

  Dear CRM Community, We are excited to announce a major upgrade to our Webforms feature. You can now customize the confirmation message shown to your users who double opt-in from your webform and also customize your confirmation emails when they submit

• Bulk create tasks - Zoho Projects API

  Hi Zoho/Community, I am trying to create multiple tasks in a single API call, is there a way we can combine multiple request bodies into one single payload? The issue I am facing is the rate limiting on the API, I wanted to create certain amount of tasks

• Task Due dates and Reminder Date & Time

  I like to have a reminder on many tasks in Zoho Recruit. I find the process cumbersome in that each task requires the following: 1. click and select due date 2. Click the reminder box 3. Click on (Reminder) Start Date 4. Click on (Reminder )Time If one

• Unable to Access Admin Console and Email Sending Issues

  Hello Zoho Support Team and Community, I hope this post finds you well. I am currently facing two significant issues with Zoho services: Admin Console Access Issue: Every time I try to access the Zoho Admin Console, it gets stuck on the loading screen

• Tracking new lead response time

  Hi, I have a team of Sales Development Reps, who have a KPI of responding to a lead within 20 mins or less once it hits the system.  I seem to recall that Zoho CRM had the capability to track this in a previous version, but don't see it anywhere.   It's

• Getting The Following Error.. 550 5.4.6 Unusual sending activity detected

  I just launched a marketing campaign and I got this error. Everything was working fine previously. This is a big launch so need to fix it asap. Can anyone help?

• Printing on 80mm bluetooth Pos Printer

  Hello. I am trying to print receipts and invoices using my 80mm bluetooth connectivity Pos printer. I have configured the Templates to Retail so that it matches the paper width of the Pos printer. However, when I click Print in zoho, first it opens the

• Trying to integrate gmail but google keeps blocking Zoho access for integration??

  hi i am trying to integrate a gmail account so can track/access business emails this way. I have followed the instructions but after selecting my email account it gets re-routed to this message (screengrab below) Can anyone advise a way around this or

• Which attribute in Zoho books invoice api represent branch attached to the invoice?

  Hi Zoho Team, We have done the integration with Zoho Books API. While fetching data from Invoice API we want to get branch value attached to the invoice. We could not figure out which field in "Get an Invoice" api represents branch value attribute. Thanks

• How to Billed from two different GST Numbers

  How to Billed from two different GST Numbers. Suppose ABC & Co had GST registration in Delhi and Haryana and Zoho account is created with Delhi GST Registration number. Now i also want to issue invoice from Haryana GST Registration number. How can i proceed ?

• How to hide Predefined views

  Hi, I would like to know how to hide: Predefined views and Recent views or some records from this list. If I'm using it form iPad I have to scroll to see User created views. Or maybe it's possibility to move User created views on the top. All the best,

• Deleting Views

  How do you delete views? Please syd

• Fixed Assets

  Where would I manage my fixed assets

• Next Page