Need to read a zoho sheet document on Excel
I need to read a Zoho document on Excel and to have data updated currently. I've tried to use the HTML published version of the document https://docs.zoho.com/sheet/published.do?rid=ctdnu07c9dce2917b400e9ce0e918759ee098&mode=html Same way I've used to do with Google docs, but it had not worked. How could I have the data updated on Excel? Is there a way to have the file published on a CSV format? Best
Freeze more than 5 Rows or Columns?
I'll bet I'm not the first to ask: Why can't we freeze more than five rows or columns? There are some times when it would be VERY helpful to be able to do so. Or is there an upgrade version that allows this? Thanks, Greg
Tracking down Spreadsheet Errors
Hello, Does Sheets offer Formula Trace other feature to assist locating errors in a formula? I have created a complex sheet and am off by a small amount making it difficult to locate my own error. Thank you Davd
Cannot change cells in embed sheet
I have zoho sheets embedded in my blog and I can no longer change cell value in the cell itself. The only way to change the value is to go to the formula bar at the top. Thanks, Shayne
Today Function not working
The today() function is not loading the current day when the sheet is loaded. It is loading the date when I entered the today() function. Thanks, Shayne
Error in Today Function
The today() function is not loading the current day when the sheet is loaded. It is loading the date when I entered the today() function. Thanks, Shayne
pivot tabel
Cant create a pivot tabel any one knows what i am doing wrong??
Pivot tabel
Hi! I'm trying to do a pivot tabel and i cantdo the pivot because it always appears this error: your edit is not applied to the document. please try again later. does any one knows how to overcome this problem??
Goal Seek through VBA
I was wondering if it was possible to run Goal Seek through VBA. I have tried writing it as I do in Excel and it doesn't seem to work. If it is not supported yet, are there plans to support it? Thank you.
Automatically Move Cursor from Left to Right
I am using a Barcode Scanner and entering Data. My Data Needs to move from Left to Right when each part is scanned. Can I do this in Zoho? With Excel you go into options and select the direction you wish the cursor to move. New to Zoho. Thanks for the help.
how do I do procentage
how do I get de sum of a procentage
Unable to open xls files
Lately, I've been unable to open xls files. This issue is also present with Google Sheet.
Customers report cannot see iframe content
I have started getting reports over the last few weeks that people cannot see the iframe inserted on a page. I insert my on a website using the publish range and insert the iframe code, so I can update the prices within zoho. This has worked OK for years, but recently people are saying they can't see the iframe, and they seem to be increasing numbers. Sometimes Safari, sometimes Internet Explorer, never Chrome and it works OK on iPhones and iPads. Has something changed? Is anyone else having this
How secure are my hidden formulas?
Hello, I am writing a spreadsheet to be shown on a wix website that uses confidential formulas that cannot be shared or viewed by anyone, including (for safety sake) zoho. When i use the hide formulas function, how secure is this? and what happens if the hidden function is down for a day or so, will by formulas be available to see? also will they be able to be viewed by Zoho programmers or employees? Thank you for your support!! -Kenneth M.. Brooks III
Unable to Move or Copy/Paste a merged cell
Hi, This issue started this morning across all users of our Zoho Sheet Workbook where we cannot move a merged/unmerged cell from one cell to another. Even Ctrl+C and Ctrl+V copies over the colour of the cell and not the text itself. Prior to this we would just hover over the outline of the cell and drag and drop it in to the desired location, however this does not work anymore. Please advise of fix for this. Thanks
offset not work ?!
https://docs.zoho.com/sheet/ropen.do?rid=1d772438222c67af6465785f486b2b4b34025 in excel column MEDIC work with this formula Data Validation =OFFSET($AD$2;MATCH(C3;$AC$3:$AC$138;0);0;COUNTIF($AC$3:$AC$138;C3);1) in zoho not work :( pls. help!
ipad and smartphone users can't edit the spreadsheets I share with them
I have set up a spreadsheet in Zoho Docs for members to input data. They all have read/write privileges: using windows browseers users have no problem entering data in the cells, but using the apple ipad users cannot input data, they only get a viewer mode when they access the shared file. How can I solve the problem, so that apple ipad users can also input data into the spreadsheet? Thanks for your help! Edit: Not just an ipad problem: Users also cannot modify the sheet using smartphones with Firefox
Copying data from one sheet and pasting it onto another sheet.
Hi I have quite a simple requirement. I receive data in the form of a spreadsheet which I open in Zoho sheet. I have another sheet which has a number of tabs pre formatted and are used as reports. All I want to do is to copy the data from the first sheet and paste it into the second sheet. From there I can manipulate it. I can copy and paste between 2 tabs on the same sheet but can not workout how to do it between 2 sheets. On my pc I can happily copy and paste between 2 excel spreadsheets. I am
unable to copy & paste between doc earlier today
I have no problem to transfer information within the same document. However, I couldn't copy information from Doc. A, then paste to Doc. B... I don't have this problem until earlier today. I asked around, none of my friend could copy & paste info between 2 sheet doc. any more. Would you help to solve this problem? Thanks
Problem with shareing Excel files
Hey, I'm trying to share excel files with another Zoho user. I share file entering another user's email, then it gets confirmation and notification. Also that file becomes visible, but after shared user refresh Zoho docs dashboard page, that file disappears and it is not visible also in "Shared with me" folder, also in another folders. How to solve this problem? What do I do wrong? Thanks.
i can open any folder in my account
hello since yesterday i can open any folder in my account it shows "loading" .... and nothing happens i am alone like this ?
Cannot open my folders ...
After click the folder(s) I chose, it showed "loading" for a long time, and just that ..... I tried to use other computers, and they were the same.
Unable to scroll down on my sheet on IE8 and windows XP
Hi there since the upgrade to zoho i can still access my zoho sheets ok, however, i am unable to scroll to either side or up and down to access more of the sheets. I seem to be able to do this from my home computer so I assume it is a compatibility issue with IE8 and windows XP? as i am not an administrator on my work computer I am unable to upgrade to IE9 or switch over to firefox etc. Will this issue be getting resolved at some point? Cheers
Forms in spreadsheets
Hi, I need to enter some data and show results by querying that data. For that purpose is it possible in zoho docs to create a form in spreadsheet? Kalpa Pathum Welivitigoda http://about.me/callkalpa
Allowing anonymous users to add data to a spreadsheet possible?
Hello, I want to create a simple list of data which is then filled by lots of people e.g. an adress list, none of them have zoho accounts, so technically their are anonymous. Is there a way to do this? Currently all I get is a published page which is write protected. I have no idea how to turn the write protection off
Zoho docs still free for personal?
just find the interface changed when login. Zoho docs still free for personal? THX
Offset function spreadsheets
Offset function using cell the formula is located in results in #CIRCULAR error even though the reference is valid. When comparing two sets of similar data contained in adjacent columns, I am used to the following: =Offset(g10,0,-5)=Offset(g10,0,10) , in the column between two sets of data to be compared. The false values highlight differences and I then shift or move data to line the comparison data up. Without use of offset function, moving the comparison data makes the comparison formula also
Data Validation and Blank Cell Option
I have an Excel spreadsheet that we use for estimation of construction costs. A key feature of this spreadsheet and used, in many of the cells, is Data Validation with a drop down choice (either from cell range or a list) and I have tried to export this to Zoho Sheet. Most of the spreadsheet exported fine but I had some issues with the Data Validation and decided to re-write the cells. The problem I am now having is that I need to have a blank cell which is the default, and I need help in doing
Google Chrome on Linux. Cell contents are deleted when pressing arrow keys.
Google Chrome on Version 36.0.1985.125 Ubuntu 14.04 LTS When editing spreadsheets on Google Chrome, shifting cell focus by pressing the arrow keys deletes the contents of the cells. Using Firefox on the same system does not replicate the issue.
unlimited users
I am trying to use this program to share a few files with about 15 people. When I signed up it said for the free version there is unlimited users. However, once I started using the product it says I can only have up to 10 users. Can you shed some light on the discrepancies here? If I can only have 10 users this is quite disappointing and misleading. I already took the time to do up the documents I wish to share.
Using macro to enter relative reference formula
Running the following macro ActiveCell.FormulaR1C1="=RC[-5]*RC[-2]" in cell G17 results in #UNKNOWN error with cell contents =B17*RC[-2] i.e., Zoho is correctly translating the first relative reference but is treating the second relative reference literally.
Long text is not displayed on top of subsequent blank cells
In desktop spreadsheet applications such as Microsoft Excel and OpenOffice Calc, if text that is entered into a cell is too big to fit in that cell, it is automatically displayed on top of the following cells in that row, even if the cells have not been merged, as long as those subsequent cells are blank. In Zoho Sheet, this does not happen. This can be very frustrating to our users, who often compose their work in Excel and then import it into Zoho. They find that while there text was being displayed
Printing
Up until lately I have been able to select all on my spreadsheet and then do a print in a web browser. Here lately this has barely been working. Today it took 20 minutes to print one page. I await your response. Thanks
Font size
Is it possible to change the font size to size 200, or is it limited to the 72?
Macro enabked spreadsheet
Hi # I am new to Zoho Docs and was recommended by a friend. I was wondering whether there is anyway I can have VBA (macro enabled) spreadsheet available on Zoho so I can share the documents with colleagues. Thanks in advance for your help
Hide Gridlines
Hello Support, Is there any way to hide the gridlines in a spreadsheet? Thanks very much
Rollover
Hi Is rollover possible on Zoho docs and if so, how do I do it? Thanks Hans
Stock Option Quotes
Is it possible to obtain quotes for stock OPTIONS (i.e. puts and calls) in Zoho Sheet? Also, please note that the format for stock options on U.S. exchanges has changed. Thanks
Cell Protection in Zoho-Sheet
I imported an xls file with some colums protected, but once in Zoho, all protections were gone. My main use of Zoho would be to import xls files with only data input cells un-locked. Or, the ability to lock cells again, once in Zoho. Is this possible? Thanx
Spreadsheet Display Problem
Recently, we have been suffering a vertical shift of part of the spreadsheet. It can sometimes be solved by refreshing the page, but not always. It goes without saying that this can be a major problem if the shifted parts happen to line up. See image.
Next Page