Can we protect a spreadsheet from downloading.
I like this application.. but overall i want additionally like.. if i have restricted a spreadsheet with user group and their role like read only or read / write only.. But still user can download the file.. is there a way to password protect is so if i want then only user can download or something like a option to disable download feature for selected account. please reply urgently.
Is it possible to change the cell sizes for the entire sheet?
Is it possible to change the cell sizes for the entire sheet? Thanks
How to stop export of spreadsheet
Hi, How can I restrict an xls sheet so that a person sharing is not able to export, or copy and paste the data?
Notify Shared Users ZohoSheet
Did you remove the option to notify shared users in ZohoSheets? I have a shared user and I used to be able to send a notify email with a link to the sheet when I made changes. That no longer seems to be on the shared menu or am I just missing it? Thx. -Rich
Excel Workbook Issue.
Bonjour, My Excel workbook (2.5 MB with few rows) once successfully uploaded and imported into Zoho (according to the message provided by Zoho) does not show into Zoho Sheet. It only says: The preview of this spreadsheet is being generated. It will be available after few minutes. If you like to download this spreadsheet, Please click here to... The only option I have is to download the file and edit it in my local Excel application. What should I do to make it work? Thanks. PM
can column width or row height be changed?
may i know if column width or row height can be changed? thanks mamaboy
sheet
I cannot figure out how to (I do not know your terms) 'fill the gap', 'delete a line', 'merge cells'...etc... on a spreadsheet. I created a spreadsheet with 143 line items, deleted 4 lines, but cannot ' fill the gap' on the sheet. Pease help. Thanks
DATE FORMAT
Please advise. Trying to create a spreadsheet where one column contains date in dd/MM/yy format and another contains the time in HH:MM format. My first problem is that when I enter any date, other than one in the current month, the format changes to mm/dd/yy or MMM dd,yy. I suspect it's something to do with the MM rather than mm? Why is the mm option not available anyway? Also want to sort sheet on date first and then time so rows are displayed in date and time order. The sort option only appears
Paste Values
I am trying to figure out how to paste a column of numbers as values. Has anyone figured it out?
How do i copy cell's value not formula
Dear Zoho Sheet Team, Is it possible to copy value from cell, not the formula? For example, a have a cell with a formula like =A1*1.18 and would like to copy the result to another cell? Can't see that function. Thank you.
connection to server has been lost
Now able to get into zoho but still getting the message that the connection to the server lost and to open the file again, do so same message. This happens every time I try to load the sheet. Have logged on using the same computer and a different persons login, this works fine (opens in a new window) Have tried as myself on different computers, connection lost retry message. (reloads on the same page) As the author of the sheet I would like to be able to get access as myself and not have to use
Page header and foot note
Hi there, Just started using Zoho sheet after many years of Excel. I cannot find the function of adding a header or foot not in a sheet. I cannot find the Page set up funtion either, e.g. adjust sheet margins etc. Can someone help?? Best regards KOD
Numbering
Hi! I would like to know how to add a column with an automatic numbering system, numbering our clients. At the moment if I look at my spreadsheet it's just a long list of names and information. By numbering each client, the list will be more structured and easy to work with. Please help? Kind regards, Ninke
Can someone help with this Martlett code?
In Excel, this code works, but in Zoho, nothing happens when cells A3 through A100 is clicked. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("A3:A100")) Is Nothing Then Target.Font.Name = "Marlett" If Target = vbNullString Then Target = "a" Else Target = vbNullString End If End If End SubWhat it
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
Next Page