Link to open another Worksheet
Is it possible to link a cell to open a separarte worksheet within a spreadsheet. I am creating an index in the first worksheet to open other worksheets in the file
Zoho Sheet Changes Report is Inadequate!
When any of those people I gave them the right to edit an specific sheet applies changes to the sheet, I receive a notification in my email. The problem is this notification isn't complete at all and doesn't provide adequate information for the changes. Sorry for comparing with Google Docs again, but please check how they notify administrator about the changes a user has done!
Labels for X axis
I can't insert or define labels for X Axis which makes any chart look useless
We can not add . it only allows , how do we solve this?
Question is above. Valentin
Browser Tab View problem
Suppose I have opened different spreadsheets in tabs of a browser. When I have a look at these tabs, I see them all showing Zoho. Indeed they show the name of spreadsheet after Zoho, but when the number of Tabs is a lot,we can see only Zoho word. In Google Docs, I can see the name of every spreadsheets ,which is too convenient to locate when there are too many tabs open.
Leading Zero
Is there a way to format numbers as text? If we are entering UPC codes preceded with a 0, the zero is dropped. There doesn't appear to be an option to format numbers as text. eakaufman
Zohosheets functionality
Terrific application. Thank you. Works very well. My only suggestion might be that it would be nice if you could elect to have no grid lines, as Excel allows. ....But that is nit picking. Thanks again.
Share Invitiations Not Being Delivered
Hello - I have tried sharing documents with several different business colleagues - some with corporate firewalls, and some without. IN almost every case, they have had trouble receiving their share invitations. A few found them trapped in their spam filters (hoping you're working on whitelisting). But several others never received them at all. I then tested the sharing in Sheets in particular and found the same thing when sharing to other email addresses of mine. The delivery rate is less than 50%.
Cloud SQL external data "Problem in configuring WebData."
I have a Zoho Spreadsheet in which I have several external data links from Zoho Reports via Cloud SQL. After creating the shhet several weeks ago, the links pulled the data in flawlessly. Now they're all broken saying "Problem in configuring WebData." When absolutely nothing has changed.
How to save documents in Zoho?
How do I save a spreadsheet or document I've opened from an email in Zoho into Zoho Sheets or Documents? - D
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
Next Page