Export problem
In export to MS-Excel Workbook or 97-2003 workbook sums are appearing wrong.
Graph Problem - Source Data
Ok. So I'm trying to graph data from another sheet and it keeps saying "specify a valid sheet name" I have a sheet called "Info" and here is what i'm trying to put as the data source I want it to graph from B11 to C75 ='Info'!$B$11:$C$75
Copy Macro Help
I did a record macro to copy data from one spreadsheet into another spreadsheet and it works in a way. But not the way I want it to. Let me see if I can show it. <iframe width="500" height="400" frameborder="0" scrolling="no" src="http://sheet.zoho.com/publish/polardude1983/copyhelp"> </iframe> Sub copymenow() ' ' copymenow Macro ' Created by polardude1983 on Sat, Nov 2009 05:18:28 PM ' Range("C5").Select Selection.copy Range("D7").Select ActiveSheet.Paste End Sub When it copies it doesn't copy
Formula Help
I am trying to see if i can convert my wonderful and extremely complicated spread sheet from excel 2003 to zoho. Anyways here is the formula that I have that works in excel 2003, but not in zoho =IF(AND(H16="Male",H16="male"),"8",IF(AND(H16="M",H16="m"),"8",IF(AND(H16="Nursing",H16="nursing"),"12",IF(AND(H16="N",H16="n"),"12",IF(AND(H16="Female",H16="female"),"2",IF(AND(H16="F",I3="f"),"2",IF(AND(H16="Woman",H16="woman"),"2","enter male or female")))))))
EMBEDDING GOOGLE CALENDAR INTO ZOHO
CAN IT BE DONE?
当我有7个工作表时，我无法再导入表格了。是有数量限制吗？
如题，谢谢！
New to sheets, have some questions....
Basically, my search skills are terrible, and I am having no luck searching for some kind of template.... I want to keep track of expenses, medicines taken, money made, etc, basically, all the things of day to day life. I am hoping to find a template of some sort to help. I would like to have it figure up weekly, monthly, and yearly totals and averages as well. Any hints, tips, pointers, or such? Or am I going to have to make a sheet for each other, from scratch, for 365 days of the year? Thanks
Folder to arrange
Hi team, This is site is an ultimate site to store the sheets & docs online. But the only thing the site is lacking behind is we can not create folders to organize our folders. It should have an option to create folder to keep our docs or sheets in an organized manner. Thanks, Sreeram Murty.
User manual
Hi, Do you have a user manual for Zoho Sheets? I can't seem to find basic edit operations like -Fill -find & replace Thanks, Christopher
Date conversion to US format
Hi, when I enter a date into a spreadsheet, such as 14/9/09, it is automatically changed to 9/14/09. Whilst this may be great if you live in the US, the rest of the world uses dd/mm/yy. How do I stop ZOHO writer from automatically 'correcting' my dates? Julian
Why the data is not synchronized in sheet.zoho.com when two or more guys editing the same shared sheet?
- Failed in two accounts editing the same sheet in two computers - Failded in one account editing the same sheet in two computers. Both are ok in google spreadsheet, it shows in different color when the user is click the cell. Zoho is so bad on sheet. I lose too many datas when editing a file with team members. If this problem or bug is not resolved, I think Baihui in China won't delveops well, and zoho will never be a greater in this industy.
复制和黏贴的问题，还有中文输入的问题
测试一下ZOHO的在线EXCEL文档，从电脑里面的EXCEL文档里面拷贝的数据无法黏贴 新建EXCEL文档后，切换中文输入法（搜狗拼音）之后，每次输入的时候，会自动将第一个字母作为英文输入，举例说明，比如我输入“zhangwei”的拼音后，在表格中会出现“z”的英文字母和“hangwei”的拼音格式 不能自动保存？
Willl spreadsheet cell overflow ever be implemented?
The lack of a cell overflow function ala Excel (where text that is longer than the current cell will show up in the next cell if that cell is empty) is a deal-breaker for me. I've seen comments from Zoho staff in the forums all the way back to early in 2007 saying this was "on the to do list". Does anyone have a timetable as to when this might be implemented? Thanks.
Sort Ascending / Descending Clarification
When sorting columns in sheets I find it a little confusing. Basically I just want to do a straight sort either a-z or z-a. The problems I have are.. 1a. The pop up describing the options when one chooses to sort is confusing to the average user like myself. It says `Do you want to expand the selection? Click OK if you want to expand the selection. Click Cancel if you want to continue with the current selection' Usually in a pop up like this clicking cancel means you no longer want to perform the
zoho sheet cell formatting shuts down my browser
Hi, I dont know if anyone else has this problem. But when I try to format cells in zohosheet (i.e. making grid marks in a spreadsheet), the whole application freezes and I have to shut my browser down and restart to work on my spreadsheet again...Are they going to fix this bug?
Uploading workbooks using C# .NET
Hello, You guys are the best!!! We are trying to upload files using the uploadbook api using C# .net but are confused on how to pass the content parameter. Below is how we are trying to post the content parameter but its not working. Would really appreciate it if you could help us out. WebRequest request2 = WebRequest.Create("http://sheet.zoho.com/api/private/xml/uploadbook?apikey=2d9c5895578aa11de5e04233325638f&content=F:\\ABC\\efg.xls&contentType=xls&workbookName=efg.xls&ticket=" + TicketID);
Sheet and link external data
I have a Creator application receiving data from a web site. This Creator app is linked to my Sheet via the Link External Data function. I can successfully import the data manually using the Refresh action, however - the schedule periodically import of 30 minutes does not update the Sheet. The set up is similar to this example http://blogs.zoho.com/creator/mashup-with-external-data-in-zoho-sheet Does the schedule import work?
Test please ignore
Test please ignore
Linking cells from different ZOHO sheets
Does anyone know how to do this - or indeed link cells from separate tabs
Update multiple tabbed sheets
Is it possible, in Zoho Sheets, to update multiple sheets at one time? For example if I have identical data for 12 of 36 sheets, can I select the 12 sheets and then enter the data into the relevant cells all at once? Thanks!
Zoho spreadsheet
Hi, I am a current user of google spreadsheet. As i am suspecting that there is leak of info, ( spreadsheets are shared), i wonder if zoho track the ip address of each user who view the document? Is it single login per user or mulitple Rgds,
Zoho Report and Zoho Sheet
I have generated a Zoho Report from Zoho Creator information - a Zoho Summary report. This has also been embedded back into Creator. I would now like to use the summarized figures from the Zoho Reports table in Zoho Sheet, ultimately to schedule an import of summarized figures for Sheet to work on. What is the best way of doing this ? I have tried 'Publish'ing it but I get a password protect error, even if I try the non-login option. Any ideas ?
how to build a new function using VBA?
Hi all, I have a specific problem. I want to use this user-written Excel function on my Zoho Sheet. Straight copying does not work. But do you have any idea how I still could make it work? Thanks very much! Laszlo
Hiding rows and columns in sheet
What happened to the ability to hide rows and columns. This feature is critical to our continued use of your product. You have just removed a CRITICAL feature.
Zoho Sheet questions
Hi Everybody, I'm a first time Zoho sheet user and an Excel power user (basically everything except VBA coding). I'm pretty excited about the sharing possibilities that Zoho sheet offers, and am working on trying to convert a simple Excel model I have to Zoho. Things I have questions about: 1) I have a couple of drop-down menus in the Excel document that the user selection an option from. The options are pre-defined using a list hidden elsewhere in the sheet. Does Zoho offer drop-down functionality
how to input a part of an external data into Zoho Sheet?
hi, i am new on Zoho Sheets, i just wanted to know how to input a part of an external data into Zoho Sheet? for example: http://www.youtube.com/watch?v=lGKemE_vEQs i only want to get views "62,963 views" on my Sheet and also Auto-updated, is there any formula? does it wor on Zoho Sheets? Thank You
Importing xls files to Zoho sheets
Hi, I created an INVOICE report in ZOHO CRM, one of the columns is the Invoice date in dd/mm/yyyy format. I exported this report in .xls format, saved it and then imported it to ZOHO SHEETS. The problem is with the date field. It shows as: '01/07/2008 The apostrophe makes the date unusable, and it can't be removed with the replace command, because it is only visible in the Formula bar, not the actual column data. Can you help? Christopher
Understanding the Display
When the form is displayed on my web page, it shows my signon name and then says 9 views. First, is there anyway to NOT show my signon name? Second, what does 9 views mean?
Server Error
Error 500:Internal Server error
Kindly reopen the file
I am so sick of getting told to reopen the file because of an error. What's causing this?
Error
We keep getting an "error occurred" in one of sheets and we can't open them unless I copy it and then use the new file. Any ideas? Thank you.
Pre-sale questions: Google Docs features, support, sharing/editing
Hi, After evaluating Zoho Sheets and comparing it to the spreadsheets of Google Docs, I have a good view on the features and capacity of both services. Zoho definitely offers great tools, however I still have a few questions. 1. It seems that Google Docs spreadsheets are quicker to load. On the same Mac, Google Docs spreadsheets load around 50% faster than Zoho Sheets. Will there be a speed bump anytime soon, or is there a way to load sheets faster? I will be opening loads of sheets each day, so
Sheetでエラー発生
ファイルを開けません。 「シートを開く際の問題発生」といったメッセージが表示された。 Docsと同じようなエラーです。
Protecting cells
Need to protect cells while in public area if not anybody will tamper with the structure or information provided in a spreadsheet. You either have collaborative work spreadsheets or you have public type that require protection for certain parts. When can we expect that option?
Protect sheet or link sheet to other sheet
Hello all I'm a new Zoho user. I have an issue. I have developed a projectmanagement method in excel. This works really good and clients want to use it aswell. I want to give them access over the internet so that more people are able to use it en get informed. That means I have to protect my links and calculations over the 15 tabs to prevend damage and unauthorised use. Does anyone have ideas how to do this? Is Protecting cells/tabs an option? An alternative is to leave my method in one sheet and
Can I assign a note to a cell?
I need to add different notes to many individual cells (as can be done in Excel). Is this functionality available, or incoming? ;) Thanks
Zoho Sheet API doesn't allow to make a sheet public
Hi, I've been trying to integrate zoho sheets to my page, I'm able to upload a sheet but now I need to publish the sheet and I don't see any function on the REST API to publish or share a sheet
Formatting numbers
Hi, by default numbers are formatted like "1,234.56". How can I change the format into "1.234,56", like it is used in many non-english speaking countries. Kind regards, Frank
Is there anyway to ROLLBACK or RECOVER an earlier version of a sheet?
We used the Zoho Notebook with a sheet page, we had data and someone did a sort which moved some data out of place then their IE crashed. Thus they could not UNDO to fix their mistaken sort. Is there any way to REVERT to an earlier version of a sheet? I have manually fixed my sheet but would like to know my options if this happens again. What are backup options (I hear there are some if you're not on FREE, what's the $ for NOTEBOOK + SHEET?). Thank you.
Diferent axes on charts
I can't do a chart whit different axes. I need put different values on different axes.
Next Page