Problems with sever connection
Now able to get into zoho but still getting the message that the connection to the server lost and to open the file again, do so same message. This happens every time I try to load the sheet. Have logged on using the same computer and a different persons login, this works fine (opens in a new window) Have tried as myself on different computers, connection lost retry message. (reloads on the same page) As the author of the sheet I would like to be able to get access as myself and not have to use
Account name and email address in header of public sheet
My account name and email address on my profile shows in the top header row of a shared public sheet. Is there any way to restrict showing this? The account name shows as a hyperlink but the URL is incorrect. I can't find the place to change the destination URL.
too many rows
I have a sheet 2013_Dream-malaysia with just a few rows but when I try and add a row I get message 'run out of rows' I have tried to export to XLS to see if there is something odd about it, but I can't export - it just hangs I have shared it with sheet
Not Supported in public view
Hi, ive uploaded my excel sheet and im getting the following error - Not Supported in public view www.make-my-will.co.uk is where the sheet is held any help would be appreciated Johnathon
add members is impossible
Hellowhen I try to add a member (email and message), zoho sheet send this message : What's the problem ???? Thanks
Direct email from Excel sheet to 1 person
Hi, is there anyway of having a button that allows users to click and it send the excel sheet directly to me without opening a 3rd party mail client? Thanks in advance for any help or advice
http://contacts.zoho.com/ tries to load and stalls behind firewall
I have an Internet Explorer 8.0.6001.18702 browser behind a corporate firewall that I'm using at lunchtime to access my Zoho spreadsheet that helps me manage my banking. Alas, the status bar at the bottom that tells me when pages load gets stuck with a small blue progress bar that only is as complete as a simple vertical line. It last tells me it is trying to load from http://contacts.zoho.com/ I do not use the Contacts feature of Zoho at all, and do not need to. As a result of this aborted
Restricting the number of rows and columns
Hi, Is there any facility to restrict the number of rows and columns? This is required as I am giving some data validation cells which I would like to restrict to 500 rows. Means the user can enter data only upto 500 rows. If he wants more, he has to subscribe. Regards, Rangaswamy
Failure in collaboration mode message
Keep getting 'Failure in collaboration mode message' and the app is now very slow to scroll or tab to another sheet in same shared worksheet. Also unable to print as the message is disabling the print functionality.
Separating strings delimited by commas
I am creating a spreadsheet to manage behavior data for our school. I initially created the spreadsheet on Google Docs. It was working but I could not expand it to full functionality due to the cell and cell with function limits. I imported the spreadsheet into Zoho and I am having one problem. In the Google Docs, I was using the split function to separate strings into multiple columns. For example H,Jumping on desk,Staff 12,Student 16,Log entry 845 After using the split function I'd have H Jumping
call macro function from cell
Hi, How I can call macro function from cell like Microsoft excel? Its possible write function which return arguments?
Sharing failed due to an unexpected server error
Hello, I've been working this week on an important document that I have to share with a group of people. However, every time I try to share the document, I get the following message: "Sharing failed due to an unexpected server error. Please try again". This is all the more troubling that I had no problem before, when I shared documents ("sheet") with the same group of people. It's been two days I have been trying, to no avail. Please indicate what I should do to get it shared, the matter becomes
VLOOKUP issue - urgent
Sorry, but I have an issue with vlookup in french mode, it just doesn't work and it is urgent to use it. My end customer threatens to go to google spreadsheet if I don't fix it please come back to me regards Daniel
Protect Cells
Is there a way to protect only certain cells in a sheet and let the others be openly editable to any viewer?
how to shuffle all cells values from a column ?
hi, i want to shuffle the cells from a column , let's say i have from A1 to A5 this numbers : 1,2,3,4,5 and i want in the next column a list with this numbers shuffled into a set of five , for ex : 1,2,4,3,5 first set , 1,5,2,3,4 second set , 1,3,2,5,4 and so on until every combination is done . it should be 120 sets ( i use permut(5,5) formula ). Anyone knows what can i do to resolve this ?
Corrupt zoho sheet file
I have a corrupted zoho sheet, is it possible to recover the data? sheet id 287757000000008005 file "loads" empty and indicates an error via the web browser.
multilevel sharing sheet feature in V3 no longer available causes big issue
in the new version, we cannot set up the sharing based on each private sheet. nota : it would have been nice to announce it before doing it, to work out how to update the case We had many "private" sheet using datalink from other sheet from the same document. We had to take them out as they are private and put them in a new sheet document But now, still, we need the datas from the shared sheet as input in the private sheet document. how can I link them together ? how do you save the bad situation
SPREADSHEET ANIMATION
why is the iteration in the spreadsheet set to a max: 20,000 (about 2 secs)? I think this should be limited to 100,000 iteration to test animation online! Thanks a Heap!
Linking a cell to open a worksheet in another file
Dear Zoho Sheet Team I am sharing files B-00 to B-15 with you. B-00 is an index and each cell should be linked to open/close one of the other sheets. Is this possible? Do I have to insert buttons in the index sheet? Is a link only possible if all sheets are in one file? If this is so, how do I do the transfer? Can anybody advise me please? Many thanks! Hans
Feature Request : Consistent Login Form
The login form that Zoho (Writer/Sheet) uses seems like any other form on a web page, but doesn't quite behave like one. On Firefox 2.0 and Win XP Pro, login/password details are not remembered by Firefox. I rely on Firefox to manage logins and it's irksome that Zoho doesn't behave natively.
工作表共享问题
新改版的zoho sheet里，有个功能是否取消了？以前的共享功能里，可以对不同的用户制定不同的工作表的权限，他能看工作表1的内容或者操作，但是不能看工作表2的内容，或者能看到工作表2的内容但是不能操作。新的sheet里我没有找到哪里可以进行工作表的单独权限设置。 盼望回复，谢谢
What's about localisation?
Hi, I really like the new interface and many of the new features. But what's about localisation? How do I format cells like € 3.212,37 instead of 3,212.37? Kind reagrds Vrumfondel
sheet questions
have some questions 1) would unclick the publish to zoho database and export sheet would disallow users to download the file search the file or access the file using any other methods? html xml access or direct download the file from zoho sheet or view the formula from view brower source code? 2) have select link external data and update every daily for the data update but when reopen the sheet the data is not update and have to manually click refresh to update. Is not the feature auto update the
Upload a specific sheet in a workbook
How do I, using Zoho Sheet Upload API upload a specific sheet (say sheet number 3) to a workbook which has more than 1 (say 5) sheets? I couldn't find a reference in https://apihelp.wiki.zoho.com/Upload-APIs.html .
work with broker
zoho sheet has api does the api allow hooking to broker api to send order from the sheet autoly?
google finance
how to import google or yahoo finance data 30.25 -0.29 (-0.93%) After Hours: 30.25 -0.00 (-0.02%) Aug 23, 6:46PM EDT NASDAQ real-time data - Disclaimer Currency in USD the link external data does not have the above
data provider
the sheet has a stk function to retrieve the data. which data provider is zoho using?
Zoho Sheet 3.0 Release
There seem to be numerous problems with this new release. Why wasn't any of this tested before it was released? The last version was stable for quite some time. There seem to be alot of problems using it with Internet Explorer 8. Many of us are using this product in a corporate environment and we are stuck with this browser so the solution can't be to switch to Firefox or Chrome. Shouldn't this have been beta tested before replacing the only version?
embedded sheet cuts off last row
Okay, so I'm new to Zoho Sheets. My sheet is based on a database I created with Zoho creator. So I select the rows I want to display on my website, then I click on Share > Publish this range. Then I copy and paste the iform code into my website. It seems if I make the font very big (even 12pt in Calibri), the last row gets cut in half (for example, the last row is Wheels, but I can only see the top half of the word). Since I am somewhat new to website design, it appears I can't modify the parameters
publish sheet privately
how to plublish sheet privately allowing a few users? Other online spreadheet provider has this feature and google sheet has them
Solver or Goal Seek using VBA
You recently added Solver and have noted you are working on adding running Goal Seek in VBA in a previous discussion. Do you have any update? Thanks
Support for .xlsx
As time goes by, more people are using Office 2007 file types. It is inconvient to constantly have to convert files before importing. This restriects my use of the Zoho desktop & ties me to my laptop. Please support xlsx and all of the Office 2007 files types.
chart data
Have data a1:a100 with a1 is the current data but inserting the chart the a1 value is on the left of chart how to have the current data on the right of chart? sorting is one way but does not apply any other method? and why there is no value on the y axis?
Can't share documents
I'm trying to share several different spreadsheets. First off, I wish I could share individual sheets (not the entire doc) with different people. That used to be an option, but seemingly disappeared with the new features. Secondly, I can't share with anyone that isn't already a user. It used to be that I could share with an email address and then you would send them an invite to sign up. Now if I enter an email address that isn't already a Zoho user, it just says that it is invalid and won't let
spreadsheet files don't load in new version
I need to download the file before and then I see it. Loading page, at first attempt, freeze... I use Chrome 21.0.1180.79 m
export spreadsheet in new version - urgent
Hi, in the new version,1/ unless I am blind, I don't see how to export a spreadsheet 2/ how do I undo the publication in my group/company when I by mistake did click on the button "public in ..." thanks Daniel
cell protection and/or formula hide
can you please help me - how to protect a cell and/or hide a formula.
search and publish
does publish a spreadsheet make the file allow for others to search on search engine?
Error when trying to share spreadsheet
When trying to share a spreadsheet with a user outside my own email domain, it tells me the email address is invalid. This even happens when I try to send to my own private Gmail address, so I know for a fact the email address is fine. When sharing the same sheet with another user within the same email domain, it works just fine. Please help?
Invute to Zoho Sheet
Trying to invite a friend, I enter an email address and I get a message "users or groups listed below are found invalid." This is a valid email. What am I doing wrong? Thanks
Next Page