multi-user views change when one person filters - how to avoid this?
I have 6-7 people that will be looking at shared sheet - but when one of them uses a filter, then everyone's view changes to that now filtered view. I suspect no way of avoiding this - but hope someone may have cheeky way to address this? Perhaps having a sheet per user, but then how to ensure that data is consolidated amongst all sheets? Any other ideas? Thanks.
Error in HTML view (Share - Public)
Hello! I created a document. I shared it (Share - Public). Link in html view - https://public.sheet.zoho.com/public/romarast/astra-price-podushka-grechka?mode=html But, row 52 duplicated in HTML-view. This happens with any document in html form - an error in row 52. In Normal view (https://public.sheet.zoho.com/public/romarast/astra-price-podushka-grechka)- everything is ok. For example, a document other guy also has error in row 52 - https://public.sheet.zoho.com/public/dadash2525/dgs-2012-sirali-liste?mode=html
date format problem
您好! 目前提供的包含星期的格式只有: " 星期二,八月15, 2006 dddd, MMMM dd, yyyy ", 但当我选择此格式后日期显示为英文: Wednesday, November 07, 2001 但选中单元格,值为: Nov 7, 2012 问题1, 为什么会显示英文日期? (我已在个人信息中设置时区为中国 东8区, 地域为中国) 问题2, 能否让其显示中文 日期,如 二 11月6日 2012年 建议1: 对日期增加 自定义显示格式 ,便于使用者根据需要显示.
collaboration
Is there a way to collaborate (edit and save) without logging in into zoho? Like google has encrypted URL that anybody can access without login. I need sheet solution for my wiki
Cannot inport Excel files in Sheet?
Help! Cannot import Excel file(s) in to Sheet. What's up?
De-duplication
Is it possible to remove multiple rows at once? Example, If i have my master database of contacts uploaded to Zoho sheets, and I want to remove any unsubscribers on a weekly basis, can i do this in an efficient way? So say i want to remove 100 random (but specific) rows at once from the worksheet, is there a simple way to do this? I normally do this in Access and run what we call a De-dupe - But im looking for an online solution and I dont want to have to upload a fresh database every week - I need
Cell Colors
How do I find out the color code of a cell? For instance, I need to know the color code (RGB) of the blue background in my bird register. https://sheet.zoho.com/open.do?docid=795532000001417485 Thanks for the information. Hans
How to delete a row?
There used to be an X button in the menu to delete a row in Sheets. It's gone, now there's an Insert menu but I can't find any way to delete a row. We use Sheets to manage weekly orders and need to delete and move info a lot. We can copy and paste the cell contents but are now left with loads of empty rows we can't get rid of - we tend to have blocks of 10-50 rows to delete at once. Any help?
Collected Images
Hi Is it possible to sort the collected images. I have about 900 and find it time consuming and boring to scroll through all these to find one collected before. Any ideas please? On the same subject, I assume if I delete collected images I will delete them somewhere in my worksheets; am I correct? Hans
Zoho Sheet 3.0 - New User Interface, Filters, Conditional Formatting and More
We are pleased to announce the release of Zoho Sheet 3.0 with a host of new features. https://sheet.zoho.com The first thing you will notice as soon as you login is the user interface revamp. Zoho Sheet has undergone a major facelift and is now consistent with our word processor, Zoho Writer, and our presentation software, Zoho Show. We now have what we call the MenuTab, which is a combination of Tabs, Menus and Toolbars. To open your existing files, you will have to click on File and then choose
import excel spreadsheet macros update button dont import
I have a pretty simple spreadsheet that allows a pull-down to select values for a few cells cells and an update button served by a simple macro to recalculate the spreadsheet. Importing the spreadsheet does not seem to pull in the ability to pull-down and select the variable cells nor does the update button even appear or appear to have been included in the imported content. Is this what I should expect? any thoughts on why this might not work correctly?. NO error messages . It just does not
Embed options for Zoho Sheet in webpages?
The embedding method of sheets with iframes is cool, but are there any way to pass some options or parameters when I fetch the sheet? Sometimes it's good to let the viewer see the traditional view of a spreadsheet, but other times I really just need the functions and not the rest... It would be nice to pass options for: Sheetname/link - visible|hidden Column/Row headers - visible|hidden Scrollbars - all|vertical|horizontal|none Singlesheet - Able to select specific tab in sheet
Does Zoho Sheet include Forms?
I have it in my excel 2003 file, its when i click on a button a popup comes of of a bmi calculator. I think its some kind of VBModule or something. here is a pic of what it looks like in excel 2003
Two suggestions for Zoho Sheet
1, There should be a way to clear the contents of a row without clearing the formulas in the cells. Is there a way to do that? 2. Excel and other spreadsheets have a way of creating a dataform for entering data into a spreadsheet -- an easier, more attractive way of interacting with the sheet. I don't see a way to do this in Zoho. Any chance this could be added? Thanks.
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!
Next Page