Suppress "spreadsheet will not be saved" message on published sheet

Suppress "spreadsheet will not be saved" message on published sheet

I have published a sheet and have one column on that sheet that the user can edit (a dropdown picklist where the user can select the status for each line). Is there a way to suppress the Zoho Sheet message "Any changes made to this published spreadsheet will not be saved to the original file" when the user changes a cell in that column (picks a different item from the picklist)?

We have a VBA script that is triggered when the column changes that sends the change to our Zoho Creator app, so the user's changes are technically being saved (in our Zoho Creator app) even though the changes will be discarded from the spreadsheet once it is closed. Our users are getting confused because they think their selections are not being saved when they actually are.

We have tried sharing it instead of publishing it, but this doesn't work the way we need it to because we don't want to show the formula bar or the row and column headings (which we cannot hide if we're sharing it but can if we're publishing it).

    Zoho Campaigns Resources

      Zoho Desk Resources

      • Desk Community Learning Series


      • Digest


      • Functions


      • Meetups


      • Kbase


      • Resources


      • Glossary


      • Desk Marketplace


      • MVP Corner


      • Word of the Day


        • Sticky Posts

        • Revamped Print in Zoho Sheet—customized for paper

          The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
        • Slicers are now available in Zoho Sheet—filter your data interactively

          At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,
        • Check out the new Checkbox in Zoho Sheet

          Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
        • Format and analyze spreadsheet data with Zoho Sheet's Table

          While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
        • Introducing Data Bars: Graphically represent changes in data within the cells

          Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

        Zoho CRM Plus Resources

          Zoho Books Resources


            Zoho Subscriptions Resources

              Zoho Projects Resources


                Zoho Sprints Resources


                  Zoho Orchestly Resources


                    Zoho Creator Resources


                      Zoho WorkDrive Resources



                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

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

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • How to link Custom Fields in Ticket view

                                  Hi team, I have created 2 custom fields in our Accounts Module would like them to show in our ticket information. We don't have Enterprise so I cannot do it via a workflow, but I know you can do lookup fields to link modules. How would I go about making
                                • Mapping for date field from one module to another.

                                  Hi there, I want to be able to map a date field(due date) in a module (sales order) to another module's(Purchase Requisition) date field(Promised customer date). Is this possible when the due date field is a zoho system date field while the promised customer
                                • Can I use merge tags with a conditional clause?

                                  Similar to Mailchimp's "IF / ELSE / ENDIF" functionality, I want to be able to display a sentence with a personalised field only if that merge tag is not empty for the given record. Is this possible on Zoho Campaigns? See http://kb.mailchimp.com/article/how-do-conditional-smart-merge-tags-work for how it works on Mailchimp. Thanks Phil
                                • This mobile number has been marked spam. Please contact support.

                                  Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?
                                • Telephony External ID field added in CRM

                                  Dear All, We have an enhancement for users with telephony integrations—introducing the Telephony External ID field. Let's get into the details! What is an external ID field for telephony? External ID fields in Zoho CRM essentially hold a record's reference
                                • Error AS101 when adding new email alias

                                  Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
                                • domain authentification on ovh and zoho

                                  I don't succeed in adding an domain authentification on ovh. Should i first create a subdomain? But this doesn't work either, ti gi ves te same screen and the next button is greyed out when adding the info received from zoho
                                • Splitting a List into different rows

                                  I am getting a List from a for each loop. But I can't figure out how to separate each item that is separated by a comma. Example Zone 1 - Front Door,Zone 2 - Rear Door,Zone 3 - Side Door I need it too look like this: Zone 1 - Front Door Zone 2 - Rear
                                • Zoho Desk iOS app update- Save drafts on the social channel tickets, send replies via blueprint transition on social tickets

                                  Hello everyone! In the latest iOS version(v2.9.3) of the Zoho Desk app, we have brought in support for the following features: Save drafts on social tickets Send replies to social tickets via blueprint transition. Save drafts on social tickets We can
                                • Unit Conversion with Unit of Measurements for Items, has anyone successfully figured this out????

                                  I am currently using google sheets to break down my per cost of items I buy in bulk. We are a non-profit that creates kits and resells at the exact price we pay for the items to our customers or uses grants from the government to pay for them. I can not
                                • Possible for client users to use timesheets?

                                  Hello, We are setting up a project where the bulk of development will be performed by subcontractors. We were thinking of setting them up as client users to have access to project information resources. Is it possible for a client user to log time against
                                • Automation in Zoho Sprints

                                  Hi. I have a Sprints board with the following statuses: ToDo, InProgress, CodeReview, Testing, Preprod, Live When a ticket is moved from e.g. Testing to Preprod, the following tags should be modified: remove 'tested OK' remove 'ready for Preprod' add
                                • Zoho Flow reads record Tag as number instead of text string. How do I change it?

                                  I have experience with flow and have a number of them working. This flow is supposed to add a record in a custom module when a Contact record is edited or created with a specific tag. Trigger criteria is "Tag contains 'Athlete' ". However, the flow does
                                • Oops! Something went wrong. Try again later When trying to send email

                                  Hi, This error is appearing everytime i am trying to send an email. Oops! Something went wrong. Try again later  Please help.
                                • How to Parse XML Data Returned by API?

                                  I have several APIs integrated with my CRM and they work great. I am having some trouble though parsing data out of a large string/array in Funtions? I need to be able to pull the DeviceId and the WebSiteDeviceName from each PanelDevice. I would appreciate
                                • Deluge Script - "Mismatch of data type expression" Error When Retrieving Account ID

                                  Hi everyone, I'm working on a Deluge Script in Zoho Creator to create Accounts and Locations. I'm running into a "Mismatch of data type expression" error when trying to retrieve the ID of a newly created Account. Here's the relevant part of my code: accountResponse
                                • Function Only Working Manually

                                  Good evening everyone. I have a function that creates a PDF from a Creator form. When I execute it manually it works perfectly. But when I execute it from within a On success workflow it is not working. I'll post my code below. Any ideas? //Function void
                                • Elevating Email Security on Zoho Desk: DKIM Now Mandatory

                                  Hello Zoho Desk Users! It has been a wonderful journey with you on Zoho Desk. As we welcome 2025, we are strengthening our efforts to ensure a secure and seamless experience for you. To enhance email security, DKIM configuration will be mandatory for
                                • Assistance with Code to send email on subform data

                                  I am trying to trigger an action off the successful submission of a form that emails the details of the subform to a distinct email. This subform is setup as another form in the app and I can get the below code to work: for each subrow in input.New_Payment_Subform
                                • PDF Import

                                  Hi Guys, Zoho Sheet now supports file formats such as XLSX, XLS, XLSM, ODS, CSV, TSV, SXC, XLTX, and TXT. However, support for PDF files is not available yet. Adding this option would be very helpful. Thank you!
                                • Credit Card Terminal for Zoho Books

                                  Hello, Instead of punching the credit card number manually for customer payment, do you have a third-party hardware credit card reader that works with Braintree? Thank You
                                • Zoho CRM Workflow Merge Tag For a File Upload

                                  Hello, is there anyway to add a merge tag for a file upload field in Zoho CRM Workflow emails? I don't see it as an option in the drop down. Thanks, Hannah
                                • Shared Mailbox - Mark as read for all users

                                  Hi all, Maybe someone can help me out. At the moment we have a shared mailbox without streams. When a users reads an mail or marks it as read other users will not see this. How can we resolve this? We now archive the mails when read and followed up. However
                                • How to delete attachments form Zoho mail accounts

                                  I can't find a way to delete attachments from Zoho mail messages, either individually or in bulk. Searches here are providing conflicting results and often talk about workspace, whereas I am only interested in how to delete attachments that are seen with
                                • Stopped getting zoho notifications in Email for Customer response to support tickets

                                  Hello , I stopped receiving Notifications from customer response in my company with attached to this account.
                                • ChatGPT

                                  Hola, sabéis si además de tener la licencia de chat GPT Plus hay que comprar créditos para usar chat GPT en zoho social? Gracias
                                • ZOho Recruit API hiring Pipeline

                                  I was wondering if it's possible to update the hiring pipeline using the API. I am messing around and I can change the status of the applications and it shows the application as rejected but the pipeline stay's at the stage that applicant was at. Also
                                • Lost the ability to sort by ticket owner

                                  Hi all, in the last week or so, we have lost the ability to sort tickets by Ticket Owner. Unlike the other columns which we can hover over and click on to sort, Ticket Owner is no longer clickable. Is it just us, or are other customers seeing this too?
                                • Round-Robin with Load Based Assignment, can you limit which Status are considered?

                                  Hello, We are currently using Round-Robin with Load Base Assignment. Is there a way to exclude tickets of a certain Status from being considered by the Round-Robin Assignment rules? For example... I have the following statuses. Escalation Review (meaning
                                • Notify on new comment

                                  I would like to notify users when a new comment is added to ticket/request? So if someone is following request they would get email or text saying that comment has been added to this request. Or request/ticket owner get notified. Thanks Luis
                                • Save Draft in email bigin for desktop and mobile

                                  Hi any news to when we going to have the save draft for email in bigin desktop and mobile?
                                • Insufficient "previlleges" to perform this operation? All of a sudden

                                  Trying to create a ticket report in the free version of Zoho Desk (Analytics > tickets by contact), same as I have always done for the past 4 years every 2 weeks, and I am receiving the following message: I am labeled as Support Administrator, and we
                                • Ticket sends email to 2 different email addresses

                                  Good afternoon, I am attempting to setup our ticketing system so that when a ticket is created, updated, and closed, it will email both the customer receiving support as well as the salesperson that is associated with the customer. The way that our tickets
                                • API to post drafts for social media

                                  I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon
                                • Forced Tooltip on Maps View

                                  Please remove the forced tool tip data points and ONLY include those listed in the "Include Columns for Tooltip" area. Also, disable the tool tip if no fields in there. With a lat/lng map, it forces showing those (and color field, lat count) and will
                                • Anyone else having trouble with blurry pixelated screenshare?

                                  Ever since Monday Nov 26th., Cliq and Meeting screenshare has been blurry/pixelated like this:  https://www.screencast.com/t/0CblL3drKuU Did something change? Because Our Internet connects are plenty fast and everything is crystal clear in Skype... Also, video share is clear and normal, it is just screen share... Thanks
                                • Map chart on Dashboard - can I disable tooltip?

                                  When adding a world map chart to a dashboard, I would like to disable the tooltip with details. Is there a way to do that?
                                • ERROR

                                  I deleted a contact card, I want to add it again but it says that the contact already exists. I searched the records and it is not there, and I even deleted it in the trash. The email is this one: ldurbani@gmail.com. Please help!!
                                • Currency Field Does Not show commas upon entry - leading to inaccurate entries!

                                  Hello Zoho... When our sales reps are entering deals and the profit/revenue it is difficult to accurately enter numbers with lots of zeros when there commas are NOT added until the record is saved. Could commas be added to this filed type as it is being
                                • Display Profile Member Details of Logged In User in Zoho Site

                                  In a page, I want to display the profile details of the Member Portal who is logged in to my Zoho Site (email, name, etc.). How can I retrieve the email, name, and other data from the logged in user? I know that there is already a My Profile page that
                                • Next Page