How do I read multiple Zoho Spreadsheets, which are different files in Zoho Docs?
I have 3 spreadsheets where I need to read the data into one spreadsheet. How do I do this?
Can I set a spreadsheet so that only some users can view/edit certain worksheets within that spreadsheet?
EOM
Excel containing 1,00,000 rows with 200 columns is not opening in ZOHO Spreadsheet.
I have tried to open local excel file with 1,00,000 rows and 200 columns in ZOHO Sheets, which is not opening. Is there any possible way to open this in ZOHO Sheets?
??? where the cell is empty in the formula
Hi, I have been using Zoho spreadsheet for a while.In most of the cell I found sign of "????" in which the cell are empty but the formula is there whose results is zero. Why this so ??
Why can't i select a single cell? is this a bug?
Hi, When i type a formula, like in any spreadsheet editor, i can select another cell with mouse pointer. At this point, i expect the select cell (only) to be added to my formula, but instead of that, i get a bloc of 4 cells, that need to be manually adjusted to 1 cell. 1) why..? Why would you do that? 2) is this a bug? if no, then please answer question number 1. :) 3) Is there a way to disable this ? Please tell me it's a bug or it can be disabled...
Conditional formatting not gets ported when downloading zoho sheet to PC
Hi Team, While downloading a zoho sheet as Xlsx file the conditional formatting in the sheet is not getting downloaded in the file. It will be a good ad if it could be fixed. Thanks! Raaj
Problem with: "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." It has been saying that for couple of days. Any help is appreciated. Thanks, Davor
Get set for Icon Sets.
Conditional Formatting in Zoho Sheet has become more exciting with the addition of Icon Sets. Represent a series of data with certain intervals using colorful icons. They are available in sets of two to five icons making them flexible with your data. How to use it. Icon Sets is placed under the Conditional Formatting menu tab. You can use a set containing two icons for data with TRUE/FALSE or similar conditions, three or more icons to see the change in data with many
Unable merge cell
I fisrt time ZOHO office speadsheet. i have problem on merge cell at my pc. i unable to use merge cell icon. The merge cell icon is not active... is my pc need to update? PC Specification Windwos 10 pro Intel Core 2 Dou CPU E7500 @2.93Ghz Installed Memory = 2 GB System type = 32 - bit Operating system
2 Spreadsheets Disappeared from Shared Folder
2 weeks ago one spreadsheet disappeared from my shared table Yesterday this happen again with another shared spreadsheet Each time this happen after Server Error which was something like "We are sorry but there is current problem with the server" And after refresh the spreadsheet was gone. Already checked Trash but isn't there. Can you help me, please? These spreadsheets are very important and i don't know how they just disappeared from my files. Thank you in advance.
Write in a cell of a locked spreadsheet Using VBA code
Hi. How can I write in a cell of a spreadsheet that is blocked? I mean: I need to collect information in a spreadsheet of an user and through a macro (button) this information is sent to the spreadsheet that is blocked for that user. The user can not write directly to the blocked spreadsheet, but he can enter in another spreadsheet where he enters information. Can this be possible? for example: There are three spreadsheets: Sheet 1, Sheet 2 and Sheet 3. Sheet 1 is a spreadsheet locked and no one
How tot color a block of cells with a condtional format
I would like te automatical color en block of cells (for instance B5 to D8) when in one of the cells a name apears. I have tried tot celect the block an formulate the conditi0on but a best one cells colors. What is the right formula or is in not possible in Zoho spreadsheet? I have tried text contains end trhe formula´s =$B$5="dave" and =$B$5=dave
Indirect() function not working
H, I had the following function in Excel INDIRECT("'" & $A4 & "'!" & C$2) when imported to zoho, I get an error, event though, apparently - indirect() exists - what is Inside the parenthesis works and gives " Act 1_1!C26" (tab & reference I want to get the content of..) Can you help me? Thanks Loïc
Finding a value in a worksheet via VBA
Hi, I'm trying to find a string (ex. "Smith, Joe") in a column ("A") in a sheet. First, it appears that Match is the function I should use, is this correct? If so, I cannot get it to work. Here is the code dim x as long msgbox (x) x = worksheetfunction.MATCH("Rabbit", WorkSheet("KeithQuoteData").Range("A1:A50"), 0) I'd appreciate any help with the Match function or a better way to search for a string and return its location. Thanks, Dennis
Dialog Box
Hi there, I'm trying to add a dialog box with vba to confirm that a certain action is about to happen and it just produce me a regular message box. The code: If MsgBox("Delete this Row?", vbYesNo, "Confirm") = vbYes Then Thoughts? Thanks, O-Ren
Adding more color and category to Charts.
Charts are the most effective way to represent data inside a spreadsheet. Zoho Sheet is constantly working on improving this marvelous tool of data visualization. Let's see what the current Chart update has in store for you. 1. Colors to make charts with elegance. Color Schemes Default colors can make your charts look monotonous. Hand-picking colors for each segment of a pie or funnel can also be tiring. Choose from the four sets of color schemes, or from the various other monochromatic shades. Already
Workbook_SheetChange is not working
Is there a reason for that? Thanks O-Ren
How to connect or link one workbook to data that is stored in another workbook?
How? Thanks, Oren
IMAGE(URL) Function on Spreadsheets
Hello ZOHO Team, I see that the IMAGE / IMAGE(Url) function is available now on Spreadsheets, I searched on Zoho's forums/topics with no results about this new feature from other users. How can I make it work? I already tried the following ways with no luck: =IMAGE(http://mysite.com/image.gif) =IMAGE('http://mysite.com/image.gif') =IMAGE("http://mysite.com/image.gif") All of the above functions just returns a !NAME# This IMAGE function requires most of all my imported spreadsheets To make World
Hours Calculation
Hi, I'm trying to sum some hours on my spreadsheet, but every 24 hours I get back to zero. How can I solve this or at least go around of it?
Zoho Spreadsheet not opening
All of my spreadsheets keep on loading but doesn't show any data
File is lost after being online 9 years
Hello, I uploadd XLSX file about 9 years ago and it was working fine untill recently. Now it's completely empty and I can not download it in original format either.
Unable to export spreadsheet
I have several spreadsheets that will not export or download. I have tried restarting the browser, clearing the cache, even rebooting the computer. I also tried copying the spreadsheet nothing is working.
How to insert combo box in Worksheet ??????
How to insert combo box in Worksheet ?????? Anyone have idea about it Please, tell me it's argent
Can't find a function
Could I ask some assistance in figuring out some formulas to perform a couple of calculations I am attempting to perform? I cannot find anything in the help files. Scenario 1: Let's say that, for any given row, columns E through X all contain numeric values, except that one and only one contains text. How would I perform a calculation that finds that occurrence of text, or even the "first" (of one) occurrence of text in columns E through X, and set that cell's value equal to the text? Secondarily,
Working at the same time in shared spreadsheet
When sharing a spreadsheet, we cannot work on it at the same time. If we use filters and i have it opened with a filter selected whoever is working on it at the same time will see his screen the way I see it, with the filters I selected so he has to stop whatever he is doing until I finish using the filter... Any suggestions? am I doing something wrong?
CMD + Select in Sheets?
Hello, Is there any way to use the traditional CMD select function? Normally its like the Shift + select, but it does not include everythign in between - only what you are clicking on while holding command. (might be control for PC users) Thanks
zoho sheet stuck
I Need help. ZOHO sheets stuck on the loading screen. I've already deleted the system cache and cookies of my browser (google chrome) but it's still not opening.
[Zoho Docs] Charts are changed after exporting from Zoho Sheets
This is what my excel sheet charts look like in Zoho Docs, After exporting, it looks like this. Is there any way to fix this? Please help.
Want the conversion of MS Excel function to Zoho format
My current formula excel formula is : =COUNTIF(D8:AH8;"*"&AI$7&"*") Can you please help me convert this in format of Zoho Docs.
How to count events that match multiple criteria?
hi, i'm have a table with information about specific meals: sept 1 Chris Burger Sept 2 Jane Pizza Sept 2 Chris Pizza Sept 3 Jane Chicken Sept 4 Jane Burger Sept 5 Chris Burger etc. . . What I want to be able to do is count the number of instances that meet two criteria (person and meal), for example how many times did Chris eat a Burger, and I want to do this for every combination of people and meal. What I would do in Excel is make a table with names
How to generate a random number
Hi I'm interested in some way of generating a randon (pseudo random I guess) number. I think some spreadsheet programs have such a function but couldn't find anything in Zoho Sheet's function list. I guess if not there must be some formula to replicate the function... -- Cheers Mark
Macros disappeared from workbook
With the recent update to Zoho Docs it seems all macros have disappeared, at least from my workbooks. I've tried downloading older versions and opening them locally in MS Excel to retrieve the macros but have not had luck so far. Does anyone know of a solution to this problem?
Spreadsheet issue
An interesting problem. I keep a spreadsheet of books I assign for review, with columns for title, author, reviewer, etc. When I have to update a row, I search for title or author, etc. The find action will locate the information I'm searching for and highlight the cell, but the other cells in the row don't align correctly -- the Title row, for example, is highlighted, but the Author row, etc., are for a completely different title. It's very frustrating. Is there a fix for this? Thanks.
Edit sheets in App phone
Hi guys, I am trying to edit sheets from my app in Android but It doesn't allow me, but when I want to edit some writting document everything is fine. Is there somehow to edit sheet by phone? Thank you, Alberto.
I cant edit my own file
I can access my file but i can't modify. Appears the follows message "Unable to connect to messaging server."
I am not able to edit my own file
Hi There For some reason, today am not able to edit my own file How to fix it? Thanks Akilen
Spredsheet won't let me edit
I can't edit the spredsheet that we have in our document.
Pressing Enter while editing cell now inserts a newline in the cell
This is dumb. People rarely need to insert a newline within a cell, but always need to finish editing a cell. Now there is no way to finish editing except to use the mouse to click somewhere else. Ctrl+Enter is the standard way to insert a newline in other spreadsheet software.
how to customize user privileges within a specific grid ?
Dear all Within a specific grid within a form, how to customize user privileges(such view,edit)? Sorry to my poor English,any help would be appreciated!
Next Page