charts
I like this. as a regular past user of exhell, I have noticed a really neat feature: For a two series chart [two sets of data] allow for one to be a bar/column and the other to be a line chart. Let's play this scenario out: I have a column of number of widgets and the market share gained that week. For 3 weeks I have 3 rows of data in two columns which I will comma delimit for ya: sales,share 425,5 210,24 635,35 Now if I wanted to juxtapose the two on top of each other in excel, I would pick the
autofilter
what posibility of use autofilter ?? bargatan
linking sheets to database
Is there any way to link multiple zoho spreadsheets to a zoho database? bishwa.oakes
Automatic Updating Broken?
Is the automatic webdata updating not working any longer? It hasn't been for me. It works when I manually click refresh but will not update every 15 minutes like it is set to. I'm pretty sure I'm not doing something wrong because it has been working fine on this particular sheet for many months now.
Can't paste into Zoho Sheet
I have built some pivot tables within Zoho which work fantastically. I need to regularly update part of the data file from an external source which I plan to do by copy pasting from Excel. Currently I am unable to paste into Zoho sheet. guymckenzie
Error 500, every 5 minutes!
There is a constant error that makes it impossible to work with Sheets (I've faced it in Write too) It is this "Error 500: Internal Server Error" that asks to reopen the sheet, but it does it 100 times a day, almost every 5 minutes!!! Please help because a job that should take 10 minutes, wastes an hour! Thanks, Ali
Publishing sheets/range
Hi, What is the logic behind publishing ranges? I have published a range to a website but it doesnt update until i log back into zoho. This range is based on 15 minute interval from another site, so i need this information updated. How do I ensure that it updates without logging into zoho every 15 minutes!?! logansan
Spreadsheet Sorting
I am trying to sort a spreadsheet and I do not see where it allows me to pick which column to sort by. Please advise. radiantimt
zoho sheet pivot tables
When I try to change the way a date field is being brought in, I click where it says "Year", but the drop down menu appears behind the active window. I therefore cannot change it from YEAR to "Full Date" b/c I can't move the window out of the way without the drop down list disappearing. remcentre
Eliminate Cellulite
Fish Oil supplements Report
Email sending macro
Hi all, Been searching like crazy (both here and google..) for a ZOHO compatible email sending macro. Basically, I want ZOHO to send me an email when a cell hits a certain number (ie: stock watch trigger) The cell is a linked external data reference. Thanks in advance for any suggestions or links to someone having done this... Regards, LO
XY scatter plot with dates in the X axis
Hello, I have two columns. The first columns are dates. The second column are values. The dates are not evenly spaced, eg. between two points there might pass one week, whereas between two other points there might pass two months. When I use a XY scatter plot in OpenOffice, the points are aligned according to the date, ie. not necessarily equally spaced. However, in Zoho Sheet, the points are aligned with equal separations even if the time differences are not equal. Is it possible that Zoho Sheet
sheet
terribly slow - good bye garehira
Integration with Zoho DB & Reports
I'd like to be able to import data into my sheet from a DB report I've created.
Sheet not opening with other applications on IE explorer
Hi, We have linked the Zoho sheet with one of our web applications. When we tried to access the information on the webpage (Windows Internet Explorer), the Zoho sheets does not appear on the screen. But its working fine on FireFox. Its happening since today. Pls address this issue. Thanks - naveen
Zoho sheets tough time
Generally, I used to enter the datas in Microsoft excel sheets then i will paste it in Zoho sheets. Suddenly, I encountered the error which says, "Stop script or continue" if i select any one of the option my data gets disappeared. It keeps frustrating me, would you please advice on this? sankarr
NA() function doesn't work
Hi again, I've tried the NA() function and returns "#Invalid Formula". I need this function because i use the "#N/A" type in a chart when cell is empty. Example: fx=IF(ISBLANK($F1.H8);NA();$F1.H8) Thanks in advance!
Create User Functions (User Formulas)
Hi! My question is: �Is now possible to implement our own functions? I need my own customize formula to count how many yellow cells are in a especified range. I opened the VBA Editor, and i wrote and saved this code below in section Macro_Modules->Macros. Public Function countYellowCells(ByVal Range_Data As Range) Dim c As Range Dim Suma As Integer countYellowCells = 0 For Each c In Range_Data If c.Interior.ColorIndex = 6 Then countYellowCells = countYellowCells + 1 End If Next c End Function I tried
Problem with printing embedded sheet
I have this worksheet embedded in an html page. You can view it at http://www.gconnect.in/pages/pay_calc_pb12.html The problem I face is that, if we try to print the web page, the first page is blank except for the website logo and ad. In the second page I get a portion of the sheet. The third page is again blank. The sheet does not get printed as displayed on the page. Is it a bug or is there any other way of doing it so that the complete sheet gets printed.
latest fixation
In the decisions yesterday it is given as Scientist E & F is put in PB4. I am in that grade My basic on 1.1.06 was 19100 . But your calculator is fixing me in PB3
Blackberry Mobile
Hello, I tried to launch Zoho mobile on my blackberry web browser and it takes me to the site but I cannot click on the login link. Also, is there a way to work around having Zoho sheet go offline when the spreadsheet is left idle for some time. When I come back to it it gives an error message. Thank you. George gpolzer@Zoho.com or gpolzer@mindspring.com gpolzer
unsaved changes in zoho sheet
Hi, When editing a a document using zoho writer remote API, and tries to close the writer with unsaved changes, the writer alerts the user reminding him of saving, but sheet does not behave so, and do close and leave the user suffers from data loss. I think this is a new feature in writer, should we expect zoho sheet to support that soon? Thanks, Mohammad
sheet unusable from asus eeepc
impossible (or at least not obvious) how to navigate through a list of sheets in "my sheets" make using the app impossible from an Asus EeePC. These devices and others like it are popular for mobile workers who use online only applications for mobile office etc. niallroche
importo problem
Good evening, I'm trying to import one sheet with vba code included, but when importation's complete, can't manage to make it work. I'll attach the file i want to import
Disable Editing on Embeded Sheets
I saw http://blogs.zoho.com/sheet/how-to-embed-your-spreadsheet-into-any-webpageblog/ and it works great! But is there a way to disable visitors from editing the cell's content? I really like the tabs and "Save to Excel" link. joemako
Help!! Password protected
Hi I've got a copy of the spreadsheet I want to open in zoho\zohosheet\users\username\spreadsheet.xls But I'm being asked for a password to open it - I never set a password. The local version is more up to date because I made a lot of changes without internet access. How do I open it? Whats the password? Do I need to do a sych or something? Thanks Russ
Setting row color with a VBA macro ...
Hi, I'm trying to set the row color of the active cell with a VBA macro. My code works, but the new row color is not visible unless I reload my spreadsheet. (Took me a bit to realize that.) Here's the single line of code I'm using. activecell.entirerow.interior.color = rgb(255,0,0) I'm no VBA expert so maybe there's something obvious I'm doing wrong. Do I have to force a redraw or reload somehow? thanks.
Grouping of columns\rows
Does Zoho support grouping of rows\column (feature similar to MS excel -> Data -> Group and Outline) ? Does Zoho support filtering of data (feature similar to MS excel -> Data -> Filter -> Auto Filter) ? Thanks Vaibhav
Selecting non adjacent columns for pie chart
Hi, I am having 3 columns of data, say A B C -------------------- sun x 25 mon x 27 tue x 24 I am trying to create a pie chart for columns A and C. In Excel, I know you can just click Ctrl and select other non-adjacent columns. Can you please tell me the way to do that in Zoho Sheet? Thanks, Mano
Sharing Spreadsheets
I have been trying to share a spreadsheet with a group I am a member of. However, each time I invite them and click share it looks like it will be going through. Then the message about who the document is shared with appears and tells me that no users or groups have been invited. How can I get past this? I have tried several times, but have been unsuccessful in getting it to work. I have gotten it to work in the past, but for some reason it doesn't work right now. Please advise. jweihrauch
Spreadsheets don't show up in Zoho Start
Hi, In Zoho Start, any spreadsheets I have created or uploaded don't show up. They are there when I go into Zoho Sheet, but not on the Start page. In the Box view, there is just a message that says "loading data" that never goes away. The boxes for Documents and Presentations seem to work fine. Is this happening to everyone or just me? I'd like this to be fixed, because Zoho Start is the one place where I would be able to see all my files at once. Thanks.
"FIND" function
In zoho/sheet, I could find a find/search. function. In Firefox, I was able to use the browser find, so no problem there. However, in IE7, trying to use the browser FIND return an error indicating that the object (zoho/sheet, I assume) does not support this feature. Thanks for any help.
Translation not consistent across applications
I am using Zoho applications in Brazilian Portuguese, and it's interesting to see that the translation is not consistent across applications; "feedback", for instance, is "Retorno" in Zoho Sheet, "Comentario" in Zoho Notebook, "Feedback" in Zoho Planner and Writer is not translated yet... mdalves
ERROR 500
When I try to save sheet, there is some error #500. What is it, and how can i fix this problem. kze_admin
Publishing sheets/range
Hi, What is the logic behind publishing ranges? I have published a range to a website but it doesnt update until i log back into zoho. This range is based on 15 minute interval from another site, so i need this information updated. How do I ensure that it updates without logging into zoho every 15 minutes!?! logansan
Linking Encrypted tables into zoho sheet
Dear support I have tables in creator that I wish to link into sheet. I can do this for non encrypted tables. But every time I try this with an encrypted table I fail to make the link. Does this mean I would have to turn off encryption to use this link up ? Regards Peter
polar graph
software does not accept value-range incoplan
Assign Macro to ......
In MS Excel, one can assign a macro to an image or a button. Is there something similar in Zoho sheet? If not, what's the best way to run a macro?
Help pages anywhere?
I was trying to find out how to freeze spreadsheet rows when I realised that there are no Help pages! Is this true? If not, why not and if there are, where are they? I found out about the lack of a freeze facility -you don't have one. And so common... My 1986 (yes!) Commodore 64 had one. When will it come?
Sheets
Would like to be able to link sheets in the same workbook. in other words make cell A1 in sheet1 equal to cell D6 in sheet 2. What can I not do this and is this coming? robblaine
Next Page