Macros keep disappearing
I've created several sheets in ZOHO Sheet all with a number of macros to perform repetitive tasks such as data manipulation and formatting... However, they keep disappearing from the macro list, comes up "No Macros Found" this is happening on several sheets and appears to happen randomly.. its is getting quite annoying to be honest as I'm now having to continually re-enter the macros.. So, in effect I've replaced a set of repetitive tasks with another repetitive task of re-entering the macro !!...
Cell borders
I've imported a sheet that uses some thick and thin borders. It imported keeping the formatting, but now that I've edited it some borders need repair. The border button doesn't allow me to do all the fixes- for example I can't put a think border on the only on a left or right side of a cell. In fact, Zoho only lets me add a thick border to the bottom. And looking more closely, this sheet uses thin, medium, and thick borders... I see from older posts that a more advanced border edit feature was planned,
Zoho Sheets
The cell comments don't seem compatible when dowloading to Excel. Format is considerably jumbled. Have tried various versions of Excel, is all the same problem. Actually, more current versions of Excel are worse. I have tried 2003 and 2007 versions of Excel under both XP and Win 7
paste
Why am I unable to paste info from other files into Zoho files?
Finding option is not working properly
Finding option is not working properly in zoho sheet please look in to it and solve asap.. Regards J.Lavanya..
Would it be possible to allow a member who only read rights to view or chat with other shared members?
Scenario: I shared a Zoho sheet with two members.To one a provided read only access and the other member with read and write. When I started the chat session the member with only read access was not part of the conversation.. Suggestion: To have all members who are sharing the sheet be about to chat. Staff TXTNLRN http://www.TXTNLRN.com Text 512-850-4898
zohosheet表格中列能否按第一个字的汉语拼音排序
zohosheet表格中小区列能否按第一个字的汉语拼音排序 编号 小区 楼层 套型 面积 设施 装修 价格 906c 1号大院附近 6F/6 3+2 90 部分设施 中装 38.5 909c 79大院 3F/5 2+1 70 空调太阳能家具 中装 38.8 891c 79大院附近 1-2F/2 130 独门独院 中装 81.8 830c 上海西路 1-2F/2 3+2 80 独门独院 中装 35.8 东大院 1F/1 3+1 105 中装 85 844c 东大院 4F/5 2+1 60 管道气 中装 34.2 845c 东大院隔壁 3F/5 3+1 72 精装 37.8 647c 东湖望景苑 4F/6 2+2 100 车库10平方 精装修 54.8 908c 中天花园 12F/18 2+1 85 毛坯 46.8 851c 中天花园隔壁 5F/6 3+1 100 平地车库15平方 精装 42.8 887c 中径路血站 5F/6 3+1 82 空调设施齐全 中装 38.5 842c 丰登路 6F/6 2+2 78 设施齐全 精装 37.8 丹桂苑 6F/6 2+2 90 车库19平方，阁楼90,2+2太阳能灶具
Add capability to resize the comment box
Hello, Request to add the capability to be able to resize / shrink and expand the comment box. See screen shot attached. Thank you Staff TXTNLRN Call or Text 5128504898 http://www.TXTNLRN.com
Live Updates not getting refreshed in excel collaboration.
Hi, I am trying to collobarate an excel document between two users. I am not looking for saving the file now. i just want to see the live update and chat window. I will list out what i have done. First i created an HTML file as below <html> <form method="POST" action="http://sheet.zoho.com/remotedoc.im" enctype="multipart/form-data" target="_self" accept-charset="UTF-8"> File : <input type="file" name="content" size="38"> <br> <input type="hidden" name="apikey" value="my api key"> <input type="hidden"
Track Changes by Author?
We are using Zoho Sheets between a group of us in different offices. However we are running into a major drawback: We currently can not see who is authoring each cell. For example...once I create the template and set it to share, I want to be able to have anyone in the group be able to edit it. However when they add or change a cell, it should add a little note or tag to the cell with the users screen name or initials or something. this way if in the future we want to look back and see who made an
In Zoho sheets when the owner of the sheet makes an update....
Hello, In Zoho sheets when the owner of the sheet makes an update.... An email with the link is not being sent to all members sharing the sheet. What am I missing ? Thank you Staff TXTNLRN send a text to 512-850-4898
losing information
hi there, am having problems with data disappearing when I paste it in from Excel. whenever there are more than about 500 lines pasted in they appear to be copied in correctly and saved etc. but then when I go back all the data has gone. is there any reason for this and is there a better way to copy this information in so I won't lose it. I am copying in to an existing worksheet which 3/4 other people have access to. thanks.
VBA code is not working, but works perfectly in Excel.
I'm having a rough time getting my VBA codes to work in Zoho, while it works perfectly in Excel. UserName: In Excel, I use the WorkBook_Open() and Application.UserName functions to get the UserName logged in. I know this is not possible (soon?) for Zoho. So instead, my understanding is that I need to label a cell as 'UserName' and then the user is required to input their UserName before editing. Not fool-proof or error-proof, but it is a slight workaround. However...its not working for me. And im
Problems with Right Clicking on the Sheet
When you right click on the shreadsheet the browser context menu appears with the Zoho Sheet Behind. You can get the correct context menu to appear by holding down the mouse button. Also pressing the alt key on the keyboard appears to fix the context menu in place. I haven't seen this issue mentioned in any forums yet. jtmitc
Importing Spreadsheets
I would like to be able to import an excel file directly to a zoho sheet within an existing document and have all the formulas intact.
为什么我们填写不了东西
我们的文件打开了填写不了让我们十分郁闷
What is the point in showing blank sheets in Zoho FAQ?
I would like to draw your attention to http://www.zoho.com/zoho_faq.html Point Number 12. Sheet 2 and Sheet 3 are blank. I believe these can be pruned away right? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Fetching Data
Hi, I have a database in zoho creator and i need data from my database to be pulled into zoho sheet.In the database i collect the number of sendouts and placements from each employee on a daily basis. What i need is the total of that to be pulled in the sendout and placement cells in here. How can i do this. I also have information about sendouts n placements stored in zoho reports, would it be easier to pull information from zoho reports or zoho creator. Thank You
How to make columns sortable
I've created a spreadsheet that I have embedded into a web page. I DO NOT want visitors to be able to edit the spreadsheet but I DO want to give them the ability to sort columns by ascending or descending order. I can't seem to figure a way to do this. Is it possible? If so, how? Many thanks, CB
shout box in shared files
It is wonderful that every shared files w/ online users can talk live. It wols a be a lot more wonderful if we can also personalize the fonts, insert smileys just like a live embedd shout box can be edited.
Sharing doesn't work
I have tried time and time again to share a document with some collaborators and it doesn't work. Please fix
How can Filter Row Data (Set on Row Topic)
How can i Filter Rows over Row Head Line Description? Auto-Filter: We support auto-filters when imported as CSV files. Again you would need to select the Tabular Data option while importing. Filters for normal spreadsheets will be supported later. When is later?
Border formatting
Hi there, I'm trialing Zoho just now and was wondering if there's the option to format cell borders? Basically just want the option to outline cell borders with different colours and thicknesses. Thanks, g
simple(?) VBA help
I am getting the message "Encountered error at line 9 :Invalid arguments: Object required" when I try to run the macro below, which I copied from http://www.mrexcel.com/forum/showpost.php?s=4ab5add6c1156e7e667e8fe62208e2e3&p=266170&postcount=3. Can anyone explain why? Public Sub main() Dim oRange As Range Dim oComment As Comment Dim sText As String 'Use object variable to hold range. In this example Sheet1 Cell A1 Set oRange = Sheets("Sheet1").Range("A1") 'Use object variable for comment Set oComment
Sheets
One major problem I have with sheets is that if I have multiple tabs in a single sheet, each time I move between them the interface scrolls back to the top. If I have a tab that is a summary of some fairly large set of data on another tab, and I want to enter content on that other tab, its frustrating to have to scroll down each time I change tabs. Charlie
Merging Cells Down
It would be very useful to be able to merge cells down in adition to sideways
My sheets have gotten SLOW. Need advice.
I've been using Zoho sheets for a couple of months-- my objective is to create a few databases that I can sort by date or name, and also insert hyperlinks of images. I've created three such sheets, and as I progress, I've found that using them becomes slower and slower. Perhaps my plan is too ambitious for each sheet? My main sheet is currently about 220 lines, 30 columns. As it's grown, it's becoming more and more sluggish to use. Should I instead create individual sheets for smaller date ranges,
Difficulties with spreadsheet editing
The Zoho spreadsheet feature is great for display. I like how I can not only access it from a website, but I can also edit from the site. Since I don't care about others doing the same, I am not worried about people "stealing" it. However, I have come across some non-user friendly aspects of the service. First, no easy to access "undo" feature. I tried to move some of the data I already typed in to different cells, but I wanted to undo it. I couldn't find an undo option. Ctrl Z only changes
how to: format "german style"?
is it possible to format dates in a zoho-sheet in german style "dd.MM.jjjj" (for instance: 03.10.1989)?
INSERTING IMAGES
I have to insert images into my spread sheets. When I alter the width of any column or height of any row or when I insert colums and rows these images do not move and are all misaligned. I have to move each one manually which is a very time consuming job. How can I prevent this? Many thanks. Hans
not saving properly
Hi, I just noticed that my changes aren't being saved properly, this is a recent thing but my last few updates on my zoho sheet are not being saved properly even though it definitely says my changes have been saved before I close the sheet! But the next time I open it the most recent changes have disappeared. Can anyone tell me what's wrong? I'd appreciate any help, thanks. Ann
Problems with a project
I'm considering using my current Free account with Zoho in order to do the following: -I'm starting a website and want to offer to my users your document/spreadsheet embed tool to publish my spreadsheet (with all calculations and the template) This way, users could use the template I have built and play with the numbers and filter certain data to generate a reporting. -The data that I'm using is available from a web link for direct download into a zoho sheet form a third party website. -In order
user resitrictions...
Is there away to restrict users to only the worksheet that they need to work on?
Can't export a specific spreadsheet
Hello, I've got three spreadsheets in Zoho Sheet. Last week I was able to download all of them, in any format. Now suddenly, I can't download one of them. I've tried it in different options (in the upper menu, on the sidebar) and I even did a save as to an new spreadsheet. Nothing seems to work. Zoho starts loading my browser, and then it just stops. Strangely enough I still can download the other two spreadsheets. Help! Thanks Freek.
Turn off automatic recalculations when moving between sheets
I notice that while moving between sheets my rand() formulas recalculate and mess up the previous figures I had fixed. Is there a way to turn this off? Thanks!
Positive cell values displaying as negative
I have a column of numbers I'm adding up. I'm inserting new rows as payments are made. For the most recent rows, positive numbers (i.e., $55.24) are displaying as negative numbers (i.e., -$55.24). There is no formula in the cell, just a value that I typed in. I tried retyping it. I tried deleting the row and re-entering, etc. and it still shows up as negative. Of course, the totals are off as well. What's going on? This is a pretty scary error.
format cells based on regulars
Is it possible in zoho sheet to format cells based on regulars, like in google docs Best regards Jens
I can't open zoho sheet
Hello, I can't open zoho sheet, in fact, i have only the logo "zoho sheet" in the top-left corner but nothing else ... (on XP => Firefox 3.6.8, Chrome 5.0.375.127 and IE 6) I tried to search in this forum, but i didn't find any problem like this. Can you help me please, Thank you. mazelerat_steven ps: zoho calendar works well
Sheet does not work in IE9
Sheet does not work in IE9. Any workarounds?
How to set a fixed width of column/cells
Is there a way to set a 'fixed' width for cells in zoho sheet? I know how to adjust the size of the colums.... but after I past a large block of text into a cell, it expands the cell size again. (yes, I have turned off word wrap) How can I set a fixed width so the cells don't change size each time I add data to a cell? Thanks.
Next Page