Zoho sheet
gibts ne möglichkeit textmarken zu setzen um mittels hyperlink zwischen Tabellenblättern oder Zellen zu springen? Gruß Jens
Zoho sheets not functioning in IE
Over the past few days, certain spreadsheets are not functioning in Internet Explorer (any version). The sheet hangs when trying to load, and fails. However, it will work in all other browsers like Safari and Firefox. The problem is the same with several shared users when using IE.
sharing spreadsheet
Hi, I've created a spreadsheet template that I wish to share with some of my colleagues. However, where the share button is normally, I just see a publish button. I do not wish to share with everyone, just the staff that I invite. Can someone help? Thanks, Karen Latremouille
Gerer fichier avec sécurité
Bonjour, Je souhaite savoir si, via l'option "Liez les données externes" dans une feuille Sheet, on peut lier des données situées sur un serveur dont l'accès est protégé par mot de passe. Et donc le cas échéant quelles seraient les modalités d'insertion du mot de passe ? Merci d'avance de votre retour.
New Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your work
Buttons not saved
SOS Dear Sheet team I inserted a range of buttons into my "Plants" sheet. They all disappeared. Every time I inserts buttons they have disappeared when I close and reopen the sheet. This does not happen on all other sheets. Please help quickly. Many thanks Hans
电子表格链接外部数据时有问题
当我链接imdb网页时提示无法解析给出的URL， 请用其他URL重试。 http://www.imdb.com/chart/top 开始我以为是被屏蔽了，无法链接，结果用tor还是这样 而且我直接换成IP地址也不行 http://72.21.203.211/chart/top 这些都可以在网页中直接访问，但链接数据时都提示无法解析给出的URL
Append ONLY
Hi, I wish to upload a spreadsheet, and allow anyone to view (READ). However, when it comes to WRITE access I want to restrict WRITE access to simply APPENDing further data to the spreadsheet, but not to edit existing data (however it would be very useful to be able to add notes to existing data). Is it possible to restrict WRITE access to appending only? Can this be done with a Form? TIA
Error Messages/Data Loss
Hi there, We use zSheet in work to share between 4/5 people on a daily basis and are experiencing some very annoying problems. On an almost hourly basis, we all seem to get the following error message: 'The document has encountered a problem.....this document was last saved....we recommend you copy and paste the data..' We also lose data we've entered when we log out and log back in which takes time to put back in and is really inefficient. Lastly whenever two people are typing on it at the
Remaining Problems
Dear Zoho Sheet Team I wish to list remaining items which I am interested in and would be pleased to know whether these functions are now supported? 1 I wish to group / ungroup rows 2 Can images be inserted into cells? 3 Can buttons be inserted into cells? 4 Can cells be merged vertically? 5 Can text be rotated 90 degrees? I look forward very much to your reply, many thanks Kind regards Hans
Insert Row Above function messes up other cell data
"Insert Row" function shifts or deletes data in other cells! It's so maddening, I cannot use zoho if this isn't resolved. I've tried Firefox 3 & IE 7 on a Windows machine, also tried FF on a Mac, same problem...
zoho sheet copying column 1 into all colums
when opened this morning I found that the spread sheet had copied column 1 across into into all columns. I have several copies of the same spread sheet, with minor variation. I have to go back about 5 copies to have it as it should be. How do I correct this?
Split the function
i have this function: Sub STOCHRUN() Range("NOW").Select Selection.Copy Range("START").Select ActiveSheet.Paste Sheets("Summary").Select Columns("H:IV").Select Selection.EntireColumn.Delete Range("A1").Select Range("WPSW").Select ActiveCell.value = 1 ' Dim NSR As Integer Dim N1 As Integer Dim N2 As Integer NSR = 3 N1 = NSR + 1 N2 = NSR + 2 ' ' INSERT THESE TO AVE AND STDEV RESPECTIVELY For I = 1 To NSR Call APSMRUN
HELP PLEASE - 'Error Occurred. Problem while Opening the Document.'
Please help. I have been trying to get in touch with someone in support or sales for the last week and no one has gotten back to me. We are considering using Zoho for all of our business applications, but if we can't get past basic problems, I am concerned we won't be able to integrate Zoho into our system. The problem: I have several sheets shared with around 5-10 team members. Often, they report a problem when opening the shared sheet with them. A small rectangle box appears on screen that says
Spreadsheet add row bug
steps to reproduce: 1: click on row with right button 2: Insert row above 3: type something. The text you enter is posted in another cell instead of the new cell created. Thanks.
Server Outage?
Since late hours of yesterday till now none of the sheets are opening up and new sheets could be created. It just throws an error 'Server encountered error' and asking to open the sheet again. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Suggestion for Zoho Sheet
first of all, this software is awesome! but i'd like to suggest two things that i use a lot in Microsoft Excel and is not available up here... One of them, is the ability to copy the cell above. In Excel, the command is Ctrl-D , and for me it's extremely useful. is there any shortcut like that in zoho? Another one, is, when selecting multiple cells, it shows the sum, average and count and here shows only the sum. And also, in excel i can select multiple cells using the "Ctrl" key, and this is not
Changing owner of Zoho sheet
Can the owner of a particular Zoho sheet be changed?
different options
Is there a way to include drop down options, filtering, locking cells and creating a button to run different macro's?
capabilities of Zoho Sheets
Can someone let me know if the following functions are available with Zoho sheets: Drop down options filtering locking cells creating buttons to run macro's subtotaling (example =subtotal(9,D2:D200)
Sugerencias
Añadir: Capacidad para mostrar/ocultar filas y columnas Capacidad para mostrar/ocultar la división de las celdas Capacidad para formatos condicionales Saludos.
Timeout Error during GetResponse method
We are using the Zoho API to edit documents with our web application. One of our users has been using the zoho interface on our web site to edit their excel document. Till recently they were able to edit the document “AR WRS Inventory Control Reports Draft II.xlsx” (tried to attach, but, getting blank error while attaching). Then they made some changes to it “AR WRS Inventory Control Reports Draft III.xlsx” (tried to attach, but, getting blank error while attaching), and the document cannot be
problem with https url parameter while opening csv document
I get following error when opening a csv document from this url: https://ms.filestoragecenter.com/20111010/TMPFADEMO0.1818070.6295540.630477/38223.csv if I change the url to be http (http://ms.filestoragecenter.com/20111010/TMPFADEMO0.1818070.6295540.630477/38223.csv), then it works. more info: another https url (https://filestoragecenter.com/facorp50/infopages/38223.csv) works! https://filestoragecenter.com has a GoDaddy certificate. https://ms.filestoragecenter.com has a SecureTrust certificate.
i am not able to rename excel sheet
I am getting rename option but it is not changing the name.
Remove one sheet from a spreadsheet
I do not see how to delete one entire page (for example sheet2 and sheet3) from a new spreadsheet. Is is easy to "add a sheet", but how to delete one??
can't see tabs in embedded spreadsheet
I just got a new PC, and now can't see the tabs on the embedded spreadsheet. Everyone else can, so the problem lies with Explorer I think. Any ideas?
Macro's
How can I create a icon to run a macro, so I don't have to click the Macro's button, then click "run macros"?
Does VBA code work in Zoho Sheets?
I'm new to Zoho Sheets and would love to be able to share my spreadsheet with the following code. It works perfectly in Excel (adds a timestamp to each row when the row is updated), but doesn't seem to work in Zoho. Can you give me some assistance into what I might be doing wrong? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$3" And Target Range("A1") = Date End If End Sub Thanks, Jenny
Filter
sheet 可以有 filter 功能嗎? 例如我有 1000 列資料, 但我只想看裡面有 bracelet 的.
Merging
Hello, Currently we are able to merge cells "across" but not able to merge cells "up & down". Can you see this as being a feature in the near future? Cheers, Paul.
where are add, subtract, multiply, divide ACTIONS
Does the sheet have the excel style actions to add, subtract etc , justing using the mouse there is the sum ACTION , but other mouse only actions would be useful frankfx23
When can we insert a checkbox in zoho sheets?
When can we insert a checkbox in zoho sheets? Now it it not possible. I had request this a while ago, they told me, this request is noticed in the roadmap. Do you have any idea when we can may this feature expected? Thank you for your response.
Help with Graphs
Hi, I have 2 columns, one date and the other Number for each date. Now, I want to create a Graph, that shows the trend over the period of time and grouped by month. I think the Area chart would work with each area representing one month. But am unable to make it work. Please let me know how to create this. Thanks, Lepide.
Call Data From Another Spreadsheet
How do I call data from a certain cell in another spreadsheet on zoho?
Unable to freeze
Hi, I am unable to freeze more than one row in Chrome. Is this available or Chrome not compatible? Thanks, Lepide.
External data link overwrites formulas
I have data being imported from a google spreadsheet. When it is imported into zoho, either manually or auto refresh it inserts a blank cell where i had a formula. A very very simple example of what i mean would be: Data is being received into column A. Then column B uses a formula to show same info. A B 1 test test (formula would be ... =a1 2 test2 test2 (formula would be ... =a2 When data is updated from external sheet,
Selection.copy
If i use this. Will it copy the value in the range/cell or it will copy the formula within that cell/range?
Application Defined error:
What does this error mean? Here's the code where i got that error. (the one in bold was the line where the error registered.) This code is originally written in excel and migrated it to zoho's version. Also attached in this post is the original excel vba macro. Here's the link http://sheet.zoho.com/public/uplbapsim/sept20 Zoho Sub APSMRUN() STOCHSW = Application.Range("WPSW") 'Value of stochastic switch If STOCHSW = 1 Then Goto JUMP1 Range("NOW").Select Selection.Copy Range("START").Select
Locking Cells
Has ZOHO implemented a way to lock cells yet? I don't mean freeze pane. I need to lock cells so that only certain cells on a shared sheet can be edited.
Stock Function Cell Reference
Trying to use stock function to reference ticker symbol in another cell. Is this or will this be available in ZOHO Sheets? ex =Stock(A1,"Price")
Next Page