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 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!
Publish to External not working in spreadsheet connected form
hr@devfactori.com: I'm trying to create an online form (linked to a spreadsheet in Zoho Docs), that should be visible to general public. When I press "Form" to publish this form, it gives me two options: -Within Organization -Publish to External Within Organization works fine, it gave me a URL that I shared with the employees within the company and it's accessible to all inside the company. But with "Publish to External", as when I wanted to share the form with general public. I pressed this option
Server down again
The server has been down all day here. Can not update or print my spreadsheets. Can someone advise when this is likely to be fixed.
losing a sheet
i just made a very important sheet using zoho. but while saving, it got lost and isnt opening. showing there is some error. i must get the sheet, it is very important. the link follows https://sheet.zoho.com/sheet/editor.do?doc=bffb24df9c4dc13a81966d0c074729cd98fe7a8ae71716bacd8cbc8bcaf1ef01aedfd1a4e81bcbece58d110d3e51d68d477905e4eb3516c69946b9e79d565583
Spreadsheets, print to one page
Is it possible to print a spreadsheet to fit all on one page ?
Edit Client Info with Zoho Sheets?
Hi, I want to edit the "Client Type" column for all my clients, one-bye-one. I guess the best way to do it would be the "Zoho Sheet view" and I was able to edit the info for about 50 of my clients. But after that the list ends and if I set the filter to "Client type" and then "must be empty" an then go to the "Zoho Sheet view" it will bring up the same clients again. Is there any way to look at all my (500 or more) clients with the sheet view or at least filter them in a way that only clients are
is it possible to copy a colum from excel to a zoho sheet?
We are in our trial period. I opened an excel spreadsheet in Zoho. However there were some added lines this morning that I just found. I would like to copy them from the original excel spreadsheet to my new Zoho sheet. How to do that? Copy and then paste does not seem to work. dc
#EVAL! error
Hi , I am trying to Match a partial of a string of a text "g" in range that has at least one cell which has a word that start/contain "g" : range : {q, ddfd, gsdfsd, rt} as follows =MATCH("*g*";$AA$13:$AA$18;0) I was supposed to get : 3 but I am getting this Error : #EVAL! Kindly help.
Next Page