Formulas
I may be missing something, but I cannot seem to enter a formula with a cell reference using the Excel method. Must the cell reference be manually typed every time? If so, please change. If not, please explain how. esaeo1
Zoho sheet slow and crashes too often
Every now and then I get an internal server error and it tells me to shut down the sheet and reopen and check again.. Once is okay, twice... well, can live with it.. but, 5 times in the course of a 20 line spreadsheet????
"Untitled" for Portuguese BR
in file name box, top, "Sem nome" penas
translate
bravo! now do it for you entire line, please, please. best penas penas
errorcode 12029
I shared a sheet with several people, and gave them full access. One person has no problems at all, an other person's data are not retained (i.e. not saved), and a third keeps getting the abovementioned errorcode when trying to insert rows. What can be the cause of the errorcode, and why does the sheet behave so differently for different people from the same group, sharing the same authorisations? Kind regards, Anton Langeler alangeler
How do you default Australian date format into the Zoho shee
Hi, I would like the default date format to dd/mm/yyyy when creating new spreadsheets and to also be used in any spreadsheet I upload. It seems that my account preferences and locale information does not come across when I create a new spreadsheet or upload a spreadsheet. Could someone please advise as to how this can be done. Thanks in advance sam
excel macros
I had help with the macros for this spreadsheet and I'm not sure if that's what not working but none of the drop down list are populated. Can someone help me? james_chapman
Linked formulas keep getting messed up
I have a sheet with multiple sub-sheets that periodically polls tables in creator. The results are used to develop a table showing progress against budget. However, I have the following problems. 1. All the sub sheets are supposed to load into A3 but I have now found that the update in several sheets now loads into A2. This seems to occur when the creator table is empty (table is set to pick up data from a single day and if no data is available the creator table is empty. 2. Where the table is empty
inline charting with 2 Y axis would be very useful -
Suggestions : 1) I found such chart with 2 Y axis useful (line charts ), especially now that automatic scaling takes place on the Y axis. 2) For inline charts, customizing the X values to include the actual X values is needed. Right now, the only values found on the X scale are 1,2, 3,4, etc. Thanks for considering these suggestions. Michel
Sheet name !!!
Hi When a sheet is open for viewing or editing, the sheet name is clearly visible. The sheet name must be displayed bold and big, and also the it must be highlighted on the left pane. Regards Vivek Ragunathan vivekragunathan
the code of recorded macros does not show up
I am trying Zoho sheets macro recording, and it does not work: recorded macros can be run, but their code will not display! I am using Chrome, I'll try with Firefox next laurent.alsina
how can i run this macros....very important!!
Hey All, I'm no macro expert so i need a litle hand on this one.... I have 2 macros that i'm desperate to make work.....The first one (in the workbook) is macro email sending e the second is a conditional formating...i don't now how to make this macros to work Can you guys help me..? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV If(Target.Address="$F$5" And IsNumeric(Target.Value) And Target.Value>=1000) Then ThisWorkbook.HasRoutingSlip =
sheet.zoho.com is kick BUTT
hey I do not agree with what you wrote really.... please explain in detail a bit more for me ;d thank you
Merge Cells Down
Is there a way to merge cells down? I can merge cells across but am unable to do it down (vertically). It will be a nice feature to have in future releases. cstlhtdf
SendMail Macro (2)
Hi guys, i'm trying to put (inside the code below the date of the task (collum "I" - Finish date) inside my email macro , the macro already send the name of witch task has my the especific condition (collum "E", now i need to add the finish date (collum "I") of the same task .......somebody know how to do it? .Message = "Verificar Cronograma. Tarefa:" & Range("E" & status.Row).Value i've shared me sheet with support Thank's
mapping data (heat maps, etc) ....
I have some data that I'd love to map. Ideally I'd like to be able to create world maps (gdp/capita colored by country) and US state maps (gdp/capita colored by state). Ideally I'd like to break it down even further and map out data by MSA (metro area) and county. I'm curious if this is on the radar. Visualization is so important and maps are one of the best visualization tools. Data that has a spatial component benefits massively from a good map. If there are 3rd party visualization tools that I
When are you going to get the row numbers aligned with wrap
Hi, This problem has been around for quite a while and its really annoying. When are you going to fix the problem with the row number not lining up with the rows when you use 'wrap text'. Thanks
Chrome, break line fails
Hi there, I installed Google Chrome 0.2.149.30 today, everything was fine but the shortcut ALT + Enter to go to next line inside a cell, doesn't work. Thanks a lot. ommmmid
using EOF in VBA
how do i use EOF in VBA instead of using IsEmpty ? (:
permalinks from creator 3 NOT working
Dear Sheet I have 2 problems with permalinks, 1. When I set the cell to update from creator to A3, I find that if the creator table is empty then the cell changes to A2 to update. This should not happen. 2. The permalinks from creator no longer seem to be working correctly. As they now load the following scrip instead of the data. Please fix soonest Peter <!-- $Id: viewperma.jsp <head> <title>Zoho Creator - </title> <!-- $Id: includejs.jsp <!-- $Id: --> <script> var i18n = { }; </script> <script>
Can you out .png images on zoho sheet?
Can you out .png images on zoho sheet? Thanks
Zoho Sheet is dead slow
Hello, This is the zoho sheet 'ProgressWeeklyReport-OSTeam' I'm referring to. We are an HR outsourcing company thus we have a lot of records and database. If you can rectify why the Zoho sheet is so 'SLOW' at the earliest, we would like to have our 'Project Management', CRM and all our activities on ZOHO itself. I tried through Firefox and Google chrome. Through Firefox, Zoho Sheet is still slow. Google chrome really does well when it comes to speedy browsing. Its in our best interest to stay away
Problem fetching new mail
I have setup POP access to my Yahoo Mail account and have successfully downloaded most of my messages. However, Zoho mail hasn't collected any of my messages from the last month - instead it just displays 'No new mail messages' whenever I click on 'Fetch'. Any ideas? Thanks
Sheet Sharing problem
HI- I am trying to share a exel worksheet with there sheets each with different permissions but nothing happens, but if I share the whole document the sharing works,Can someone help me out if there is somthing that I ma missing while doing individual sharing Thanks Anuj
SERIOUS SERVER PROBLEM - ALL WORK LOST!!!
For the last week i have been using Zoho Sheet through Projects and every SINGLE day this error has popped up meaning that there is no way back and no way for me or my colleagues to save the material. THIS IS A DISASTER!!!!!! WE LOST HALF A DAYS WORK ON FRIDAY!!! I'm using the latest version of Firefox 3.0.1 and it has been happening on seperate machines running XP and two other machines running Vista. What's the story?
sheet.zoho.com
Fabulous product! I am running IE 7. When I open Sheet, the cell font is Arial 10 but the row/column header font is Arial 12. This causes the row headers to misalign with the rows in my sheet. It would be great if either 1) I could change the default font type and size myself or 2) you guys changed the row/column headers cell to resize correctly. Thanks for making this wonderful product! twmeredith
Is it possible to Auto add date
I would like to know if its possible to add "current date" to a colum, this sheet will be shared with multiple users, all with edit premission and date is very important. so is it possible to add "current date" to Colm A , when other colums are filled. thank you, Regards Deepa
VBA Excel
How can i achieve a single spacing for each word. I've tried using this code expr1 = Replace(expr1, " ", " ") .Though, it redues the spacing but it's not single spacing of each word. Why is this so?? :)
Replacing words in VBA
How do we replace 2 words in a cell at the same time with reference to the lookup list in VBA excel?
Sheet shared with alternate email ID vieable but not listed
Hi, I have 2 email id Primary email ID & Alternate email id I have added my alternate email id at Accounts.zoho.com -- email -- add new -- add and verify the email All the zoho docs that is shared via my primary email id is listed out at docs.zoho.com But, the docs ( zoho sheet) which was shared to my alternate email is acessible only via the link that came with the email I am unable to see this sheet at docs.zoho.com / or / at sheet.zoho.com Could you please help me with this. I would like to see
Will we ever see Zoho Creator 3.0?
I hope so. I am delaying sales pitch week after week. I don't know how much I am loosing. Thank you Hugo Pires
Interior ColorIndex on Excel Macros
Hi, I'm facing a problem right now. Actually i'm writing some codes on macros to assist in data migration. The whole thing work like this.. the data will be changed accordingly with the lookup list.. so how can i do to shade the cells that have changed to the values according to the lookup list. Pls help... :D
All events are disabled, therefore, any script written for s
Dear Support I now have my formating macro working in excel but when i try to run it in sheet i get this message and when i allow events they turn off again automatically Regards Peter moanazoho
Zoho Sheet does not support "br" domain..?
Hi guys, I'm in brazil and every time i try to open an account using a "brazilian"email...let's say...."marinhogn@test.com.br" then i don't receive the activation email....only when i set the email account as hotmail or any other ".com" that i receive an emal from ZOHO....can you guys help me..?
Reminder Notification on a specific date
Hi, How do you freeze a certain row example header row. Do you have this option. Also I'm working on google Chrome. Still Zoho is quiet slow. Is there an option where you can Deactivate Autocorrect or Auto format option while typing. It seems while we prepare a detailed report this slows the process or even the file does not respond for a long time. When is Zoho coming up with reminders, notifications, alerts for SPECIFIC DATE & TIME. This is a very important feature for any project management. Our
I want excel sheet in my i.d.
i want this excel sheet of Estimated Income Tax for the Year 2008-09 downloaded in my i.d. i.e. above written... Deepak
Spalten/Zeilen fixieren fix columns and rows
Is that possible with Zoho sheets? It would be really nice to have that feature in larger tables! bertrambecher
Tabela Dinamica
Meus Parabéns pela iniciativa, o zoho spreadsheets é muito melhor que o google docs. Porém a tabela dinamica ainda esta longe do ideal. marinhogn
Linked cells do not update between sheets
I have a master sheet on which I update data and various views of that data on other sheets. Each cell is linked back to the master using the =Master.A2 formula for example. However, when I update any data on the master sheet the cells on the other sheets that reference it are not updated automatically which they should be. How do I ensure that they do update automatically? Rob
1\单元格不೦
1\单元格不能合并 2\打印时如何让表格居中. yurenzaian
Next Page