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
Axis labels on graphs
My published spreadsheet Go-LCY contains two simple histograms. Whenever I try to label the axes the label seems to disappear after several minutes. Do the graphs need to be saved distictly from the entire sheet or is this a known bug that might be corrected? sidsaucer
Conditional Formatting
I would like to have conditional formatting in sheets (like Excel). I find it very useful.
Joining vertically adjacent cells
I can easily join cells that are adjacent to each other horizontally (left-to-right). But when I mark cells that are vertically adjacent (top-to-bottom), even if they are in just one column, an attempt to join them is ignored, they remain separate cells. I'm not sure whether this is a bug or a feature request, but it should work anyway. I'm using Firefox 2.0.0.16 on Win XP Home 5.1.2600 SP2. Thanks, Klaus
Problem with sheet updating from creator
Dear support I have set up a live dashboard based on a series of tables that are updated automatically from creator. What I have found is that the live dash board changes over time as new rows appear. I think this may be due to the tables that automatically upload being of differing lengths depending on production activity. I will try to solve this by moving the dash board up to the first rows and making sure any tables upload on lower rows. C A better solution would be to put the dashboard on another
Size of files to be uploaded
I'm keen to know the size limit of files to be uploaded integruscapital
Speed issue
I ran into absolutely unbearable speed problems when working on a moderately long spreadsheet. It is named "samples to china". I can share it with customer support. It has 141 rows and 3 columns. When I select ALL and then picked a different font size, the browser simply freezes for 10-20 minutes. The font change WAS accomplished afterwards, but 10-20 minutes to accomplish such a task is absolutely unacceptable! Similar things happen when I want to delete a number of columns together. This really
Formats, locale, regionale settings
Hello, As a future and much needed enhancement, would it be possible to set our own locale settings instead of using Country/Language in the account settings? For example, the locale for French Canada is different than for English Canada : Number/currency : en-ca : $123,456,789.00 fr-ca : 123 456 789,00 $ Time : en-ca : 23:45:12 or 11:45:12 PM fr-ca : 23:45:12 Short date : en-ca : 01/15/2008 fr-ca : 2008-01-15 or, sometimes, 15-01-2008 Long date : en-ca : January 15, 2008 fr-ca : 15 janvier 2008
General Feedback
Got to know abt the Zoho from Hindu news paper today and this is the first time i am using the Zoho apps. They look awesome. - Rakesh. rak826
Thank you so much
your website is actually amazing, I use it for keeping track of my work hours in excel, thanks very much stuart moffat stuartmoffat
MS Office Plug-in Help
Is there a way to change the default location for saving sheets locally on my machine?
Notify on spreadsheets not working
Tried notifying shared users - says "pick at least one user" tho it shows 2 users already in the shared details. - sameer sameer.shisodia
Expense Planner Quick Templates
Zoho Team, How about having quick templates like 'Expense Planners' etc? Wouldn't that bring in more utility value for Spreadsheet users?
Not able to access sheet in IE
Dear Sir, In internet explorer, i was not able to access the zoho sheet as it was giving error every time i tried to access. what might be the problem? Thanks & Regards, Guresh. aguresh
Its really too bad
I just spent 2 hours trying to get used to your "productivity tools", because I REALLY wanted to get away from Google docs. However, I am realizing that your solution is simply not there, which will cause me to abandon you as a client. Its a real shame. Some of the problems I have encountered over these 2 hours: - MS Office plug-in is giving me error messages - Files uploaded through the plug-in appear in Sheet but NOT in Start. There is no way to synch Sheet and Start. - I even tried saving the
charts
I like this. as a regular past user of exhell, I have noticed a really neat feature: For a two series chart [two sets of data] allow for one to be a bar/column and the other to be a line chart. Let's play this scenario out: I have a column of number of widgets and the market share gained that week. For 3 weeks I have 3 rows of data in two columns which I will comma delimit for ya: sales,share 425,5 210,24 635,35 Now if I wanted to juxtapose the two on top of each other in excel, I would pick the
autofilter
what posibility of use autofilter ?? bargatan
linking sheets to database
Is there any way to link multiple zoho spreadsheets to a zoho database? bishwa.oakes
Automatic Updating Broken?
Is the automatic webdata updating not working any longer? It hasn't been for me. It works when I manually click refresh but will not update every 15 minutes like it is set to. I'm pretty sure I'm not doing something wrong because it has been working fine on this particular sheet for many months now.
Can't paste into Zoho Sheet
I have built some pivot tables within Zoho which work fantastically. I need to regularly update part of the data file from an external source which I plan to do by copy pasting from Excel. Currently I am unable to paste into Zoho sheet. guymckenzie
Error 500, every 5 minutes!
There is a constant error that makes it impossible to work with Sheets (I've faced it in Write too) It is this "Error 500: Internal Server Error" that asks to reopen the sheet, but it does it 100 times a day, almost every 5 minutes!!! Please help because a job that should take 10 minutes, wastes an hour! Thanks, Ali
Publishing sheets/range
Hi, What is the logic behind publishing ranges? I have published a range to a website but it doesnt update until i log back into zoho. This range is based on 15 minute interval from another site, so i need this information updated. How do I ensure that it updates without logging into zoho every 15 minutes!?! logansan
Spreadsheet Sorting
I am trying to sort a spreadsheet and I do not see where it allows me to pick which column to sort by. Please advise. radiantimt
zoho sheet pivot tables
When I try to change the way a date field is being brought in, I click where it says "Year", but the drop down menu appears behind the active window. I therefore cannot change it from YEAR to "Full Date" b/c I can't move the window out of the way without the drop down list disappearing. remcentre
Eliminate Cellulite
Fish Oil supplements Report
Email sending macro
Hi all, Been searching like crazy (both here and google..) for a ZOHO compatible email sending macro. Basically, I want ZOHO to send me an email when a cell hits a certain number (ie: stock watch trigger) The cell is a linked external data reference. Thanks in advance for any suggestions or links to someone having done this... Regards, LO
XY scatter plot with dates in the X axis
Hello, I have two columns. The first columns are dates. The second column are values. The dates are not evenly spaced, eg. between two points there might pass one week, whereas between two other points there might pass two months. When I use a XY scatter plot in OpenOffice, the points are aligned according to the date, ie. not necessarily equally spaced. However, in Zoho Sheet, the points are aligned with equal separations even if the time differences are not equal. Is it possible that Zoho Sheet
sheet
terribly slow - good bye garehira
Integration with Zoho DB & Reports
I'd like to be able to import data into my sheet from a DB report I've created.
Sheet not opening with other applications on IE explorer
Hi, We have linked the Zoho sheet with one of our web applications. When we tried to access the information on the webpage (Windows Internet Explorer), the Zoho sheets does not appear on the screen. But its working fine on FireFox. Its happening since today. Pls address this issue. Thanks - naveen
Zoho sheets tough time
Generally, I used to enter the datas in Microsoft excel sheets then i will paste it in Zoho sheets. Suddenly, I encountered the error which says, "Stop script or continue" if i select any one of the option my data gets disappeared. It keeps frustrating me, would you please advice on this? sankarr
NA() function doesn't work
Hi again, I've tried the NA() function and returns "#Invalid Formula". I need this function because i use the "#N/A" type in a chart when cell is empty. Example: fx=IF(ISBLANK($F1.H8);NA();$F1.H8) Thanks in advance!
Next Page