Worksheet_FollowHyperlink does not work
Rem Sheet Module Option Explicit Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Select Case Target.Range.Value Case "Insert After" MsgBox Target.Range.Value Target.Range.Offset(1, 0).Select Selection.EntireRow.Insert Me.Range(Selection.Offset(1, 0), Selection.Offset(1, 0).End(xlToRight)).Select Selection.Copy Target.Range.Offset(1, 0).Select ActiveSheet.Paste Case Else End Select Target.Range.Select End Sub
Sorting Ignores Frozen Panes
I have a sheet with the top row frozen, but when I sort on a column it re-sorts my header row in with the rest, freezing a new row instead. I'm sorting by right-clicking on the column header and selecting 'Sort Ascending'. The expected behavior is for sort to ignore the frozen row and only sort the other rows. I can't figure out how to get it to not sort on the header row and mix up my headers with my data. Please let me know if there is a workaround.
Problem with using € - defaults to a minus figure!
Hi, having problems using the Euro symbol. I need a formula to calculate 15% of a figure i.e. €188*0.15 but it keeps coming up as -€28.20. Any ideas/suggestions for rectifying this would be great, Thanks
Can we sort rows 25 to 30 based on ascending order of column K
Can we sort rows 25 to 30 based on ascending order of say column? I tried I could not do, any idea??
Office Plug-in Issues
I can log in to Zoho via the Office Plug-in, but am unable to Open any documents either from Sheet or Writer Save documents to Zoho Add to Zoho Publish in ZohoThis has only started in the past few weeks.
Need help on how to automactically refresh after user logs in
Hi. I have created a spreadsheet and then shared with a select number of people. Then, I embedded the shared link for the spreadsheet in my blog. When the other people go to my blog, they can access the spreadsheet privately by logging in using the embedded section. However, they get a continuous loading message and cannot see the sheet shared with them unless the users click refresh. Is there someway I can get around them having to refresh after logging in to view the sheet I shared to them privately?
Sheet/column/row/cell language and locale
Dear Zoho Sheet Team, As far as you might know there are lots of languages and locales around the world. Not all of them use period as decimal part separator. For example, in our native language (Russian) the separator is comma. We are facing big problem with locales in Zoho Sheet, especially while pasting/coping data to/from. THere are no any clarifications/explanations. I have some question: 1. What is the default locale for just created file ? How is it calculated? 2. How can i change that locale?
Can't obtain interactivity on uploaded spreadsheet
I have developed a interactivity tool using a spreadsheet... it works in excell but on uploading to ZOHO it does not... why? As a complete newby if I achieve loading to ZOHO and it appears to work, what name or location do I use to let my friends find it on the web?
Share and collaborate in real time does not act
Share and collaborate in real time
How can I hyperlink from one Zoho Sheet to another?
Dear zSheet Team, I would like to hyperlink from one Zoho Sheet to another? Both of them are private ones. For my internal reference I need to have them linked. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
HYPERLINK function is urgently required!
I been using other Web2.0 spreadsheets that have Hyperlink function as I need links to be displayed as a text word link "More" etc. However, I am very disappointed that Zoho Sheet does not have any function like this. Please confirm when can this function be available as I am in the middle of deciding which Web2.0 to use for a major project. Thanks. davealviso
Linking Cells
I just heard about ZOHO and signed up mainly to try out your spreadsheet. I haven't been able to find any way to link cells, either between modules or between sheets. I have not been able to check all user comments and queries, but for me this would be a major problem. ws41edge
How do you place hyperlinks in cells?
Dear zSheet Team, Please help clarify how to hyperlink a cell to another sheet/cell in the same workbook or another workbook. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Importing Hyperlinks from Excel
I imported a sheet from Excel that contained Hyperlinks. They are not displaying properly in Zoho, they all display "REF#" in the cell, and the cells contain "=HYPERLINK("[link text]";"[display text]") Is there any automated way to convert these links to be readable by Zoho? Is there a Macro that you can give out to convert these links?
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?
Next Page