VBA Function
Users have been asking for the last 7 years regarding the use of Public Functions in Zoho. Has this been implemented yet. If so, how do you call the function within a cell? If not, why is this important feature not available?
hiding rows and columns
Hi Just signed up to the service, like the plugins ect, but there is no support for hiding rows and columns. i have uploaded a sheet from excel which had hidden rows and columns, which then all became visible. there is no feature to hide, will you be supporting this in future?
Trigger SMS when Cell Value changed in ZOHO Excel Sheet
Dear Members, We are into Overseas Recruitment Company. We conduct interview frequently and maintain Candidates data in Excel sheet. Now we want to maintain that Excel sheet in Zoho Docs (Excel Sheets) We have columns like below Candidate Name Position Mobile Number Status (in Status in the pre-defined values like(selected , not selected, offer declined values) If I select the Excel Cell Value as Selected then a SMS should trigger to the Mobile Number entered against that Candidate. Can we do that
How Do I Delete a Zoho Sheet?
How do I delete a Zoho spreadsheet and send it to trash? I no longer see an option to do that. Thanks
Looking for a quick alternative solution to sharing individual sheets like Google Spreadsheets's import range function
Hi. First, I want to comment that I greatly enjoyed using Zoho sheet last year and this spring. As a middle school teacher who loves excel for managing grades, Zoho sheet was a valuable product for me as it allowed me to output grades to individual students and help them to keep track of their progress. However, since the update, I am no longer able to share individual sheets with others, making Zoho spreadsheet now useless for my own needs. But I like Zoho and would like to say with Zoho. I understand
New iOS Sheet app not working
The most recent iOS Sheet app version launches and then quits. I have to delete and re-download every time to edit an existing sheet. Is there any way to roll back to the prior app version? TIA, -mike-
Connection to an external REST API?
Hi! Is there any way to connect to an external service API from within Zoho sheets? I haven't found anything and I don't think we can do it with Zoho Sheet's VBA implementation either. Does anybody know a way? Thanks!
Unknown function: Find
Hi There, Here is the code: Const WHAT_TO_FIND As String = "Supplier" Dim ws As Excel.Worksheet Dim FoundCell As Excel.Range Set ws = ActiveSheet Set FoundCell = ws.Range("J:J").Find(what:=WHAT_TO_FIND, lookat:=xlWhole) If Not FoundCell Is Nothing Then MsgBox (WHAT_TO_FIND & " found in row: " & FoundCell.Row) Else MsgBox (WHAT_TO_FIND & " not found") End If Here is the Error Msg: Unknown function: Find Why? And please don't tell me that the Find
drmartell@gmail.com
I can no longer check or uncheck check boxes in my spreadsheet when using Google Chrome. They do continue to work in Firefox. This timing seems co-incidental with the release of the updated iOS app which now supports single clicks to change check box state (which it didn't previously).
Zoho Sheet bug on very basic formatting !
A new very annoying bug has been introduced on Zoho Sheet a couple of days ago (beginning of February). Zoho is now UNUSABLE for most sheets. A text cell with characters exceeding his length, in ANY kind of spreasheet, has to cover the left side cell IF it's empty. Amazingly, if you go to that cell and press DEL to be sure it is empty, the formatting works again... BUT if you close and reopen the sheet, or you import a new one, all the empty / emptied cells are back "non trasparent". Hope you fix
why wont my spreadsheet print
i select the print area, click print and am then taken to a blank screen. Please help
Problem with the "Format" command
My code is: sub Hora_Actual() ActiveCell.Value = Format(Now, "dd/mm/yyyy hh:mm:ss") end sub The time is incorrect and the time format is also incorrect. Why ? My sheet here: https://docs.zoho.com/sheet/published.do?rid=566b173d0bfc132354f3ea3445bec13ef8da5
Embedding a spreadsheet in a website problems
I am having trouble finding information on how to work with embedded spreadsheets. I have embedded a spreadsheet on a website and realize there are many limitations. I want to know if when you embed a spreadsheet, how do you save the data entered? I thought it would automatically save but it does not. Is it possible to edit and save or ready only?? Any help or reference to any information regarding this would be appreciated.
Your edit is not applied to the document. Please try again later
Hi, I can't edit my Zoho sheet. I am always getting this error message. I am adding some details to the Manage Data Validation. And it won't save. Please help.
Index/Match formula
Hi, Can anyone help me with my formula: =INDEX(BackOfc.A3;MATCH("Richard Ponce";BackOfc.$B3;0)) it doesn't seem to work on zoho sheets. Is that how it should be written? Also if I could include the IFERROR formula on that one, please help me with write that out. Thanks..
When can I import an excel larger than 10mb?
Now we cant reference a cell from different xls ,the only way is copy ,but the restriction 10mb is too small in such a big data time.
Your edit is not applied to the document. Please try again later
Whenever I try to edit my spreadsheet this error is coming up. Can you help?
Your edit is not applied to the document. Please try again later
Whenever I try to edit my spreadsheet called "brojila", Zoho spreadsheets says "Your edit is not applied to the document. Please try again later."
Deleting rows from Spreadsheets
Ever since the update, I have been unable to find a way to delete unneeded rows from my spreadsheet. Where did this function go? I see where I can add them, but I have searched everywhere for the delete function! Not talking about data within the cells, but the rows themselves... Thanks!
Numbering on spreadsheet not working like exel
I am trying to renumber a column from sporadic numbers to a sequential set. 1, 2, 3, 4 etc. When I highlight then all and go to the bottom right corner, like on excel and when I drag it down to fill, it sets everything to the first number I selected. So from in this example, it does NOT go to 1 2 3 4 5 6 7 8 etc, it turns everything to 1 1 1 1 1 1 1 1 What's going on here? I have A LOT of numbering to do and this will get very cumbersome. Thanks
Dropdown, Multiple Choice, and Checkbox are not populating in Zoho Sheets
Anything else works perfectly fine, but when I make a form those three sections specifically do NOT work...HELP!
How to call a macro from VBA sheet code?
I've seen it written elsewhere that you can call a macro from the 'Worksheet_Change' event. However when I try inserting the syntax: Call My_Macro() within the editor, this results in a dialog box that says "Click a Macro to run." When I click the named macro, the code executes. However, outside of the editor, the complete code doesn't execute. Example: REM Sheet Module Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV REM add your code below Call Do_Sort()
How to remove hyperlinks to all cells in a column
If you select a cell or group of cells with hyperlinks you will usually have the option to "Remove Hyperlink..." from the right click menu. However, this is not consistent if you select an entire column of cells. Is there a command, shortcut, or any method to remove all hyperlinks from a column or even the entire spreadsheet?
Adding a contact in Sheets
Hi All. So in Sheets I am up and running and sharing with some members. People are showing up as Collaborators and can chat with them in the Collaborator window on the right. The "Chats Channels and Contacts" Tabs on the very bottom left corner I managed to add one contact by searching but cant seem to add any more. Any tips appreciated. Cheers Mark
Sheet sharing limitations
Hi, Setup a spreadsheet to share. Tried to share with another email and get the error "you organisation policy doesn't allow you to share with the below user" and "To continue sharing please contact administrator" I am the administrator as far as I can see. I am using the free version. It says allows up to 25 user ? Why wont it let me share with more than 5 ? In my organisation profile has the Organisation Name I set, Me as the super admin. Plan free Number of Licences up to 25. Am I missing something
Zoho sheet feedback
After using the Zoho writer, I am quite impressed with it. But other Zoho docs products are quite unintuitive. Just started to use Zoho sheet but found it sub-par compare to Google Sheets. Its UI is not well thought and is quite boring to use. Just take the below case and compare it with Google sheet. Below are from Google sheet This was a simple case. There are also some missing customisation features. It will be particularly helpful if chart editor opens on the right side as in the case
Where is Lock Cells function in toolbar
I am unable to find a way to lock cells and/or formulas. Also the formulas that I have sometimes delete or change themselves without my input. I can do a spreadsheet, close and the next time I open it the formulas have moved around on the page referencing different cells then originally intended.
Hide data in Zoho Documents
Hello. I have a Zoro spreadsheet and more that 10 users for the same document. I want to hide some data from some users, but at the same time it should be visible for other users. Please let me know to do it. Thank You.
Error on a macro line
Im getting an error on this line "ActiveSheet.Cells(ActiveSheet.Cells(1, 1), 1).Select" not sure what's wrong with it, because it works prefectly on the excel file I have. Thanks for the help.
Live webinar: An overview of Zoho Sheet
Get a complete overview of Zoho Sheet. Register now to join our live webinar and product demo on November 23, 2017. Attending this session will help you: 1. Create beautiful looking spreadsheets 2. Share your spreadsheet and work in real-time with your team 3. Write formulas to do basic calculations 4. Create charts to visualize your data 5. Use macros to automate repetitive tasks Day: Thursday, 23rd November 2017 Time: 11.00 AM - 12.00 PM PDT Register for the webinar, here.
Stock data failed to update?
There is no update on stock price information these few days?
How to alternate the background color of spreadsheet rows?
Hello, how do you edit a spreadsheet such that the rows have alternating background colors? I think they call this a zebra table.
Chrome not working right click in Sheets and not working popups (Fill color window doesnt appear).
Hello, i have problem with Chrome and Zoho sheets, right click menu is not working - i got browser right click menu, not Zoho right click menu. Second problem is that i dont get Fill color - color selection windows in Chrome.
Spreadsheet FALSELY says column limit of 256 has been reached
I am trying to add a column to a simple ZOHO DOCS spreadsheet that currently only has data in column A-T. When I add 'insert column' the pop-up message tells me I have reached the 256 column limit. Clearly I have not. I wonder if highlighting a whole row blue has caused this error?? I have attached a screen shot.\ When I delete the 'u' 'w' or 'v' columns, the problem does not resolve. Can anyone advise a workaround? Less than 24 columns is nothing to work with. Thank you LBB
TRANSPOSE() ?
In Zoho sheets I cannot get TRANSPOSE() to transpose a simple matrix. a 1 4 b 2 5 c 3 6 a The a to the left is the result of (=TRANSPOSE(A1:C3)) in google sheets and excel: a 1 4 b 2 5 c 3 6 a b c 1 2 3 4 5 6
Conditional Formatting not working anymore
I don't know when exactly in the last days in really happend, but Conditional Formatting as I was using quite a long time is not working on some sheets on some cells anymore. What looks strange: When I hover over the range of a conditional rule, it shows "SheetName.SheetName.Range" and not "SheetName.Range" When I click on "Edit" to edit a rule which is not working correctly, it does not enter the modify windows but displays an error message "Gültigen Bereich festlegen", translated "determine valid
Can I sum cells in a sheet based on colour of text or background?
Is this possible? If so, I'd be very grateful to get a lesson how to do it Catherine
Live webinar: An overview of Zoho Sheet
Hello All, Spreadsheet Day (17th October 2017) is right around the corner. Let's make it a productive one. Join us for a live webinar on the complete overview of Zoho Sheet. Attending this session will help you to: 1. Create beautiful looking spreadsheets 2. Share your spreadsheet and work in real-time with your team 3. Write formulas to do some basic calculations 4. Create charts to visualize your data 5. Use macros to automate repetitive tasks Register for the webinar here. Day: Tuesday, 17th October
Working offline in Sheet / Show
I'm using offline access in Writer, which is fantastic, and useful etc. I've seen some notes in the forums about how a future version of sheet will support offline access, and I was wondering if there was a date planned for this new release, as it will enable me to use Zoho almost exclusively.
strange beheaviour of conditional formating
I have a roster in a zoho sheet. I want every teacher to appear in the roster to have its own color. So I made 7 rules, on for every teachter for example: `tabname`.C5:I442 and in the condition the name of the tracher. This works fine but.... Whenever I change or copy something, zoho sheet makes a new rule for just that cell, ahusting my original rule, preventing the earlier rules to work correct. The result is that the condtional formating is not working on all the places anymore After 10 or so
Next Page