publish and save
when publishing a spreadsheet would viewer allow to download the sheet and reveal the formula? and is there a hide formula from collaborator viewer feature?
Lien entre les classeurs
Bonjour, Je suis nouvelle sur Zoho Sheet, et je voudrais savoir s'il était possible de lier différents classeurs entre eux. Exemple: Classeur Test A1=5 A2= 10 Classeur Test1 A1= Classeur Test A1 * Classeur Test A2 donc 50 Merci pour votre réponse
auto filter
When will auto filter be implemented?
@TXTNLRN,@Zohosheet,question,Zohosheet does not have the Sort-filter capability
Hello, In creating a sheet using Zoho, I was unable to locate the Sort filter capability like the one in Microsoft Excel. Is it on your roadmap to provide the feature/option? Thank you Staff TXTNLRN http://www.TXTNLRN.com text 5128504898
Filter Option
To whom it may concern, In Zoho online spreadsheet, there is no filter option. Kindly assist me on this issue. Regards Vino
Spreadsheet Filter
Hello Great tool but I was alarmed to see there is no filter feature. It's there but hard to find surely ?? Please let me know. Thanks Tenison
I really wish it had the filter functionality
I really wish it had the filter functionality
Is Zho down?
I couldn't access my datasheets yesterday, so I thought it was a temporary problem... but today is the same stoyr: "Open" is not working... Is zoho in maintenance or something? I use datasheets for tracking investments, health, exercise, expenses, and now I'm stuck...
WindowsXP IE8 unable to access saved sheets.
I have found your service very useful. However, I have been unable to access my work since zoho released version 3.0 from my WindowsXP IE8 machine. I can from my Vista or Windows7 machines, although much more slowly than before. In WindowsXP IE8, the sheet opens briefly, but immediately displays a yellow warning: Connection to server lost, please click here to reconnect, or something to that effect. But no matter how many times I try, the response is always the same. The spreadsheet has 4 tabs.
Make the "Click to Edit" button automatically 'on'?
Is there a way to make the sheet (in my case I have a calculator for the user to alter values) editable automatically instead of having the user click the button? Thanks -Scott
zoho sheet error "Page isn't redirecting correctly"
Hey guys, new to this forum and posting the first time, i've been testing zoho on my new web app for editing word / excel files and this is what happens. when using the zoho sheet api i get an error "page isnt redirecting correctly".. on firefox (chrome gives a blank page). {for viewing and editing both} what could be the possibilities. Note: 1) code checked for errors .. same code works perfect on other machines. 2) server firewall disabled (checked the link https://sheet.zoho.com/remotedoc.im)
problem for shared
Hello,, In the old version, it was possible to share a portion of a sheet, which was good to give access to multiple people, everyone's tab, in the new version, it is the whole leaf which is sharing, do you correct it??
Embed Sheet on Webpage for public access to enter data with options to Submit to Email Address and/or Print
Purpose of spreadsheet is for online customer to enter 7 values that will generate a table of parts required. Then they have the option to Email the spreadsheet to the Supplier and/or Print the spreadsheet for their records. In my Zoho account the spreadsheet works when I test the email button, an email is sent and received. When I test at https://public.sheet.zoho.com/public/tonim7/slidingdoor-bom-generator-3 The Email button does not work . Error message "Not Supported in public view" Also the
Embedding Editing Permissions
Hello, Im suing Zoho Docs and loving them I have created a calculation in Zoho Sheets, and I have embedded on my webpage for my users to use. However, when I "publish range" so it doesn't look like a spreadsheet, it does not allow anyone to input a number value. Is there a way I can publish range, and still let users have enough permission to edit the calculations? thanks
Empty File List
My list of files has disappeared when I use the file open dialog ? I have to do a manual search to get them to display any ideas on how to fix this ?
Zoho Sheet 3: Missing shared files
Hi Version 3 looks great. Thank you. However, a number of files that were shared with me by another user have disappeared. The File > Open > Shared With Me dialog only show 3 of the files that were there a couple of days ago. Any advice over how to reach the others? Regards, Neil
Number max of row
Hello, what is the number max of row that i can put in Zoho sheet ? thnaks
Number max of row ?
Hello, what is the number of rows that can seat up zoho sheet thanks
Resizing a column does not complete
A basic spreadsheet feature - resizing a column - does not work well in Zoho. Whenever I resize a column in Zoho Sheet, the UI allows me to drag the bar out, but when I release the cells in the respective column do not resize. When I go to move the bar again, I have to go back to the original location. The only way to effect a change is to move the bar, save the sheet, close the sheet, then re-open. Sadly I won't be able to use Zoho much longer if this bug persists. I've attached a screenshot of
Assigning macros to buttons
My button ASSIGN to assign a macro to a button suddenly stopped working! How can I fix this?
user information Look up display
Hi. I am trying to use the script for the look up from the excel file that i have uploaded to zoho as an database and display the additional details to the user upon the submission of user name. Is anyone have an idea how to create it. Thanks
How can I view and edit groups in sheet?
I have created a number of groups to colaborate on a spread sheet. How can I view and edits the people in a group? Tom
Private Spreadsheets
When I import a spreadsheet, is it automatically private or do I have to change the settings to stop the spreadsheet from being viewed by anyone who does we do not give permission? I don't want the sheet to be accessible to the web and to crawlers. If I have to change settings, where and how do I do this? Thanks
I embedded my sheet into a website. I only want people to view it not be able to edit it. Is this possible?
I embedded my sheet into a website. I only want people to view it not be able to edit it. Is this possible?
Locking certain cells
Is there any way to lock some cells in a shared spreadsheet but allow users to edit others?
Excel Problem
I have one Excel problems, First is I have in A1 one date and now i Want to make Macro when i press to the button to find the next same (date) cell and from that cell to hide everything until Column C. Thank you very much
Context menu in Firefox 12 on Mac OSX 10.7.3
I tried using the context menu (right click menu) in Firefox 12 and only get Fx's standard context menu. When I logged into Safari and tried it, it worked like a charm. Anyone have any ideas about what the problem is?
How can I use the Pick from list functionality?
I uploaded an MS Excel sheet which contained several drop-down menus. Unfortunately, the drop-down menus do not work in Zoho. I noticed that there is a feature called "pick from list". HOwever I don't understand how to use it. Can anyone help please? :?:
ROWS
Can I hide and unhide rows and how do I do this please. Does anybody know. Many thanks! Hans
How do I hide cell content in Zoho spreasheet?
Is it possible to hide the contents of a cell. Functions or formula while keeping rows and/or columns visible where these cells are? If possible could you please explain hot to do it and how to toggle between hiding and showing it back. Thank you Note: Which is the latest version of free Zoho Office Suite available for free download Thank you.
customize specific column widths of embedded sheet?
We are presently using Zoho sheet to display some data on our website: http://www.mftransparency.org/endorsements/ As you can see (in its present form) the "Date" column has been pushed off the screen and can only be seen by using the scroll bar at the bottom of the table. If we could simply set the size of the Category, Country, and Endorsement columns to be narrower, then all of the information could be displayed without any need for the horizontal scroll bar. Is there some way to set specific
Goal Seek using VBA
I was wondering if it was possible to run Goal Seek through VBA. I have tried writing it as I do in Excel and it doesn't seem to work. If it is not supported yet, are there plans to support it? Thank you.
Query Regarding Features in Zoho Spreed sheet
Hi Senior , I would like to know about convert days into months and days Formula(DatedIF Used in MS EXCEL ) in zoho spreed sheet & Features like Conditional Formatting we do in MS Excel(can manage new rule or use a formula to format cell ).Expecting a positive Reply . Thanks Ronak
Newbie
I have just registered for a free account so that I can use ZOHO SHEET. I have assumed that this service is free. Am I correct? I am a bit lost with the application. Where are the help sheets? Can we save spreadsheets at ZOHO, or must they be saved to our pc's? What other free apllication are available. Is SHEET similar to MS EXCEL? Thanks for now Best wishes. A
sheet
Can use ipod with zoho sheet?
problem with IE9 - i can only see grid
Hi, I'm having some issues wid sheet that include data on high numbered rows (i.e. row 600) on Internet Explorer 9. I create a new document just fine, with the mentioned data, and when i try to open it again, it opens fine, but i can only see grid on my iframe in which zoho sheet is embedded! There is no way i can get to the menus or the top of the document (see attached screenshot) In firefox and chrome works just fine Thanks for your help Regards
Can I create folders in the left hand side 'My Sheets'?
Dear zSheet Team, Can I create folders in the left hand side 'My Sheets'? That way organizing a lot of spreadsheets would be relatively easier for me. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Named Expressions in Zoho Sheet
We recently added support for 'Named Expressions' in Zoho Sheet . Named Expressions are similar to Named Ranges except that instead of referring to a static cell, they refer to a formula. It can be useful in the following ways: It can simplify your formulas. If you have an oft-repeated expression or a nested formula as part of formulas in many of your cells, then you can give a name to the expression or formula and then use that named expression as part of your formulas. This simplifies your formulas
Clever permission
If there is a Zoho Sheet document made public it now has the option to edit it. That's good! After clicking, this message appears: Note: any changes that you make will not be saved to the original document. However, you can use the "save to my account" option to save the changes to your zoho account. Wouldn't it be useful if one could edit THIS document directly if I he/she has the permission (via invitation or workspace) to edit it?
Pivot Table
I am completely stuck. I don't understand how to create/interpret Pivot tables Is there a help sheet anywhere? Thanks
Next Page