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!
Macros and Array Formulas
How can you use a macro to replace text in an array formula. I tried the find and replace macro from the wiki and it left only the result in the field not the correct formula Thanks, Dennis
VBA - Getting value from a merged cell
Hi, I am using name = Range("A1").Value where cell "A1" is merged horizontally with "B1" and where name is a string variable This generates an error. Is there way to get this value? Thanks, Dennis
On shared sheets, macro's won't run
Hi, I have created a sheet, that auto creates html code, we have done it so that those who run prediction leagues on our site, that don't know html code, can have the sheet auto create the html code for them. Everything is working fine, however on shared sheets, the macro's don't run. I have 2 macro's, the first is to sort the table by points, and the second is to reset the code on sheet 1, in case they accidentally edit the cells. As mentioned it works on the main sheet on my account, however the
Script busy error (crashes Firefox)
Hello, this has happened several times while updating a cell in my spreadsheet, and it freezes (unresponsive) my browser, Firefox. If I select either 'Continue' or 'Stop script' the error alert just come right back. Hope there's enough info there to take a look. Thanks -- Howard Ballinger
How can I open SHEET with a saved sheet of my own?
Sheet opens with a blank new sheet. Then I have to go to File Open and select a sheet of my own to open (almost always the same one). Is it possible to change a setting (I haven't been able to find one) which opens a sheet of my choice instead of the blank one when I open SHEET ? Thank you
How to make sheet editable to others?
Hi, I am new to Zoho Sheet. I created a sign up sheet for my group. I would like to have everyone in my group to be able to update the sheet. Many of them are not Zoho users. Do they need to create a Soho account to do update? Does Soho provide a link to my sheet so that I can send it in an email? And allows whoever click on the link to update the sheet? Thanks a lot. CC
where are the arrows ?
How to go to the next cell / column ? E.g. From L1 to M1 which is not seen In the table ? Or from L2 to L1 ?
Problem with collaborative edition
Hi, I've done a pretty basic test because i was having issues with collaborative edition. It's just php communicating with zoho sheet The main problem we have is, with user A and user B both working on the same document, sometimes the communication between them is not working fine, user A quits the session but user B zoho environment still flags user A as connected, and when i connect to the document again with user A, user B sees user A connected twice! This behaviour seems to be quite random, but
Record deletion issues
Hi, Myself and about 7 others are collaborating on a Zoho Sheet file. The problem is that there seems to be frequent data loss. We suspect sync issues but can not be sure. Has anyone else run into this problem?
How to subtract 2 numbers
There seems to be no help functionality in Zoho sheets so I have to go onto the forums for such a basic problem, please help, thanks
How can i share my docs. to others? it doesn't work for me. i want it shared as READ-ONLY
hi , I already input the shared username with the specific docs. but it doesn't work still. what's the solution for this?
Help, unable to open a spreedsheet
Unable to open a spreedsheet, this is what I see Se produjo un error Zoho Sheet Se produjo un error Problema al abrir el document
Listes et Validations
Lors de l'importation d'une feuille Excel, les listes de validation ne suivent pas. Il est impossible de les reprogrammer sur Zoho Ou alors, je ne sais pas faire!
Zoho Sheet calling webservices
Is there any example of a Zoho Sheet automatically calculating some cells by calling a webservice or ODBC call. Also, is the webservice called on the Zoho server or on the clients PC ? thank you for thois great product. guido
New in Zoho Sheet - Format Painter, Vertical Merge, Goal Seek and more
We are glad to introduce the following new features in Zoho Sheet. Format Painter Merge cells vertically Goal Seek Chart enhancements .. and more Here is a slideshow with screenshots. You can learn more about these features below this presentation. Format Painter: Format painter is used to copy formats and styles of one or more cells and apply them to other cells. This helps you in formatting your spreadsheet the way you want in no time. To apply the format of the selected cells on to another range,
Problem with importing Google Spreadsheets
I have a problem with the Google Spreadsheet import function in Z-Sheet. A Google spreadsheet recently shared does not show up in the "fetched" Google spreadsheets list no matter what I do. Things I've tried: Making a copy so the account owns the Google spreadsheet I'm trying to import Changing the name of the Google Spreadsheet Signing out of Google docs and Zoho, then back in Closing the browser and re-opening OS is Windows 7 Browser is Google Chrome
The same VLOOKUP problem with every file
Dear Zoho Sheet Team, We've been facing the same VLOOKUP problem with every file we loaded. The latest one is "docid=1332883000000036025" Here is the problem: we have couple of sheets inside this document and VLOOKUP function between them. If we import this document from local file (we did this three times), everything works fine. But after one day this function got broken somehow and VLOOKUP shows 'N/A' in every cell. Please, help. We can't work. Thank you.
vba program doesn't work
Hi, I' ve written a program in vba but there's an error while I'm running it: "Encountered error at line 18 :com.adventnet.zoho.websheet.model.util.DataRange cannot be cast to com.tripi.asp.JavaObjectNode" what does exactly mean? my line 18 is: Do While Sheet2.Cells(2, kolumna_dzien) <> "" the same programs works well in excel :( thank's in advance for help. (it's a pity that there's no ability to get into program in "step by step" mode (F8 in excel vba editor) with locals window) p.s. all sheet
Next Page