Comments on web
Hi there, Why can't I add comments at the bottom of the sheet? it says comments, and when I click the link, it opens a comment site, and I can type comments, it does not show up. The link to my site is http://www.fsworld.co.za/index_files/logbooksample.htm Thanks Jakes
URGENTLY NEED TO EMBED IMAGES IN SHEET
Hello; It appears that images inserted into sheets just "float" on top of the sheet. If you resize the cells or sort the sheet the images don't move with the cells. We urgently need to be able to embed images into the sheet so that they will move with the cells. Can this be done? Thanks Gino
グループ招待時の入力を簡単にして下さい
グループ作成時、現在はメールアドレスをフルで人数分ペーストしなくてはなりません。 アカウント名での入力に対応をお願いします。 ドキュメントへの招待リストにある名前から直接グループに振り分けできるとなお良かと思います。
VBA zoho sheet ".Find" and "for each next"
2 sheets : first sheet got a list of names in column "a" second sheet got a list of more names with a value in cell B I need to bring back on the first sheet in regard of the matching name (if the name has been found) I got an error on the ".Find" if not, any idea to solve that issue ? thanks for help Sub getvalue() ' For Each cel In Sheets("Feuille1").Range("A1:A100") With Sheets("Feuille2").Range("A:A") Set trouve = .Find(cel.Value, LookIn:=xlValues, lookat:=xlWhole) If Not trouve Is
hücre koruma fonksiyonu
hücre koruma fonksiyonumu yok yoksa benmi göremedim (exel de)
hyperlinks
I cannot understand why it is not possible to select text and insert a link just as easy as one can do in any Office suite.
Problemas Guardar
Buen Día Tengo compartido un archivo de excel, el usuario tiene el permiso de Lectura/Escritura, puede ingresar datos en la celdas pero estos no quedan guardados, qué se debe de hacer para que los cambios sean actualizados correctamente? Saludos.
Help! Spreadsheet disappeared!
One of my spreadsheets—the important one, of course—has disappeared. It's not in the trash. Where could it have gone? How can I get it back? The title of the sheet is "Term 2".
Filtros
Cómo puedo ingresar un autofiltro para un determinada columna en Zoho Sheet?
How does a shared user save the spreadsheet?
How does a shared user save the spreadsheet? He was given read/write permissions. Is there a save button?
How to link to a document stored under documents.
I have a spreadsheet and need to be able to use a hyperlink or other method to link to a pdf document I have saved. I don't need to download the pdf just want to be able to click on the link and display it. Is this even possible at this time. Thanks.
Norwegian translation
Hello, I just completed (100%) the Norwegian translation of Zoho Sheet. I notice that most of the other products have not been translated, or not completed. For the translation of Zoho Sheet into Norwegian I used the very good module found here: https://translate.sheet.zoho.com/l10n.do 1. How can I translate other Zoho programmes (such as Mail, Writer etc.) with a similar tool? 2. As a Zoho Business user, is it possible to use the Norwegian version in Sheet, whilst using English for the other programmes
Stock function and cell formatting
Hello Forum, I am trying to fetch some stocks in a sheet. I use a brand new sheet, set an entire column to currency € and fill it with =STOCK("xxxx.xx"). At first it works great, all cells show the stock price correct in EURO. I can save the sheet and access it later without problems. However after a week or so the cells start to show garbage, it first looks like strange dates and when I try to set them back to Euro, they show astronomical numbers. If I delete the cells and re-enter the formulas,
Pivot Table - Sum of Time
I have a table w/ following structure; "Daily time log" Start | End | Category | Duration 10:00 11:00 Project 1 (end-start) = 1:00 11:00 12:00 Project 2 (end-start) = 1:00 13:00 14:00 Project 1 (end-start) = 1: 00 Now, when I attempt to create a pivot table, it was not possible to create "SUM" of duration. "category" as row - categorize "duration" as data - SUM of duration Zoho sheet identifies duration value as "text" hence "SUM" is not possible. what
Linking Data
I created a Zoho Workbook - using Zoho Sheets - I was wondering how I can have one sheet with all the information on it from all the other sheets in that work book (this one sheet would update automatically as the other sheets updated)
ok
muy bien
=(RANDBETWEEN(1;2))+1
=(RANDBETWEEN(1;2))+1 I must have pressed F9 a hundred times, but this always produces a result of 2. Shouldn't it produce a 3 occasionally? It does in Excel.
Bold all outside borders
I can see the options to bold the bottom border. But I desparately need a way to bald all outside borders, which is a typical way one wants a table to look like. How do I do it?
同一账号同时登陆的问题
一个账号，两个用户同时登陆打开同一张工作表后，编辑的数据保存时会冲突。 能不能增加一个正在登陆编辑的通知
Limit of table dimension
What the limit of table that we can create?
image size on screen
There appears to be no way to zoom the image size on the screen. Can this be done?
Unable to open any sheet using Microsoft office Plugin.
Hello. I' ve just installed the Microsoft Office plug-in and i war trying to evaluate its behaviour. Unfortunately i have errors when i try to open a sheet i've created using Zoho or when i try to upload a sheet created with Excel locally. It seems Zoho plug-in is not able to save it locally. I use Microsoft Office 2003 on XP and we use "folder's redirection" within our LAN (so the folder "Application Data" under the user's folder isn't on local pc but is on one of our servers). Any suggestion? Thanks.
Pivot Table in Sheets
Is this functioning? I can't create a Pivot Table of any size
浏览器禁止Cookie
打开sheet.zoho 时出现 您的浏览器禁止Cookie。请开启cookie然后继续。 正在加载.. 无法登陆如何解决？
Problem Configuring WebData
I am trying to import data from the following HTML page: http://www.tiaa-cref.org/public/performance/retirement/index.html But when I select all tables I get the error "Problem configuring WebData" The website I pull this from recently made some changes which broke the original link I had, ( which worked), and now that I've updated the link, it generates the error. I can import other webdata fine. This sheet is shared already if you want to take a look (re: the error 500 thread). Thanks, Robert
Shared r/w sheet can not be opened
For the last week or so I have not been able to open a read/write sheet shared with me. It was working well, but now when I try to open the sheet, it seems to freeze. I can see it, but the message box Loading Battle Nominees..... doesn't go away. Interesting note, though, when I export the sheet that works and allows me to see the sheet on my machine in xls. The owner of the sheet can not open the sheet either. Can you help us? What should we do? We really would like to continue using ZohoSheet for
Problem with refreshing stock quotes
When I use =STOCK("AAN","PRICE") for example to get a price quote to my sheet, I am not seeing it be updated after the first time. What or how do I allow it to refresh regularly?
Is there support for filters in Sheet?
Do filters work in Sheet? I can't seem to find them, many thanks
Embedding Files Problem
Hi there, When I select Publish for the Sheet application, I am not presented with the option to select an External Blog/Site. Anyone know why? Thank you, Jonathan
Row heights
I am trying to alter (reduce) row heights, but every time I input a new height it jumps back to the previous height which I am trying to reduce. How do I alter row heights to the figure I want? Many thanks
Macros View shows blank
Whenever I try to write a macro, or record and then edit, the editor screen shows nothing under macros. The macros I recorded will run, but I cannot edit them, or create a macro in editor. Any ideas? fgtrent
Creating Folders
How do I create folders to store my "sheet" documents
3 Suggestions :: Sheet.zoho.com
1. It would be nice to be able to organize sheets into folder. With the current setup, it gets pretty messy. 2. Being able to change the color theme (not very important, just a nice to have) 3. Make sheets.zoho.com redirect to sheet.zoho.com. Marine
How do you move cells
I have a spreadsheet here and i was wondering how to move cells. Ex: say i have in cells A1, B1, and C1 "4, 6, and 8" respectively. How do you select these cells and move them to, say, D4,E4, and F4?
Link to external data
If i use link to external data 2+ times in a column(s) (one starts in the cell after the previous one ends), and the website w/ the external data updates it to add one row or more, will the other ones below it get bumped down automatically? if not, is there an easy way to fix this so taht they will show properly? Edit: I was actually wondering if cells that are linked to the external data would get updated to new positions when new data is added. Ex: external data goes from A2:A9 and cell B3 is "=A5".
How to save a file white a especified name?
My problem is: I've opened a file, from my server, AND I've set the filename to Nome.xls (example). when I save the file in Sheet Editor, the generated file is a randon name, like 1266599308448_12001000006853433.xls But I need to save the file with the especified filename. Everytime that I click in the SAVE BUTTON, another file is generated, and I need to update the opened file, for example. How to solve it?
Can this application run locally?
Hello, I have a web page for the lab of my company. Of course this runs in the intranet so I need this application to run locally. I have been googleing the internet and found ZOHO. I have been navigating in the forum for similar questions and the most recent I found was from 2008. By that time it seems there was no option to do so. At this time, can Zoho run standalone? Regards, Hector
如何上传一个文件以更新现有文件，而不是重建为另一个文件。
如何上传一个文件以更新现有文件，而不是重建为另一个文件。
Not really unlimited users as you advertise!
It says that a FREE account has unlimited users but this isn't true. I tried to sign up more then 20 users for my spreadsheet and I am unable to do so. What do you mean by unlimited? Am i doing something wrong? PLEASE advise thanks
Error 500: Internal Server Error - Sheet
I can't save anything in sheet once I enter a formula. Just copy/pasted a bunch of data (numbers only) and saved no problem. Is there a fix for this? Thanks! ZOHO is the Bomb! Paul
Next Page