Importing an Excel file into Sheet2
I want to have three simple Excel spreadsheets in three sheets in the same document. But when I select Sheet2 and import the file, it overwrites sheet1. How do I do it?
Zoho Sheet - trendlines for line charts
I retried Zoho after seeing the "Fake Office" posts. Super impressive. One feature I miss from desktop Excel that I wish were in your spreadsheet app: The ability to add a trendline to a line chart.
Import from Skydrive is required
Dear zSheet Team, Similar to the 'Import from Google Spreadsheet' feature that you have in your menu, it would be great if you could also have a 'Import from Skydrive' feature. Skydrive is just gaining momentum and has glaring bugs including missed out usability testing too.
How to access a specific Sheet module by URL ?
Is there a way for end users to specify a specific Sheet module by URL? Admins would like to keep all related sheets on one file for easy maintenance. Users in different areas want to focus on their specific sheet (only 'ONE' of the sheets) most related to their functions and also need to reference all other sheets when needed.
Use Filters in your Zoho Spreadsheet
We are glad to inform that 'Filters', one of the most requested features, is now available in Zoho Sheet. Filters help you to filter your data and let you focus on and analyze specific segments of data. You can filter by text, number or date. For columns containing numbers, you can additionally filter by Top/Bottom 'N' Items/Percentage. Functions like SUBTOTAL() have options to exclude hidden/filtered rows. It can be used to calculate results based on the Filter you apply. The filters menu also
Unable to click into cells
Hi, I am having no success when trying to click into cells. I able to navigate into cells using my keyboard but I can't click into cells to edit or input. Any ideas why? Using IE and not downloading the sheet as its a shared document.
Publish range of cells - interactive
I have a workbook with multiple sheets. Most of the sheets contain formulas and background information. The final sheet has a calculator that takes input for some variables and then displays the results of the calculations. If I embed the entire workbook to a page on my external site I can navigate to the final tab and input data that runs the calculations. I want the interactivity, but I want to hide all of the other sheets. If I embed a range of cells on my external site I see only those cells,
Is the new interface a step back?
Hi It may be a coincidence, but since switching over to the new interface, I have many problems: - The links from B-001 INDEX to the individual sheets don't work. When clicking on a bird, I get the comment that the server has problems - Many cells which should be merged, have been split - When I want to open a document, it doesn't list all documents in alphabetical order like the sidebar used to do - The filter doesn't work I don't know where to go from here, the whole bird register is unusable and
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.
Next Page