Document Not Saving
Whenever I try to edit a few of my spreadsheets, it says "Your edit is not applied to the document. Please try again later." It has been saying that all day. The documents in question are 'clangoal' and 'clangoalafrobros'. Wasn't sure if this was a global issue or not, so thought to post it here to find out.
Help
I cant open my spreadsheets ? Sorry, We could not process your request ! Possible reasons: › The URL may be incorrect. › The spreadsheet might have been removed. › You do not have access to this spreadsheet. Why? Gil
I cannot open any of my sheets
All of my sheets are unavailable. I get a message stating "We are unable to open.." It offer to let me try to restore to a previous revision but of course that does nothing. I would really appreciate having my docs back. These are shared publicly and the tool is completely broken.
Concatenate
Can someone help me create the correct formula? I want to concatenate the following URL with the text in a cell. Example: I want to combine the following URL with cell A2. Anyone help? https://ahrefs.com/site-explorer/overview/subdomains/
How To - Creating a new list based on conditions
Hello, I am trying to "Creating a new list based on conditions" where I want to use DATA from Sheet A and a Criteria I define to build a new list on Sheet B. This is demonstrated for MS Excel at: http://www.excelforum.com/excel-formulas-and-functions/646118-creating-a-new-list-based-on-conditions.html#post1926757 How is this possible in ZOCO Sheet please?
ZohoSheets
Hello I have embedded a zoho sheet in my website but at the top of the sheet it says "save to excel" and also "Powered by Zoho". I want to remove both of these items. Please can you tell me how to do this. Thanks
Spreadsheet problems on Airset
I am an Airset subscriber and I use one Zoho spreadsheet to manage some data. Two problems are occurring: 1. When I edit a spreadsheet then save it I get a message saying, "Unable to safe spreadsheet." However, if I close the spread sheet and reopen it either in View or Edit mode the changes are there. 2. Today I was trying to insert a row and NONE of the methods to insert a row will work. The most that happens is that the line focus shifts down or up one line depending on which insert I clicked.
can't print spreadsheet from Zoho Sheet
Hello, I can't either print or download spreadsheet which I upload on my own. When I'm trying to download it, I get attached error message. And options "Print..." and "Export as" are greyed out in menu. Does it depend on my organization settings? Where administrator can change it? I actually don't have access to my documents, only view. Regards Eve
ZOHO
WANT FULL SCREEN DOESN'T OPEN SPREADSHEET THE SAME AS EXCEL, TOO SMALL. wjhowell
Long text fields being truncated in Zoho Sheet
We were waffling on whether to use Zoho Docs or Google Docs and had tentatively decided to go with Google Docs. Yet, when I discovered the problem with Goggle Spreadsheet where long text fields are truncated upon view even when the adjacent cells are empty, I started thinking that maybe Zoho Docs was a better solution. Yet, this same problem seems to exist with Zoho Sheet. Is there any resolution to this problem with Zoho? Below are some links related to the problem in Google Spreadsheet: https://productforums.google.com/forum/#!topic/docs/20xY1KEjFxo
My file won't load
When I try to open my spreadsheet the screen says "loading" but the file never actually loads. I have information in the file that I would like to access but I cannot. Please help. (I've attached a screen shot).
Can I hide the VBA code of sheet that is being shared with the public?
Can I hide the VBA code of sheet that is being shared with the public? How is that done? Thanks you very much ^_^
xlsx Error
I am unable to open a spreadsheet and got the attached error message.
Public Spreadsheet.
Hi I want to create a spreadsheet where random people can input random names (not case sensitive) into a field, then that name will be input into the spreadsheet, if exists then it increments a count for that name and if not inputs the new name to a new line in a specific column. Is this possible in excel or do i need a database of some kind? Could anyone send me some examples of formula if it is possible? thanks
#FN_NOT_SUPPORTED - VLOOKUP & ISNA
Hi, I have the following VLOOKUP reference working ok in Excel 2013 however an issue using Zoho Docs. I have change the "0" to FALSE however now instead of #FN_NOT_SUPPORTED i'm getting #NAME! Here is the cell MS Excel =IF(ISNA(VLOOKUP($Q10,Interest!$D:$E,2,FALSE)),"",VLOOKUP($Q10,Interest!$D:$E,2,FALSE)) Zoho Conversion =IF(ISNA(VLOOKUP($Q10;interest!$d:$e;2;0));"";VLOOKUP($Q10;interest!$d:$e;2;0)) Zoho Amendment =IF(ISNA(VLOOKUP($Q10;interest!$d:$e;2;FALSE));"";VLOOKUP($Q10;interest!$d:$e;2;FALSE))
Zoho Docs stick words in some parragraphs in Excel File
Hello Guys, I have a problem, some times, when we upload an Excel file, we begin working on the file, and when we finish the job, we check the file, and we find some few words are sticked, the words are together without space, and we didn't it. It is something related to the formating, i guess. But this issue is doing to waste a lot of time, fixing our translations, once it has been finished. May you help us? Director www.TECNOSeguro.com
Hotkeys or SendKeys options in Zoho?
I don't know much about writing macros or VBA encoding but I would like to know a method to popup the comment box of a an active cell with a macro. I know that I can do it pressing Shift + F2. But my colleges in the company asked me to create a button in the spreadsheet to do the thing. I made it successfully in excel using the "SendKeys" method of VBA. If there is any way to create a button that pop ups the comment box and put it ready to edit it (the same as Shift + F2 combination) I will appreciate
How can I make a "SaveAs" or a "Export as" macro?
When I look at the methods supported by Zoho VBA, it appears "SaveAs" and "Save" method, but when I try to create a macro writing the code, it doesn't work. It says that is not supported. I'm trying to make a sheet for my company which data changes all the time and need to save a copy in pdf format several times a day. I know I can do it manually, but due the nature of the work is necessary to do that task just clicking a button in the spreadsheet. I have others issues to solve, but I'll do it in
upload/save multiple sheets -- Storage API
Hi, I am just wondering is there any way to upload(new) a workbook with multiple sheets through API? or to save a workbook with multiple sheets through API? Thanks, Sasi
External Data Does Not Update
I have 3 external data links within my spreadsheet. Of late they do not seem to be updating my public display link, but when I access the file(spreadsheet doc) itself the figures have updated. The update is set up on daily with a 1 minute interval space for each external data link (22:52 & 22:53 & 22:54) Does anyone else have problems with external data not updating their public viewing sheet? How do I go about getting it to update daily, instead of me actually opening the file (spreadsheet doc)
Publish to PDF 2 sheets out of 10
Is there a quick way to publish to PDF only 2 out of 10 sheets rather than the all the sheets?
New Problems with Embedded Spreadsheet cells
I have used embedded spreadsheet cells for several years now, and it's always worked as I expected. During the past couple of months I have had recurring problems - severe enough that I may need to stop using Zoho Sheet for my intended purposes. Here is a blog post that explains one of the ways that I have used embedded spreadsheet cells: https://community.desire2learn.com/custom-widget-semester-countdown/ On the same blog, you'll also notice a "live" (not so alive, apparently) example of a Zoho
How to get rid of ' in Zoho shhet
When I export values to Zoho docs, they will be starting the numerical values with the character '. I don’t not know how to get rid of these. find and replace does not work in Google docs. If you exports them to excel are not visible and I can not do calculations. How do i do?
Sheet with two tabs - how do I hide one of the tabs?
I've searched and searched but I don't understand how to hide one tab that has formulas I need to hide from the public. I'm publishing my sheet with the embed option with the iframe. My first tab is an interactive calculator that works so that's good. Just need to hide the other stuff. Thanks! -Scott
Is this possible?
Hello all - I know this is probably an obvious question but I'm kinda tired of reading all the help sections and messing around with the program without finding a conclusive answer. Here is what I would like to do: I made a spreadsheet with only a few columns (I wanted one to be a drop down.... But I found that Zoho does not support them... lame... Anyway, what I need is about 30-40 computers at once to be able to access the spreadsheet and be able to change the data in two of the columns as they
Spreadsheet doesn't download
When I go to Spreadsheet the only thing I can see is a small rectangle in the center saying "Downloading" and nothing else happens. The Documents works correctly but not the Spreadsheet, does anyone know what the problem may be? Thanks.
zoho sheet - conditional formatting - date
Hello. I just started using ZOHO, and it seems very useful. As I did in Excel and in Google Docs, I want to color cell(s) if the value of date is after today using conditional formatting. but when I set 'after' I can only insert a specific date in the following field, not a saved word (as today, tomorrow, next week, etc.) thanks a lot, Lior.
Is there a way to keep website visitors from editing cells?
I know that any changes to cells are not saved... that's good. However, I don't want my visitors to even be able to click and edit the cells in a spreadsheet at all. Right now, if I click on a cell, I can type whatever in it... then the only way to see the original data is to refresh the webpage. Is there a way so that none of the cells are clickable? I've locked and hid the formulas but that does nothing for keeping this truly unwriteable. Thanks.
Fractions
Is it possible to format cells as fractions in Zoho spreadsheets? Thank you!
Filter by background color
Hi Wanted to know if you could implement, or if there is a way to filter using background color Excel's latest version have that option... please let me know. thanks
Empty Rows
Many of my worksheets consist of approx 120 - 150 rows. However, most worksheet somehow have additional rows, up to 2500.I tried everything I could think of to get rid of those additional row, but I cannot get rid of them. How do I do it please? Best regards Hans
Calculateing hours in a week problem
Hello, I am trying in spreadsheets to calculate the hours spent at work. I have the formula right, it gets me to the result i need, but the program doesn't know how to display it (i goes H:MM, but i need something like [h]:mm). Because every 24 hours added it goes back to 0, so if i have 12 hours and add another 13 hours, instead of displaying 25 hours, it shows only 1 hour. Any ideas? (sorry for the bad spelling - not my first language)
Zoho Sheets not loading
My Zoho Sheets will not fully load. When I try, they get stuck with the "Loading...." message. This happens with IE 10 and Firefox 25. I can, and have, successfully downloaded the sheets to my computer to get work done. Is there a fix for this? Steve
Hide columns
How do I hide columns?
Randomize formula only works to display a different word from sheet if it is closed and reopened
Hello, I have created this sheet https://docs.zoho.com/sheet/published.do?rid=iea9rc50e0eaabc63444e937ab6b1b88c6ef5 Currently, to see a new word displayed on the main sheet from the list of word from the Word of the day tab, I have to close the sheet and restart it. Is it possible to have the sheet in a way that by only clicking on the Word of the day list tab and then the Main page the words keep changing? Thank you
Permit input without saving?
I need a spreadsheet to serve as a calculator for specific game theory equations. Users must be able to input values and get results, but unable to save any changes made - same as a read-only xls on a PC. How do I do that?
Issues with Excel Viewer
Hi there, Much thanks to ZOHO for producing such an amazing program. Im trying to display spreadsheets in my webapplication however im trying to stream these documents from outside the webroot to increase security. I have a fileserver.php file which reads in the file name and the jobid from the URL ie http://www.blahblah.com/fileserver.php?filename=spreadsheet37.xlsm&jobid=4987 when i put that url in https://sheet.zoho.com/excelviewer it finds and displays the file. HOWEVER when its running through
The value of a cell, from one sheet to another sheet (in the same document)
Hi everybody! I am from Spain, so it's quite difficult to explain the question I have, but I will try it and I hope you will understand my problem, and, hopefully, you can give me a solution. I have created one document (spreadsheet) with different sheets in the same document. And I just want to put in one cell of sheet 4, different values of sheets 1, 2 and 3, so, to makes balances. I am trying, like in Excel, to put "=", and I go to the sheet, click the cel, and push Intro...and this should work,
Sharing spreadsheet
Hi 11 weeks ago I was able to share a spreadsheet with colleagues by clicking the share tab and entering their user names in the box that appeared. This facility no longer seems available. How do I now share the new spreadsheet with colleagues. As we are a school it is the free version of of zoho docs that we use. Help please as this new spreadsheet is for the next 8 weeks and we have been using zoho for the last 2 years. Thanks Elaine
Spreadsheets- how to make gradients?
I wish to insert a row which is just a gradient bar, but see no way to do that with Zoho. Any suggestions?
Next Page