Not displaying shared users
For the most part all of my users that I have shared the sheet with are displayed when I 'Edit Shared Details', HOWEVER one of my colleagues that I recently shared with is not displayed. Thus, I cannot edit their permissions or which sheets they have access to (for some reason they have access to everything which is a big problem). Please help as soon as possible.
INDIRECT function doesn't work with range reference
This formula returns correct results: =DSUM(Bank.A4:H249;"amt";$K$6:$L$7) This formula =DSUM(INDIRECT(L1);"amt";$K$6:$L$7) with Bank.A4:H249 in Cell L1 returns #VALUE!
Sorting an Embedded Sheet
Hello, I am using Zoho to manage some rosters on my website. You can see them here What I cannot seem to figure out, however, is how to make that sortable by column. I read that this was possible with Zoho and caused me to move everything over from Google. Any help? Thanks. ~Joe
I cant share my sheet on a link: error has occurred
heres a link of the error http://prntscr.com/9104g
is it a way to join sheets into one spreadsheet?
I have separate sheets for each quater and want to join them as one spreadsheet
Zoho Sheet as background calculator
I would like to use Zoho sheet as a "background calculator", this means I would like to set the inputs in a form on a external website, then automatically load the inputs in zoho sheet, retrieve the results and display them on the external website. Is is possible to do it? In such case, is the code of the zoho sheet accessible from external users or is it protected from copy? Thanks for advice, Aymeric
Copying a Zoho Sheet to save on other Sheet or word document
Dear Sir/Madam, Is it possible to copy a Zoho sheet to another EXCEL sheet or word document? If yes, how? I tried copy & paste. It does not work? Thanking you. Best regards, RAKESH
How do you link cells between sheets?
I want to start off by saying these applications are really cool. I would like to start using the spreadsheet. I would like to link a cell from one sheet to another. I would also like to name cell ranges. Are these features available in Zoho sheets? If so, they are not intuitive at all. I also find your Zoho forum search/Blog search to be a poor substitute for help. Are there plans to incorporate some better help in these applications? Thanks. rlieving
How to add color to tabs?
Any way tabs can be colorful?
Need macro - to open multiple hyperlinks
I'm way over my head with this but I'm looking for a macro that would open in new tabs a list of 8 links stored in contiguous cells Something similar to : Public Sub OpenURLList() Dim rowcount As Integer Dim urlToOpen As String Set ff= CreateObject("FireFox.Application") 'Show browser ff.Visible = True rowcount = 1 Do While Sheets("Sheet1").Range("A" & rowcount) <> "" urlToOpen = Sheets("Sheet1").Range("A" & rowcount).Value 'Open the links in the same browser ff.Navigate2 urlToOpen 'Perform your
maximum formula length?
I have succesfully uploaded a very complex XL spreadsheet. Multiple tabs, lots of lookups, etc. However all of my fields have the error "#VALUE". I assume that the formulass are too long for Zoho sheet to evaluate. Is there a spec of how many characters can be in a given formula, or how many nested formulas, tc?
dynamic integration
I'm developing a simple dynamic e-learning website for my school and was wondering if it is possible to integrate Zoho sheet into the website so that the teachers can upload the student grades on our website in the form of a .xsl file and have it dynamically integrated into their class page.
Lost work
Jeez. After an hour's work, I saved. But the work is gone.
VLOOKUP doesn't work properly again
Dear Zoho Sheet Team, I've reported a problem with VLOOUP five days ago. Then commented in the ticket twice. Nodoby's answered. Could you please take a look at the request number 1060024? Thank you. Such strange problems with cells format happens regularly. And that's very big problem. And nobody cares. Thank you.
Zoho sheets not functioning in IE
When I share the sheet. We get " Error Occurred " on the IE. It does work on Google chrom need it urgent
Sync sheets with desktop
Hello! There are various ways where you can sync your docs ( including sheets ) in Google Docs with desktop. What about Zoho? How to have an offline version of docs/sheets in desktop ( and better to sync with docs/sheets in Zoho ) ? How about Android facilities of Zoho sheets and docs?
Online Web Calculator
I would like to create a calculator in as spreadsheet and then publish it in my website. Can Zoho spreadsheet able to do that? Or, do Zoho spreadsheet have the hide and protect cell features? By the way, keep up the good work. Luv Zoho a lot!
Effacer
comment effacer le contenu de toutes les cellules d'un tableau ?
Sharing Question
If I share an sheet, does that person have to set up a Zoho account to view the spreadsheet? I made practice sheet and shared it with one of my own email addresses (a different address than I use as my Zoho username). If I am logged in to my Zoho account on another page in my browser than the link works fine. However, if I am not logged in to my Zoho account then I get white screen that says "Error Occured". I don't want people to have to sign up for an account to view the sheet, is this possible?
date format problem german
Hi zoho-team, are their any way to get the date format day/mounth/year (german)? Or are their any Country-settings in zoho for this? And how can I stop the autoformat? If I entry a date it's getting changed - unfortunaly to mounth/day/year. Thanks for your help and the great application :-) Rahim Germany
Sheet - Date Entry/Format
When entering a date the format appears to have to be in mm/dd/yy format, even if you set the display format as dd/mm/yy or dd-mmm-yy. Very confusing, and not standard for most countries. Can this be changed?
Date Format
I'd like to see UK date format as an option. I've just copied in some data from another spreadsheet but the dates are all wrong. Is this available or under development? halesy
copy some content pages into another worksheet
Hello, I have to following problem: I want to copy some content from a worksheet to another worksheet. I already tried with selected area, copy en tried to past in another sheet, and even CTRL C en CTRL V doesn't work. Is there a way to fix this? Regards, Jack
Zoho sheet under "https" url
I would feel safer if my docs in Zoho sheets are under "https" url. As I noticed, all sheets are under normal "http" link. Any way you can make safe pages by HTTPS so that we can upload some important sheets?
How to export one sheet to pdf
I have spreadsheet with multiple tabs. I want to export only one particular sheet. How to do it?
Zoho sheets laggy?
Hi, I am a new user to Zoho, switching from GDocs only a few days ago. So far I'm loving everything... For the most part I like it even more than G.Docs... but big sheets = Sloowwww... I have a Quad core, 12gb comp, and everything moves sooo sllowww on large spreadsheets. My browser is Google Chrome, is there a work around for this?
pivot table error
Hi, I am trying to make a pivot table report with data having 13 column and around 100 rows but unfortunately its showing error but its working fine with lesser amount of data say small ranges... is it a bug or ?? pls revert if any one having solution...
How do I Print in Color?
I need to print my sheet with color. When I got to print, the colors do not show up in the print preview screen and there is no option to change black and white to color. Is it just not possible to print in color or am I missing something? Please advise! Thanks! Ali
use zoho sheet for my work
Hello, I want to use zoho sheet for my work. I want to make a work schedule for my staff, about 15 persons. May i use Zoho sheet for free? Because it is not really for personal use... In the pricing table it says: Free for personal use. Business/Corporate users may be charged. Every Service Will have a free edition for individuals. There is a discount for non-profit organizations. So i was wondering if that is officially allowed. Regards, Jack
Zoho Sheet
Hi, While I like the advantage of having all my office documents with Zoho I am a bit concerned that quite a bit of the functionality is not there. Eporting a spreadsheet to a pdf should be fairly straight forward. However there is no way to tell Sheet or the pdf maker what page orientation I want. This is a must have!! Exporting to Open Office is pretty much useless. Calculations get completely messed up. Exporting to gnumeric works fairly well but again page orientation issues. Printing from Zoho
Renaming a sheet
Can I rename a sheet within a spreadsheet by referring to the contents of a cell? For example, if cell C1 contains "Don", can I fetch that and rename the sheet "Don"? Thank you, Don Simmons
Zoho Sheet questions.
I have made a graph on zoho sheet using two different lines and need a legend for it. How do you edit the legend (ours just says "1" for the first line and "2" for the second line) Also we have another graph that shows percent change. All the numbers are between -1 and 1 but the graph just shows "0" and no other numbers. How do we get more numbers on the y-axis? Thanks you
Recalcualte is time expensive
Hi, I've a macro that copies contents from one sheet (A) to another sheet (B). Sheet A has a sum function that sums up the 15 rows that are being copied from Sheet B. The row with the sum function in it is not copied from B. The sum does not recalculate so I had to add a range.recalculate line into the code. The range has 3 cells with a sum function in each. This one line makes the macro go from less than 1 second to about 5-6 seconds. I would like to have the recalculation take place without the
Publish sheet as read only
I wish to share a sheet with friends but I do not want anybody else to be able to change anything; i.e. read only. Is this possible? Although the sheet opens in public view as read only, there is an option to enable editing. I do not want this. Thanks in advance.
Linking various sheets.
Is it possible to link various sheets together, as is possible in Microsoft Excel? I would appreciate your help. Bert Richly bert.richly@gmail.com bert.richly
Copying a Range of cells to another sheet...
I have a main sheet (lets call sheet 1) that I update on a regular basis.. I want to take about 1/4 of that sheet and duplicate it on another sheet (Sheet 2) and then publish sheet 2 online. So I can just make changes to sheet 1 and they will update on sheet 2 which is a public sheet. I basically only want the public to see a part of sheet 1 (that range of cells on sheet 2) but only want to have to update sheet 1 for the changes to show on both.
Rules regarding VBA and shared/hidden sheets
Hi, I have a sheet with 6 worksheets. 3 of the worksheets are shared with a user. I have a VBA Change event handler and macros that get called using all 3 sheets that the users has rights to edit. Will the VBA run for the user? Thanks, Dennis
EOL for translate.sheet.zoho.com
We are announcing End of Life for translate.sheet.zoho.com, a service that allows users to contribute towards translating the interface text of Zoho Sheet to a particular language. The user-driven translation service will be available until Feb 29 2012 and will be shutdown after that. We thank each one of you who contributed to the translation of various languages. We will continue adding support for more languages in Zoho Sheet and our other Zoho services. If you have any specific questions on
Lastrow
Hi, I know I figured out how to find the last row last week. I accidentally deleted the file and now I can't seem to find a formula that works. I thought it was lastrow(). Please help! Thanks, Dennis
Deletion of column headings and row numbers
My Zoho sheet shows the column headings A - and row numbers 1 - . How can I delete these Many thanks!
Next Page