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
Why am i unable to use an aerial font smaller than 10 pts?
Why am i unable to use an aerial font smaller than 10 pts? Without being able to do so I'm unable to get a decent looking printout onportrait. I can use 'fit to page' but it doesn't look right?
Comment enhancements - more productivity inside the box.
Let's say you're building a sales forecast for your product or developing a marketing budget for your team. You start out with a spreadsheet and soon realize that you need to work with other people: to validate assumptions, get estimates, verify processes etc. Do you find yourself sending emails, making calls—trying to reach people—cutting, pasting, waiting... waiting for the input you need? Built right into Zoho Sheet is the prescription for this headache. It's called Comments. Now we've improved
*URGENT - Zoho Spreadheets (Disabled Macros error)
Hello, I really a fix for this in the next few hours. For whatever reason VBA code keeps disabling when a selection in drop down F is made and producing the following error message:''The following error has occurred in Sheet 2 at line 3. You cannot modify the locked cell range'.'. I thought I had fixed this last week but when 12 uses go access to the shared spreadsheet the problem returned. It seems to be one issue after the other... Can someone please contact me ASAP on my mobile phone ASAP (linked
Unable to connect to messaging service
HI , I get this message when I open a Zoho Sheet. The funny thing is that when I open the file from my mobile phone, it opens ok. But when opening it from the desktop, errors appear on the formulas and the "Unable to connect to messaging service" appears. Can you help ? I am testing and evaluating Zoho to see it is answers my companies needs . Thanks
merging duplicates & searching for format types
Does anyone know how to search for Format = bold and so that I can get results on a search for all cells that have been bolded? Also, want to be able to remove all duplicates / any tricks to this? Thanks!
MESSAGE: "the server has encountered an error. Please try again later"
I was going to use a spreadsheet now. it wont open or let me use it. Keeps giving me the msg on the title. Can you please have a look? It opens for few seconds and after is gone Thx, Joao
Cannot view AWS S3 files in zoho sheets excel viewer
I cannot view the aws url in https://sheet.zoho.com/sheet/view.do?url=https://s3.ap-south-1.amazonaws.com/ledgers/8/books/58850833.xlsx?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAJLJ6P27HLOO6Z2MA%2F20170807%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20170807T125701Z&X-Amz-SignedHeaders=host&X-Amz-Expires=900&X-Amz-Signature=d0d124559f098c31b61e49f5d99408abea0c4681cfd9b47d2c6774055d1427f6&name=58850833.xlsx
linking MS Excel with Zoho docs Excel
Hi team Is there any possibility to link Ms Excel with Zoho Excel such that update made on Ms Excel can directly modified in Zoho. Awaiting ur response ASAP.
Macro error
I'm new to Zoho sheets, and have been having issues with Macros (if statements in particular). Currently I receive the following message when running a macro (copy/paste from excel vba). Unknown function Worksheet_Change Below is the code, starting with the line that referred to in the error. If count >0 Then Range("A2:A999").ClearContents Worksheets("Want List").Select i = 9 Do While Cells(i, 2) <> "" i = i + 1 Loop For j = 1 To UBound(Qty) If i + j - 1 =
Auto populated sheet data from a form (zoho sheets)
Having created a form with 5 variables, I have decided I don't want the 2nd, 3rd or 4th variables anynore and have deleted them from the form, which has deleted them form the sheet. This leaves me with the 1st and what was the 5th variable on the form. In the sheet I have timestamp, user, then variable 1, then three empty cells, then variable 5. How can I tell the form to enter var5' data in the cell immediately after var1, I have A B C
Next Page