Error calling macro module from Workbook_NewSheet
For several years I've used a sheet that calls a macro in a macro module from the ThisWorkbook module under Spreadsheet objects. Earlier this week I adjusted an unrelated part of the macro module, and the call from the ThisWorkbook module stopped working.
Date Time Format setting according to region wise
Hi i am facing issue of date time format setting in zoho sheet. By default there is american date time setting how can i change my regional setting
How to delete multiple empty rows?
I have a list of data that has been imported, however it now has an empty row in every 1 - 2 rows. Is there a way with the new data cleaner to remove these rows? I have over 1,000 rows.
Cannot copy from one spreadsheet file to another with formula
Hi, I am trying to copy a cell range (which has formula) from one spreadsheet file to a another, but only the values get pasted not the formula. How can I copy paste such that the formula gets copied instead of the values? Kalpa Pathum Welivitigoda http://about.me/callkalpa
New in WorkDrive: Share with Anyone on the Internet
If you need to share a document or file online, it's best to do this securely and reliably. While there are multiple methods for transferring files online, it's good to keep in mind the purpose of sending the information and understand who your viewers are. WorkDrive already gives you a customized External Sharing option, where the sender can control the link properties to share data securely. In addition to that, here's a new way of sharing files with external viewers. By using this new feature,
I cannot sort in sheets because of a 'merge' in the column
When I select the entire column and select UNMERGE, it still gives the error when I go to sort that column!
Import External JSON
Hello, How can i import (and keep it updated) a external web json? For exemple i have this test json: http://www.omdbapi.com/?i=tt3896198&apikey=8502817a How can i import it correctly? and also keep it updated. Thanks
Trigger a custom function in a Zoho Sheet on range change
Hello, I have a custom function in Zoho Sheet that updates a Zoho CRM record. That by itself works. I am trying to trigger that function when a new row is added to the sheet. I thought this would be able to happen via the VBA editor, but I can't get it
embed zoho sheet to google sites and allow real time update
Is it possible to embed zoho sheet to google sites and also allow real time updating?
How to check for duplicate values
Hi, I have a list of values in a column. And I keep adding more values to the column. I want to check and highlight the cells with duplicate values. How can I achieve this? I tried with conditional formatting, but there was no such option for duplicates. Kalpa Pathum Welivitigoda http://about.me/callkalpa
Zoho Sheets has frequent DNS issues - Zoho Sheets goes offline
At least once a week Zoho Sheets will go offline. I'll be in the midst of working on a spreadsheet and suddenly it's gone. Instead, I see this error message: This site can’t be reached Check if there is a typo in sheet.zoho.com. If spelling is correct,
New Toolbar in Zoho Sheet
We have revamped our toolbar design in this new version of Zoho Sheet. Below are some screenshots to help you get accustomed to this new interface. Click on the picture below to view the animated image in its original size. Scroll down this post to learn about the changes. Highlight of Changes: The previous format tab is now split into 2 tabs - Home and Format. The Home tab contains the commonly used functions and the Format tab holds formatting related options. Under the Home tab towards the far
How to do repeat item in pivot table
Hye, I want to do repeat item in pivot table instead of missing value. How i can do repeat item like google sheet and excel. (pivot table)
Paste as value, ctrl+shift+v bug
Scenario: Copy one cell Select range of cells Paste as value(s) from right click populates all cells Paste as value(s) from ctrl+shift+v only populates the first cell I work in tables A LOT and I need the keyboard shortcut to work so I don't overwrite
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
sheets not working in certain PCs in the network
We are using Zoho sheets in our company. And suddenly for the past two weeks, we have a lot of issues and sheets don't work in many of the PCs
Why can't I scroll down the list of additional fonts?
Greetings, I was trying to add some fonts to my list from the ones available but I am not able to scroll down the list in any of the categories. I am only able to view the first dozen or so that are at the top of the list starting with the "A"s. I've
#EVAL! for personal function with "Deluge" in Zoho Sheet
I am trying to use a custom function, in a file that is shared with other users. It doesn't matter how simple the function is, I don't have the value assigned in the "return". Only get "#EVAL!" response. This is one of my functions, the simplest (made
How do I get my cell height to auto adjust?
I'm evaluating Zoho Sheet as a replacement for Google Spreadsheet. Using latest version of Safari, and experiencing the same issues in Chrome. A few bugs/things I can't figure out: Auto adjusting cell height when importing from Google Docs or creating a new document Turning off the auto date formatting for X.Y.Z where they are all integers.. (This is extremely important, as our requirements are written as outlines.. "X.Y.Z" corresponds to a requirement ID.. which is then turning into a date) The
Vertical alignment in sheet cells is incorrect
Vertical alignment of text in sheet cells is inconsistent, specifically, "Align Middle" does not actually put the text in the vertical middle of the cell. Consider these cells aligned bottom, taking note of the amount of padding is between the text and
error when adding a new row
hey i get this error when i try to add a new row "There was a problem with your last edit. Please check and try again" and this only happens to one workbook i tried the other once it works fine what can i do to resolve this problem thanks
Where is the specific sheet sharing?
Hi First, my congratulations to Zoho Team for your amazing job. I know it is not possible to hide rows and columns in a sheet (not implemented yet), but at least I would like to know how to hide a page sheet in a shared sheet (by the way, to hide the vba code is also important to me). I searched same thing as "using specific sheet sharing" but I don't find this option in sharing menu. Please, show me as how can I limit the visibility of information in a shared sheet. Sorry my English and thanks
VALUE() function behavior
The VALUE() function bahaves differently than in Excel Excel =VALUE("2-4,1")=#VALUE! =VALUE("2-4;1")=#VALUE! Zoho Sheets =VALUE("2-4,1")=36926 =VALUE("2-4;1")=#VALUE! Where on earth does 36926 come from? Does the coma present issues in other formula
formula needed
I'm new to Zoho after being a Google Sheets user for years... lots of things I despised about Google Sheets... I now find myself missing ONE feature... their script editor... because of ease of use for my "lack of knowledge" in this area... I know enough,
[COUNTIF/SPILL] Trying to find result that fills 2 conditions at once / SPILL results
Hi! I have the following formula from an imported Google Sheet =countifs($B$2:$B; "<>0" ; $D$2:$D ; FALSE)*220 In the B column, I have a list of dates In D column, I have a list of booleans (TRUE/FALSE checkboxes) Opening this formula, we have: Range
how to migrate documents to zoho workdrive
How can i move my files to workdive from zoho docs
How to create a drop down menu in Zoho Sheets
I am trying to find out, how do I create a drop down option in Zoho sheet. I tried Data--> Data Validation --> Criteria --> Text --> Contains. But that is not working, is there any other way to do it. Thanks in Advance.
how to create a pick list
Hello, In sheets, how do I create a pick list? I see it's an option when right-clicking on a cell, but can't see how to edit the choices.
No chat option
Chat option is not available in Android app.
No chat option
Chat option is not supported.
Excels
Sant internette
Ability for admin to transfer the ownership of the zoho sheet file
Currently, in Zoho sheet, there is no option for the super admin to transfer the ownership of the Zoho sheet file to a different user. Suppose if an employee has left the organization then in that scenario we can not access the Zoho sheet files created
How to add url to macro
have an idea how to add the weblink: https://onedrive.live.com/?authkey=%21AHc4H6gbexVr9f0&id=6B86D5C26B3B694B%21156&cid=6B86D5C26B3B694B&parId=root&parQt=sharedby&parCid=BB6DC96E46411881&o=OneUp to the macro?
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
How can I insert a row into one sheet automatically when a row is crated in another sheet?
I use a sheet to keep track of service requests that are entered via a public form. One of my customers wants to use an API from their system instead of filling out my public form. They want to directly create rows in my sheet from their system, and we
Build readable, reusable custom functions with LAMBDA()
LAMBDA, the new addition to Zoho Sheet's function gallery, has the potential to change the way you work with formulas in your spreadsheet. The function helps make your formulas more readable and reusable. You can create custom functions that fit your
Zoho sheets into a tab in teams?
Hi I was wondering if anyone knew a way I could display a zoho sheet into a tab in microsoft teams?
Introducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text
Request for access
Hi everyone. Please help me. When I try to access a spreadsheet that a friend sent me by link it doesn't open, it says I'm not authorized to access the spreadsheet. Please help me. Thank you
Will Zoho sheet continue after March 15, 2023?
Hi Team Zoho. I heard that zoho docs will be discontinued after March 15, 2023. I just want to make sure that it is zoho docs but not zoho spreadsheet. Please clarify. Thanks.
Next Page