Zoho plugin and shared sheet-properties en some other questions
We work with zoho shared sheets to communicate with some of our customers about pricing.
On some non-public (for the customer hidden sheets) calculations are being made, and the answers are being presented in a worksheet that is openly shared with the customer.
We find that working in the zoho environement for big spreadsheets is not very user-friendly. We therefor have the zoho plugin installed and with help of this plugin we temporarily edit the entire spreadsheet in Excel, and save it back to zoho.
Our questions.
1. Currently sometimes the spreadsheet will simply not open at all in Excel with the use of the plugin. There is an errormessage indicating that one could try later.
If we try to export the spreadsheet manually from the zoho enviroment (loggin in normally in zoho), the spreadsheet will also not export to an XLS and report an error.
We cannot find any reason that the particular spreadsheet is behaving in such a way.
We have the same spreadsheet for several customers. Where the exact spreadsheet for customer 1 will end up with an error, the spreadsheet for user 2 (which is an exact duplicate of spreadsheet 1, exept for the customer name), this second spreadsheet will open.
Is there a way we can send in the spreadsheet to support to check what's wrong?
2. We find the plugin to be very slow. (Actually, also working in the logged in zoho-web-environement with our spreadsheets is kind of slow). Is there a way we could boost up performance?
Does Zoho have a premium sharing service on a quicker / more powerfull server?
3. When we work with the plugin, we assume that loading the sheet to excel, and saving it afterwards back to zoho will maintain the security-settings on the 'hiding' or readonly of the worksheets. Can you please acknowlegde that this is indeed so, and that we do not have any risk of exposure of the underlaying non-hidden sheets?
3b. Will there ever be an opportunity for the user to use Excel for editing 'his' part or worksheet of spreadsheet where he/she has writing rights?
3c. Will there ever be an button to upload a 'newer' version of the same spreadsheet by means of the importfunction? Currently the upload will always end up in an extra spreadsheet (and we will have to do the sharing/security setting on at least 10 sheets exactly over and over again, without ever making a mistake, which would expose our calculations?
4. We would very much like to see:
- Locked cells (to prevent users from accidently editing)
- Locked cell bounderies (to have the top 1 or 2 and left 1 or 2 cells to be locked always and be in sight when scrolling.
We have seen several requests for these options (question 4), but we would seriously ask you to beef up these options as soon as possible.
5. Macro buttons
Is there a way to make a macro button please? Currently we can only make macros that react on the input of a cell or sheet, and we would like to have a more intuitive way to give users the possibility to switch on options by means of a macro.
Last but not least: thank you for providing this wonderful spreadsheet sharing solution. Please keep up the good work.
Kind regards,
René van der Velde
The Netherlands
Get Started. Write Away!
On some non-public (for the customer hidden sheets) calculations are being made, and the answers are being presented in a worksheet that is openly shared with the customer.
We find that working in the zoho environement for big spreadsheets is not very user-friendly. We therefor have the zoho plugin installed and with help of this plugin we temporarily edit the entire spreadsheet in Excel, and save it back to zoho.
Our questions.
1. Currently sometimes the spreadsheet will simply not open at all in Excel with the use of the plugin. There is an errormessage indicating that one could try later.
If we try to export the spreadsheet manually from the zoho enviroment (loggin in normally in zoho), the spreadsheet will also not export to an XLS and report an error.
We cannot find any reason that the particular spreadsheet is behaving in such a way.
We have the same spreadsheet for several customers. Where the exact spreadsheet for customer 1 will end up with an error, the spreadsheet for user 2 (which is an exact duplicate of spreadsheet 1, exept for the customer name), this second spreadsheet will open.
Is there a way we can send in the spreadsheet to support to check what's wrong?
2. We find the plugin to be very slow. (Actually, also working in the logged in zoho-web-environement with our spreadsheets is kind of slow). Is there a way we could boost up performance?
Does Zoho have a premium sharing service on a quicker / more powerfull server?
3. When we work with the plugin, we assume that loading the sheet to excel, and saving it afterwards back to zoho will maintain the security-settings on the 'hiding' or readonly of the worksheets. Can you please acknowlegde that this is indeed so, and that we do not have any risk of exposure of the underlaying non-hidden sheets?
3b. Will there ever be an opportunity for the user to use Excel for editing 'his' part or worksheet of spreadsheet where he/she has writing rights?
3c. Will there ever be an button to upload a 'newer' version of the same spreadsheet by means of the importfunction? Currently the upload will always end up in an extra spreadsheet (and we will have to do the sharing/security setting on at least 10 sheets exactly over and over again, without ever making a mistake, which would expose our calculations?
4. We would very much like to see:
- Locked cells (to prevent users from accidently editing)
- Locked cell bounderies (to have the top 1 or 2 and left 1 or 2 cells to be locked always and be in sight when scrolling.
We have seen several requests for these options (question 4), but we would seriously ask you to beef up these options as soon as possible.
5. Macro buttons
Is there a way to make a macro button please? Currently we can only make macros that react on the input of a cell or sheet, and we would like to have a more intuitive way to give users the possibility to switch on options by means of a macro.
Last but not least: thank you for providing this wonderful spreadsheet sharing solution. Please keep up the good work.
Kind regards,
René van der Velde
The Netherlands
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
rene
Ramesh Sripathy
sg4dsiao
Rajasekar
Sticky Posts
Introducing a smarter, faster, and more flexible charting experience
Hello Zoho Sheet users, We're delighted to share the latest news about a major update to charts in Zoho Sheet! The new version supports dynamic data ranges, granular styling options, faster loading, and other interesting enhancements that allow you toWhat's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyNew Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your workIntroducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether youSlicers 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,
New to Zoho TeamInbox?
Zoho TeamInbox 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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Zoho DataPrep and File Pattern configuration
I'm using Zoho data prep to ingest data from One Drive into Zoho Analytics... The pipeline is super simple but I can't any way to get all the files that I need. Basically I need to bring all the files with a certain pattern and for that I'm using a regexAssistance needed: Activation of a domain
Hello Zoho Support, I purchased the .com domain "primesolva.com" via Zoho 6 days ago. The domain is still pending, and I cannot access the DNS panel to add the TXT verification for domain ownership. Please confirm the registration status and help me activateOperation not permitted
I am trying to add an email address to the list of user but I am getting error Operation not permittedRequest to Permanently Delete Email User (info@mehbobgulf.com ) from Old Organization
Please permanently delete the user email info@mehbobgulf.com It is still associated with my old Zoho organization. I cannot delete it because it shows ‘You cannot delete email. Zoho host’. I need to use this email in a new Zoho account.”Client host [89.36.170.5] blocked using Spamhaus
Hello please make make actions for delist ..... "Client host [89.36.170.5] blocked using Spamhaus"Suggestion: Option to Re-run a migration
As I'm going through a migration process, I like the IMAP migration tool, but it would be better if there were an option to re-run the same migration as configured. There's not even an option to copy/edit one that's already there. Just run if it hasn'tIssue with "Add Your Mobile Number"
Hello, I am trying to sign up for email service for a domain name, and I cannot finish the authentication. When I enter my mobile number, I receive the message "We’re unable to send OTP to this mobile number. Please contact support-as@zohocorp.com". Izoho mail non vérifié
Bonjour, Il y'a un jour que j'ai acheté un domaine et toute les tentatives pour l'associé a mon compte shopify son vaine. j'ai essayé TXT sans suite après, j'ai essayer avec CNAME sans suite. j'aurais besoin de votre assistance pour associé mon mail.Unable to send message;Reason:553 Relaying disallowed. Invalid Domain
i have facing the issue "Unable to send message;Reason:553 Relaying disallowed. Invalid Domain" if i verify domain evertthing i did but still face the same error.ZohoMail is so close to being Perfect BUT
Why don’t you have HILIGHTING???!! I've been trying to find a substitute for Edison Mail but I want & need hilighting (preferably in more than just yellow)! Is this even on your To Do list? I’m so disappointed. 🙄Override Auto Number field?
We are preparing to migrate from Salesforce. In Salesforce, we auto-generate a unique number on our Opportunities (Potentials). If the Opportunity results in a contract, we use that unique number as the Contract number. There are some situations whereUsing a third party service provider want to move directly with Zoho
Hi good day I’m currently using Zoho but I’m using a third party service provider I want to move directly with you guys I’m using Zoho email and invoices and my domain please let me know if it’s possible to move away from the third party provider my emailRequest for Assistance Regarding Email Sending Issue (554 5.1.8 - Email Outgoing Blocked)
Dear Zoho Support Team, I hope this message finds you well. I am writing to request assistance with an issue we are currently facing regarding our Zoho Mail account. Our email account, admin@tuyensinhcanuoc.com, is encountering the following error whenZoho Mail API returns empty inbox (0 messages) but webmail shows 37 unread emails
Hello, I'm experiencing a discrepancy between Zoho Webmail and the Mail API (EU region). **Setup:** - Account: EU datacenter (mail.zoho.eu) - API: Self Client OAuth2 via api-console.zoho.eu - Scopes: ZohoMail.messages.READ, ZohoMail.messages.UPDATE, ZohoMail.folders.READ,ShipStation and Zoho Inventory
Hello, I am looking to sync zoho inventory with shipstation ZOHO INVENTORY SHIP STATION Sales Order ==> create ORDERS INVOICE <== Shipments What exactly does BETA mean on the Shipstation connector? This is required for me to sign-on in the next month. Thanks in advance for your effortsE
We are trying to add our Zoho Form embed in our Elementor Page Builder. After adding Zoho Forms widget in elementor page builder it’s displaying in backend page builder but it’s giving 403 error while trying to save, as it’s not reflecting in front end.Connecting Zoho Inventory to ShipStation
we are looking for someone to help connect via API shipStation with Zoho inventory. Any ideas? Thanks. Uricustom module import.
Is there a way to import data into a custom module? Thanks RudyHEIC File Type Viewer
Hi, It would be nice to be able to click on the images in the All Entries/Reports Tables which are HEIC the same as JPG, PNG, etc. so they open in a viewer from Zoho or the Attachment Service, today HEIC requires you to download each image and open itHow to dynamically pass IDs from one API response to a second API call in Zoho DataPrep?
Hi Team, I am setting up a global consolidated reporting pipeline in Zoho Analytics (India) using Zoho DataPrep as the ETL engine. I am pulling data from multiple Zoho Books Data Centers (US, Singapore, India) thats why i used the URL Source (OAuth 2.0)Building Toppings #4 - Setting up and using connections in Bigin toppings
When building a topping to extend Bigin's functionality and connect it with third-party applications, creating and handling connections is an important step. Connections provide a secure way for your topping to authenticate and communicate with otherNeed code format to specify default values
Can someone please direct me to the code syntax or the proper translation per the instructions circled below. These instructions don't seem correct.AI Interview Insights: Turn Recorded Interviews into Quick Transcripts & Summaries
Evaluating interviews shouldn’t require replaying long recordings or taking manual notes. With AI Interview Insights, you can now review complete transcripts and AI-generated summaries of your One-way (Recorded) interviews right inside Zoho Recruit. ThisRecord payment: Payment Mode vs. Deposit To and how to "connect" them!?
How do we set up that when we choose: "Payment Mode"= Cash, then "Deposit to" is automatically set to Petty Cash, and if we choose "Payment Mode"= Check, then "Deposit to" is automatically set to Undeposited Checks, and if we choose "Payment Mode"=Grouping Undeposited Funds to Move to other accounts
In the bank option it would be nice to check what transactions in undeposited funds I want to move to other accounts. Then while checking this it can accumulate totals and created whats essentially a deposit slip. Once the transaction is moved it shouldFacing email delivery issues? Verify your domain's DNS records
Have you ever wondered why your legitimate emails are landing in the recipient’s spam folder? Or been surprised to see emails sent from your registered domain getting rejected by recipient email servers? Why does this happen? In most cases, this happensOrder of Departments in Help Desk
In the end user portal, , the departments are sorted by the date of creation of the department (or perhaps their id). Is there a way to choose the display order of the departments or at least to be able to sort them alphabetically?COGS - Account showing negetive
I have multiple COGS account and in these all there is one account is negetive so suggest why it is showing negetive value.?Create CRM Deal from Books Quote and Auto Update Deal Stage
I want to set up an automation where, whenever a Quote is created in Zoho Books, a Deal is automatically created in Zoho CRM with the Quote amount, customer details, and some custom fields from Zoho Books. Additionally, when the Sales Order is converted%PaymentLink%
Does not work. Software creates a BAD link. ....and yes payment options are turned on. Link on the invoice pdf once opened will work but this template is a joke.Google Photos
I am hoping that my question already has a fix. I current have Google synced accounts that I want to get away from. One in particular on is Google photos. Is there any software, or 3rd parties that I can join to back my photos up straight to specifically designated file in the ZOHO cloud that's tied to Docs? Please advise... MikeZoho Books Items Categorisation/Grouping/Folder
Is there a way to do items categorisation? a folder structure? Product Type A - Option 1/2/3 Product Type B - Option 1/2/3 Current problem : I have more than 50 items on the list, its hard for team to navigate.Cash payments before invoice date
We have been using zoho books for our hospitality business for some time and have been very happy with the system. However in 2025 an update was pushed through and we are now not able to record payments for invoices before the invoice date. the case scenarioCopy / Duplicate Workflow
I have workflows setup that are very similar to each other. We have a monitoring system watching servers, and all notifications - no matter what client it is about - will come from a noreply@ address which is not very helpful in having it auto assigned to the right account. I have setup a workflow that will change the contact name of the ticket (currently it would say noreply@) to the correct customer which is based on the subject line, as that mentions which server the alert it is about. I needTransfer between two customers (Peters Rental account to Peters Private account)
we are a Property Management company. Our customers have to accounts (registered as two customers - Peter Rental and Peter Private On the rental account all income and costs fron rental activities are noted. On the private account all private are notedAutomation#18: Automatically Fetch Values from Contacts to the Tickets Module
Hello Everyone, Welcome to this week's edition, where you can seamlessly sync fields from the Contacts to the Tickets module. For efficient business operations, it's crucial to have details mapped across different modules. Zylker Secure offers antivirusCharge multiple invoices
We use auto-charge/recurring invoicing for 100's of clients. If we create a single manual invoice we can charge it to the credit card for these clients with the CC added to their recurring invoices. If a client has multiple outstanding invoices, is there a way to make one charge for all of the invoices instead of a separate charge to the cc for each invoice?Handling/tracking escalation management in Zoho
Hi all, I am working on finding a tool to register and track our escalation management process. Specifically, this is about client escalations, typically related to project delivery issues. The idea is that we could have some sort of form with core questionsGlobal Choice List share ownership
I have created several forms that use one or more Global Choice Lists. These lists have been published to Org. I would like to allow one or more admins to edit the choices in these lists. Any help appreciated. GeoffSetting up property management in Zoho Books
Hi, I run a property management business that manages property complexes. There are multiple owners, some owning more than one property on the same complex. My role is to manage the fees they pay for maintenance of common areas, such as the swimming poolNext Page