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
Zoho Sheet inserts strange values while dragging down a formula
Dear Zoho Team, I've just made some experiments and can't figure out what's happening. I have a cell with a value '2011-01'. I drag this cell down by mouse and expect it would be something like 2011-02 (or at least 2011-02, as in OpenOffice by default). But it becomes '202 - yes, with that apostrophe at the beginning. Furthermore, if i have a value 2011-100 and the drag it down, everything will be correct, next cell will have 2011-101. First of all i thought it was related to date somehow. But
No Longer Able to Export Shared Sheet
About 6-8 weeks ago we no longer have the ability to export a shared sheet. When selecting File-->Export-->(Any available download type), the action does not respond. I setup the shared document for the owner and am currently a shared member. The document link is: https://sheet.zoho.com/open.do?docid=1323873000000006015
Script Error in MS Office Plugin
The pulgin doesnt work in excel or word. This is the error from excel. Any help?
Conditionally Displaying Columns
Can I conditionally display a column in list view? I only want to display the column if there is a value associated with it.
British date support
Hi, I find it particularly annoying that whenever I type dates Zoho Sheet insists in formatting them in US date format (i.e mm/dd/yy), even if I've set the date format to dd/mm/yy) - can this be fixed at some point please?
最好有筛选功能
少了自动筛选功能的话，是用Excel者不能容忍。
Office Plug-in not working from Excel - No response on File/Open command
I have an existing zoho sheet. from excel, after login, open Zoho Sheet has no action/no response. Originally i received an error message. But after several application restarts, no errors and no response.
running total
how do I setup a column which does a running total of another column?
INT does not round negative numbers down
I'm trying out Zoho to see if I can use it as a replacement for Google Docs. In trying to use the INT function to round all numbers down; it is rounding negative numbers up. The example shown in the documentation: https://sheet.zoho.com/functions#INT does not work. (It rounds -1.3 to -1 instead of -2.) This is breaking compatibility with another spreadsheet I'm trying to migrate over. Thanks!
displays negative
When a field is in euro and include decimal places, displays negative
Inserting a one sheet template into a multisheet Zoho sheet file
Is there a way to insert a Zoho Sheet template (one sheet) into a multisheet Zoho sheet file? When I try to copy and paste the template I have created into a Zoho blank sheet in a multisheet file, again it is inconsistent, the formatting of the template does not always come through. In an Excel file I can insert a template I have created, or move or copy a single sheet from one Excel file to another. Can this be done in Zoho sheets? Please let me know. Thanks.
Array Formulas in Zoho Sheet
Zoho Sheet now supports Array Formulas. An array formula is a formula that can perform multiple calculations on one or more items in an array. Array formulas can return either multiple results or a single result. They provide you with more power to your calculations in your spreadsheets. For example, the following spreadsheet uses Array Formulas. The formulas used are explained below the embedded spreadsheet. Here are the array formulas used: Multi-cell array formulas are used in the Current Price,
No formulas in exported sheet
I 've exported a sheet to xls, xlsx and odt and the formulas are not there - what am I doing wrong?
seguridad de las hojas
alguien me puede ayudar, con respecto a como podria proteger las hojas individualmente asi como se hace en el excel
How many days' history a sheet can maintain version?
Dear zSheet Team, How many days' history a sheet can maintain version? Is this value configurable? I see versions upto a few days only when my sheet is month's old. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
CALCULO DE HONORARIOS
HOLA ME PODRIAS ENVIAR UNO QUE SEA CON EL 11 % DE IVA POR FAVOR Y PODER GUARDARLO EN MI PC GRACIAS
User form error
Hi there In my spreadsheet I keep getting an error in relation to one of my command buttons attached to a user form. The error is: Unknown function or field: Show. However the command button and user form works perfectly on my Excel spreadsheet. Any ideas?
Copying and pasting a range from a Zoho sheet into a Zoho writer document
We have moved to Zoho Writer (instead of Word) and Zoho Sheet (instead of Excel). However, I cannot seem to copy (via highlight) and paste a specific range of a Zoho sheet into a writer template. It loses all the formatting. The only way I am able get something approximate using Zoho for the entire process – and this is not stable, it changes all the time – is to publish/embed using html from a Zoho sheet to an external site, and then in Zoho writer, insert it as html, Copying and then publishing/embedding
Set focus on today's date
In my sheet in column A I have a list of dates. I would like to focus on today's date on opening/viewing the sheet. I've managed to get this working in Excel using the find function/macro but I get an error in Zoho sheet if I try to use the same code. Here's the code that is working in Excel just for reference: Sub Workbook_Open() Dim FindString As Date Dim Rng As Range FindString = CLng(Date) With Sheets("Sheet1").Range("A:A") Set Rng = .Find(What:=FindString, _ After:=.Cells(.Cells.Count), _ LookIn:=xlFormulas,
Share difficulties
Zoho was great for a multi-sheet spreadsheet. I was excited at what it allowed me to do compared to google spreadsheet. However, perhaps I was expecting too much. I set permissions on five out of nine sheets and then it no longer allowed me to edit permissions. Is there a limite on the number of sheets you can do this for?
Sharing ZOHO Sheets
I am making a spreadsheet that I want my group to access and enter their information in weekly. Some of them aren't very good at computer work. Is there an one click link that will take them directly to the spreadsheet instead of having to go through the sign in and then find the spreadsheet? I would also like to protect certain cells so that they can't be changed. I can't find a way to do this. Is it possible or not? Thanks
How to Sync Zoho Spreadsheets with My PC?
I like to have my files ( mainly spreadsheets ) sync or backup automatically with my PC. How to do? How to keep an offline copy of my files?
Next Page