How to save Zoho Sheet online?
What happened to the save function in order to save Zoho sheets? Up until the end of last month (April 2013), I have been updating our Zoho sheet .xls file wiithout problem, but now cannot do it. Why is this? I don't want to 'Save As' a document or template, just save it like I could before, so that each time I sign in to Collaboration APP Docs it is there each time. How can I now do this? If this function has been deliberately removed, could I ask why this is?
signing out of spreadsheet
Hi Can you tell me why this message keeps appearing when I try to use the sign out at the top right corner with the spreadsheet open. The page you requested was not found Sorry about that! The page you were looking for may have been moved or the address misspelled. 1. It is possible that you typed the address incorrectly. 2. The page or file you are looking for has been moved or does not exist Surely the sign out is a link within zoho spreadsheets, so it has to be something that is wrong at your
How to limit a data feed (external data) to 100 rows
I have a URL to a website that provides lottery results going back many years. It is updated twice a week. I only need to review in my Zoho sheet the most recent 100 rows. Is there a way to use the external link process to limit the feed to just 100 rows? Here is the URL (for reference). Thanx. http://portalseven.com/lottery/megamillions_winning_numbers.jsp
Hide and lock formula cells doesn't seem to work
It has been a while since I have used Zoho, but I remember using the hide and lock formula cells in the past to protect cells in a document that I published. Now when I try to use that option, it does not seem to work. I can change/delete the cell contents in cells containing formulas. This used to be my workaround for not being able to protect cells. I'm pretty sure that I'm not missing anything on how to activate the option to hide and lock formula cells. I just go to Publish and click on the
Charts are not showing in HTML view
Hi, Maybe I have not used the search function good enough, but I couln't find a topic concerning my issue. The problem I'm facing at the moment, using the Zoho Sheet trial, is that when I publish my workbook in HTML view, the charts that I have created within Zoho do not show. Whilst in editing mode I can see the charts correctly, in HTML view the charts are replaced by an image not found logo. Did I do something wrong or is this a known bug?
Spreadsheed edited by someone with "remoteapi" but not by me
Hello, i got constant problem with my spreadsheet - someone is editing it but i don't know how it is possible. But from start: I created Calculator with spreadsheet: https://docs.zoho.com/sheet/published.do?rid=hym92cbe12f0b69f44f62a5d3624d15407c30 Before Zoho 3.0 all was fine. No one could edit it when shared that link (it was: https://public.sheet.zoho.com/public/kicksaw/pokelifecalc-1, instead of that above). Now after this patch i found that someone constantly edit that calc and i need to make
Auto save not saving
Hi, I thought I was going to like the new auto save instead of manually saving every time, but now not so much. Everything I updated in my spreadsheet the other day is now back to the way it was before I updated it. Even worse is all the NEW data I entered is MISSINGfrom the 9th of April through to the 26th. Just vanished! :( Auto save "saved" it every time, so I can't imagine what happened? Do we still need to "save" manually again before closing the page when we are done using it? I am very
Formula RECHERCHEV() doesn't work ?
Hello I am making a database and i need to index my data using the formula RECHERCHEV() who works on Office Excel and LibreOffice Calc. I am unable to use that RECHERCHEV() formula on ZOHO Sheet (give me #NULL!) I am not an expert but it works pretty well on Excel and i made the same formula. Can someone help me ? I can share the sheet it's pretty easy to understand what i want to do. Thanks.
HTML View not working since last maintenance
Since the website was down for maintenance on 27 April 2013 and now is online. The spreadsheet view can be seen https://docs.zoho.com/sheet/published.do?rid=9jhz5d5bcf0ce7a494a719fa5a81e5d98553c But the HTML view is not working https://docs.zoho.com/sheet/published.do?rid=9jhz5d5bcf0ce7a494a719fa5a81e5d98553c&mode=html Hope you can check for us. Paul M.
Problem with Dropdowns After Uploading
I have a workbook that was created in Excel with some dropdowns built into it. When I upload it to the site here the dropdowns no longer work. Am I doing something wrong? It is an .xlxs file if that makes a difference.
Unable to create a sheet document (without import) ..
Hello I am unable to create a sheet document here https://docs.zoho.com/index.do I am on |Favorite| > [All documents| Where i try to create an empty sheet i got a error page. How can i fix it ? please. Thanks.
Referencing a cell from another sheet
My workbook has multiple sheets. Each sheet has some calcluated totals in certain cells. The front master sheet has a list of everything that is detailed on the other sheets, with the totals. These could change at any time, so the totals need to be references to the other cell's value, not a fixed number. So on the master sheet, I put in =, then go the other sheet and choose the cell and hit Enter. In regular Excel, this works. But in the Zoho sheet, it doesn't work. I have to edit the result by
embedded sheet not displaying info in field
www.ranchsortinginfo.com Have embedded code on the above site. I only want one cell with an amount in it and wish to display only that cell. I have reduced the code to read: The cell info is $1.94, but displays blank on the website. <iframe width="150" height="75" frameborder="0" scrolling="no" src="https://sheet.zoho.com/publish/palominopropane/ppg"> </iframe> Any help or suggestions appreciated. Amy
can't split cells
Merging cells works OK, but splitting doesn't seem to work at all. Anybody else with this problem? Any help? Thx
formulas
how do i apply function noyes
Office Plugin not saving VBA code?
Hi, I just installed the Zoho Office Plugin, opened up Excel 2000 (which as advertised it does work with), created an Excel file including some VBA code, saved the file locally, then used the Zoho plugin to Save the workbook. I then closed Excel completely. I logged into Zoho, went to my Documents folder, the Excel file was there. I then used the downloaded icon to download it and open it as an XLS file. It opened fine, but when I checked with Alt-F11 for the code, Module1 was not there nor was
UK Date Format
It's been a long time since I last asked the question but still don't a see a solution. Is it possible to enter dates in UK format? i.e. 3/1/10 means 3rd January not 1st March
Autocalculating of the cell "address" doesn't work with complicated formulas
Dear Zoho Sheet Team, I have a (simple) forumula: =IF(C5="*";CONCATENATE('from ';b5+2.5);b5+2.5) It works fine. But when i try to "pull" it by mouse to the end of the column it isn't being autocalculated/autoupdated. So it always the same, but must be something like: =IF(C6="*";CONCATENATE('from ';b6+2.5);b6+2.5) =IF(C7="*";CONCATENATE('from ';b7+2.5);b7+2.5) etc. Thank you.
adding and configuring Comments in Zoho Sheet
how can I make my comments in Zoho Sheet visible all the time?
Why is it impossible to make a sum function
Hello Zoho Team, I've created a spreadsheet and it is impossible to use the SUM function! Could you help me to solve this problem please? Thanks Fabien
User defined cell format works wrong
Hi, As far as i can see, you still do not support different document locales (such as Russian), so we can't enter date and time in our local format. As workaround, i added a user defined format 'dd.mm.yyyy'. It works fine, when i select already entered dates and change cells format. However, when i format empty cells with that format and then enter date like '03.05.2013', Zoho Sheet makes it '05.03.2013'. How can we eliminate that behaviour? Users do not understand they have sometimes enter dates
Pivot Table scroll isn't working
There are two vertical scroll bars on the Pivot Table page - one inside the Pivot Table and one for the whole page. Neither scroll bar is working. Also, the table is missing some data.
Selecting Cell Problem
Hello, For the past two days, when I go to select a cell on my Zoho Sheet, it automatically selects one that is 2 cells down from the one that I want. I keep having to arrow up to get the one that I intended on selecting. Please help. Thanks!
Maximum limit of rows exceeded
I am trying to add a row to a spreadsheets that has fewer than 60 rows. I keep getting an error message that says I have exceeded the maximum limit of 65,536 rows. Any ideas out there?
Unable to Save Spreadsheet
I am constantly receiving the below error message when trying to save a spreadsheet whether from work or from home. This has been occurring for the past several days but also occurs intermittently since we've started using this product the end of last year. Error: Unable to save. The document exceeds the prescribed size limit (i.e., 65536 rows and 256 columns per worksheet or 1 million cells per workbook). Please reload the document to continue working. The data entered in the last few seconds
Drag-Copy multiple cells with CTRL increments Date
Hi Zoho - great suite of applications and for free! Superb. Basically, I expect Sheet to behave like Excel - I hope that's not "wrong" as such? One thing I can do as expected is to select a cell with a date in it and then "drag" the bottom right corner of the cell down to fill in the cells below. When I do this, the date increments by 1 day for each cell. When I hold down the "CTRL" key while I'm doing the drag, the date does not increment. This is good. HOWEVER Unlike Excel, when
sheet vba http request
I saw a blog post from a couple years ago about adding http request functionality to Zoho sheet vba scripting (https://help.zoho.com/portal/en/community/topic/revamped-vba-macro-engine). I couldn't find any documentation on it currently, has it been implemented or is it still likely to be added in the future? It would be really fantastic if it is - it would add a lot of functionality for me.
Header/Footer
Hi, I've imported an .ods file into zohosheet, but I can't see where, if at all, I can modify the header/footer. It seems like you do recognise the info and preserve the data, since if I export it back to pdf it is still visible. Thanks, Marko oo
There is difference in results of YEARFRAC formula
There is difference between Zoho Sheet and Microsoft Product in results of YEARFRAC formula. You can download a test file from this site(http://plugtest.opendocsociety.org/doku.php?id=scenarios:20100415:yearfrac) and result is this(http://www.slideshare.net/slideshow/embed_code/16726545?startSlide=30). I do not know which one is right but there is difference.
how to add 7 days to a date?
I update a spreadsheet weekly and would like to write a formula that says "add 7 days to the date in cell c2" How would I do this?
adding days to a date
Hello, I would like for a cell to be the result of adding 7 days to a different cell. How can I do this?
Downloaded PDF file does not have pdf extention
When I want to print a sheet, I download it as a PDF file. It downloads on my desktop without the proper pdf extension. Everytime I have to rename the file - add the pdf extension. Anything I can do about it?
How to remove email address underlining?
How to remove email address underlining in a sheet? I already tried to remove hyperlink, to remove formatting. Nothing works.
Page loads to embedded sheet not at top
I have had for some time a Zoho Spreadsheet embedded in several blog posts on my Wordpress web site. Recently, I noticed when a post containing this sheet (actually, any Zoho sheet, I tried a few tests) is viewed, the page momentarily loads properly, then it skips down the page to the sheet. I see that this occurs in Firefox, Safari, and Chrome, but not in IE. It also occurs in different recent versions of Wordpress. This appears to be a Zoho problem. I have other posts that use iframes (one a Zeemap
Please Help
How can i save my excel file on the embeded file from my blog
[How] Synchronized ranges on different sheets
For example, I have 3 sheets. Sheets 2 and 3 have an own table per sheet. On the Sheet 1 I want to have both these tables and it have to be synchronized. For example, when I modify a cell in the Table of the Sheet 2 - It also modifies in the table on the Sheet 1 (which includes 2 tables from Sheet 2 and 3). Otherwise: when I modify cells in the table on the Sheet 1 - it modifies in the table of the Sheet 2. Do you have such feature now? If not - Are you going to do it?
Can I duplicate a document
can I duplicate any of my documents into a new one and then edit it from there? If so can someone tell me how? Thank you
Problem in Export of Zoho Sheet into Excel
Im not able to export the data from zoho sheet into excel. I need the data urgently pls help.
Error Occurred alert when attempting to open Sheet document
When I click on the link for any saved Sheet document, the sheet does not load and following error message appears: Error Occurred Zoho Sheet Error Occurred Problem while Opening the Document Creating a new sheet, saving it, and attempting to open it gives the same error state. Hopefully this will be resolved soon. KM
How does (or why don't) AND(...) work with/as an array formula function?
Note: Gnumeric and ZOHO Sheet works the same way so there could be a good reason for it. Say we have two collums with a x and y patttern x x x y y x y y Add the same pattern 3 times to get some data. Lets say we would like to count the rows containing x in both columns. I did expect this formula to work: =SUM(AND($A1:$A12="x"; $B1:$B12="x")*1) (Finish with CTRL+SHIFT+ENTER to specify array function). But it does not and returns 1 rather than 3. A formla that works is =SUM(IF($A1:$A12="x";
Next Page