Setting row color with a VBA macro ...
Hi, I'm trying to set the row color of the active cell with a VBA macro. My code works, but the new row color is not visible unless I reload my spreadsheet. (Took me a bit to realize that.) Here's the single line of code I'm using. activecell.entirerow.interior.color = rgb(255,0,0) I'm no VBA expert so maybe there's something obvious I'm doing wrong. Do I have to force a redraw or reload somehow? thanks.
Grouping of columns\rows
Does Zoho support grouping of rows\column (feature similar to MS excel -> Data -> Group and Outline) ? Does Zoho support filtering of data (feature similar to MS excel -> Data -> Filter -> Auto Filter) ? Thanks Vaibhav
Selecting non adjacent columns for pie chart
Hi, I am having 3 columns of data, say A B C -------------------- sun x 25 mon x 27 tue x 24 I am trying to create a pie chart for columns A and C. In Excel, I know you can just click Ctrl and select other non-adjacent columns. Can you please tell me the way to do that in Zoho Sheet? Thanks, Mano
Sharing Spreadsheets
I have been trying to share a spreadsheet with a group I am a member of. However, each time I invite them and click share it looks like it will be going through. Then the message about who the document is shared with appears and tells me that no users or groups have been invited. How can I get past this? I have tried several times, but have been unsuccessful in getting it to work. I have gotten it to work in the past, but for some reason it doesn't work right now. Please advise. jweihrauch
Spreadsheets don't show up in Zoho Start
Hi, In Zoho Start, any spreadsheets I have created or uploaded don't show up. They are there when I go into Zoho Sheet, but not on the Start page. In the Box view, there is just a message that says "loading data" that never goes away. The boxes for Documents and Presentations seem to work fine. Is this happening to everyone or just me? I'd like this to be fixed, because Zoho Start is the one place where I would be able to see all my files at once. Thanks.
"FIND" function
In zoho/sheet, I could find a find/search. function. In Firefox, I was able to use the browser find, so no problem there. However, in IE7, trying to use the browser FIND return an error indicating that the object (zoho/sheet, I assume) does not support this feature. Thanks for any help.
Translation not consistent across applications
I am using Zoho applications in Brazilian Portuguese, and it's interesting to see that the translation is not consistent across applications; "feedback", for instance, is "Retorno" in Zoho Sheet, "Comentario" in Zoho Notebook, "Feedback" in Zoho Planner and Writer is not translated yet... mdalves
ERROR 500
When I try to save sheet, there is some error #500. What is it, and how can i fix this problem. kze_admin
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
Linking Encrypted tables into zoho sheet
Dear support I have tables in creator that I wish to link into sheet. I can do this for non encrypted tables. But every time I try this with an encrypted table I fail to make the link. Does this mean I would have to turn off encryption to use this link up ? Regards Peter
polar graph
software does not accept value-range incoplan
Assign Macro to ......
In MS Excel, one can assign a macro to an image or a button. Is there something similar in Zoho sheet? If not, what's the best way to run a macro?
Help pages anywhere?
I was trying to find out how to freeze spreadsheet rows when I realised that there are no Help pages! Is this true? If not, why not and if there are, where are they? I found out about the lack of a freeze facility -you don't have one. And so common... My 1986 (yes!) Commodore 64 had one. When will it come?
Sheets
Would like to be able to link sheets in the same workbook. in other words make cell A1 in sheet1 equal to cell D6 in sheet 2. What can I not do this and is this coming? robblaine
共有する際のアドレス、またはグループの追
表題の作業のとき、目的のアドレス、およびグループを追加するために「Add」をクリックしてもテキストエリアに追加されません。 そもそもされないのでしょうか? 環境 MAC サファリ MAC Firefox woxkinoshita
QueryTables
Hi, I cannot add QueryTable property to worksheet. Has this functionality been added and I am using it incorrectly? With Sheets("Sheet2").QueryTables.Add error message:"Encountered error at line 14 :Unknown field name: QueryTables" the reason I am trying to program, is when I attempt to link external data, only 4 of the 20 tables appear to be selectable.. logansan
Data Input in Spreadsheet: Dropdown/Multi/Check
Thanks for a great option to office. I wanted to ask/suggest if the form input available in creator (dropdown / multi select / checkbox / radio) can be made available also in spreadsheet. Now with Macro availability this will create very interesting options. Regards, Jose Hernandez epjjhl
Technical Support
zoho'nun dilini ingilizceden turkceye cevirdigimden beri sayfa donuyo hicbi tablom gorunmuyo ve dil veya diyer ayarlarda hic bir degisiklik yapamiyorum e3eser
turkish bug.
my turkish interface zoho sheet frized.i want change back to english.. e3eser
我的激活邮件找不到拉
还有不能保存 qianbaise_mz
integrate APIs with my application
Can I integrate zoho sheet apis with my intranet/internet application run work on my application? i mean using API's work it
Importing spreadsheet problem
I import a spreadsheet and I get a lot of little boxes.. which when i hover my mouse over them they say "clone". Why are these here? How can I get rid of them? thanks thrawnknolls
Folders
are you guys going to do folders soon in spreadsheets. My spreadsheets are getting very crowded without some type of folder organization. There is just to many now. Please advise. radiantimt
Office plugin error(s)
i am using Office 2003 with XP. I'm having two errors. I just installed the plugin. First, in "Word", when i click to open a zoho document, the zoho window just sits there. it never loads the page, and i don't get any messages after clicking "open" several times. Next, when i try to open a zoho document in Excel, i get "Error occurred while opening the workbook" and then it doesn't load. any fixes? thanks!
How can I embed the spreadsheet toolbar in my web?
Hi everyone! I would like that all users in my web would be able to change the format and content of my spreadsheet by using the toolbar. I mean the buttons of "Bold" Colors", etc... Unfortunately is not displayed in the embedded version. Although I have tried with a sample sheet from Zoho sheet and it´s displayed. Am I missing an option? Could anyone help me? Many thanks, Nacho soynacho10
Emailing docs and spreadsheets
I am new to zoho and still learning. I like the sharing features better than Google Docs but one thing I find irritating is that when I share (email) a zoho document or spread sheet I don't have a record (or I don't know how to find the record) that it was sent or completed. It would be such a help to have a button I could click on to show who and when the document was shared with right as I view the document. by2sell
How can I embed the spreadsheet toolbar in my web?
I would like to include in the embedded version of my ZohoSheet the toolbar where one can find the icons to change font, color, bold, etc... Do I have to activate any option, do I have to register as a premium customer? Many thanks for your help. Nacho soynacho10
trouble loading different workbook
When I open a sheet view and then try to switch to another sheet from the list on the left side of the page the program hangs and I have to hit the refresh button to get then click on the new sheet to get the spread sheet to open. I am on a new Vista SP-1 machine. It worked earlier on my Mac Intel machine. by2sell
能不能加入一些和excel一样的快捷键?
如ctrl+1是修改单元格格式的等 sblisb
Sheet Error
Hi, When I am trying to login to zoho sheet, webpage shows as below. I reported this error befor and tried deleter some zoho account as per your suggestions. Now I am still stucked here. I would be very grateful if you could help me out of the issue. thanks Ming zoho id: zhumingca FYI-------------------------------------------------------------- var jsMsg=eval(({Localize: "Localize", StackBar1003D: "Stack Bar 100% 3D", isSharedToFollowingUsers: "is shared to following users", Cancel: "Cancel", embedThisInWebpageCopyAndPasteSnippet:
Help require regarding api, link files & report filter
how can i use api function. is there any example? can i access specific sheet data in zoho db? is there possible to report filter header in pivottable?
Zoho Sheet Plugin: Unable to save the workbook
Anyone knows what could be the possible cause for this error? I am using MS excel 2002.
Project on contract basis - using Zoho Sheet APIs
We would like to use Zoho Sheet APIs to offer some advanced features in our web application. Since we have no inhouse programmers, we are looking for independent programmers familiar with Zoho Sheet APIs to work for us on a contract/project basis. If anyone on this forum is interested, please write back to me. Apologies if this is not the correct forum to put up projects. In that case, could the moderators from Zoho tell me where I should put such requests.
Secure SSL Login/Connection
How do you login securely to Zoho Sheet, or Zoho SSO for that matter? CRM has a link at the login. I noticed that once in Zoho sheet I can switch "http" to "https", but is there a way to always have an encrypted connection in Sheet? thanks.
Can't access or enter cells in sheet
Hi Someone has shared a sheet to me not sure where the problem lies but before i signed up i could view the sheet scroll up and down enter cells even thought i could not edit. Now once i'm signed up i can't do either. I have tried on an xp, vista and a mac, using Firefox 3 and Internet exploerer 7.0 as well as safari and i get no luck. On some browsers i get loading xyz [sheet name] but it never disappears. Do i need to modify a setting on my browser, is shared sheet corrupted. Please can someone
The zoho sheet application.
Dosent work, dosent edit. Even the links dosent work. I have support on my browser, zoho writer etc already works. Buta what is the matter about sheet application? Thanks for your interest in advance. veramer
Ability to Insert/Delete Cells
Sometimes I need to insert cells somewhere and inserting an entire row brings in too many and in the wrong places. Can we get the ability to either insert or delete individual cells?
Zoho Writer
I've been trying to get into the Writer application all morning without success. If this service is so inconsistent, I don't believe I can continue to use and recommend. There is no other support posting about this issue, and the fact I can load the other apps tell me there's something wrong on your end. This is unacceptable, and I cannot run a team with things going "dark" without comment or response. macstaq
Freeze
Hi. Zoho Sheet is great but I miss the "freeze" function from Excel where you for example can "freeze" line1 (headline). kennegun
Zoho Sheet
Comment mettre le texte des dates en français kiko1325
Next Page