Calculation problem
for some reason the calculations in this .xls file will not calculate http://dl.dropbox.com/u/5219713/FF_XIII.xls i keep getting #REF!New Features: Insert Buttons, xlsx support and time zone preference
We put out a new version last week. You can now insert buttons in your spreadsheets to trigger VBA Macro. This helps you create nice spreadsheet based applications. Our macro functionality will be enhanced further to give you more power. Here is a sample spreadsheet with buttons: http://public.sheet.zoho.com/public/zohosheet/bmi-calculator. We previously supported import of xlsx files (The new excel format). Now, export to xlsx is also supported. Files in xlsx format are now supported via our APIsOffice plug-in picture handling situations
When opening a sheet containing pictures in Excel, pictures will disapear even if appearing on Zoho sheet. Then if uploading the modified workbook, the pictures which disappeared in Excel, sometimes appears up in Zoho sheet (which were inserted in Zoho sheet), but many times they disappear. Conversely, if we open the workbook in Excel and insert a picture in Excel, then upload the workbook and open it in Excel again, the pictures which were inserted in Excel can be seen only in Excel, but not inNo Horizontal Scrollbar
I've been using sheet for a while now on a windows XP machine with SP3, using the latest version of Firefox. No problems at all. I recently bought a W7 laptop and have realized a problem. When using FF on my W7 laptop, I lose the horizontal scrollbar at the bottom of the sheet. (screenshot attached) When using IE8 on the same machine, the scrollbar is there. Any suggestions? All of my sheets run into many columns and the scrollbar is very necessary for me. Many thanks for any help that can beSave selection as PDF
Is it possible to save a selected area of my spreadsheet as a PDF file without the gridlines?google v.s aranınca.
google v.s aranınca. geel giriş sayfası çıkmıyo. sitenin kendi linkinde de farklı bir yerden giriliyo. tek bir girişten girsek . shet write v.s hepsi elimizin altında olsa . sectiğimiz proğram yeni sayfada açıklsa. o proğrama ait bir oturum kapama seçeneği olsa. ve ordan çıkıldığında ana sayfa kapanmasa. süper olur. googlede üst sıraya güzel bir giriş sayfası olusturun accons tarayıcıda ilk çıkan en üstteki sayfa olsa süper oluraccons sayfası direk açılsa ordan girsek sonra diger sayfalara geçsek.
accons sayfası direk açılsa ordan girsek sonra diger sayfalara geçsek. örneğin sheet açık ama biz unuttuk yeniden açtığımızda ikinci sayfa yerine o an açık olan pencere öne çıksa açılmış gibi...... önemli bence bu. bide açık sheet sayfamız var. burda oturumu kapat yerine "shet oturumunu veya sayfasını kapat şeklnde olsa tarayıcıyı kapatmak yerine öyle çıkıs yapsak daha güvenli olmaz mı. hem diğer sayfalar kapanmamış olcak accons olan genel sayfa da oturum kapatılırsa bütün açılanlar kapanaca. çookresim eklemek bakmak v.s
resim leri yan yana yükleyebileceğim sonrada büyütüp asğ ve solda ki oklar yardımıyla ileri geri diğer resimlere baka bileceğim bir bölüm olsa.. ekle butonu olsa. eklene reimi asagıya doğru altalta sınırsız veya sayfalar halinde yanyana 4-5 resim olacak şekilde olsa süper olur. 0507,754,54,24 bence süper fikir . patlama olur site herkesin hucumuna uğrar.drag and drop
drag and drop is an important function missing hereHow can I mask the email addresses?
Hello, I would like to mask the email addresses in a group that share documents or sheets. How can it be done in Discussion.zoho.com, Sheet.zoho.com and Creator.zoho.com Thank you Staff TXTNLRN http://www.TXTNLRN.com Call or Text 512-850-4898zoho sheet
i have a zoho sheet shared from my colleague. there's a annoying problem that i cannot freeze the first row of the sheet in my chrome browser. is it the problem of my browser or simply a bug of zoho sheet?Please support SQL data sources in Zoho Sheet
Please add support for SQL data sources in your "Link External Data" feature. Thank you, Near PrivmanNew Functionality: Two useful mouse techniques for your spreadsheets!
We have added a couple of new features in Zoho Sheet this week. Drag and drop cells: We have now made it possible to do cut-n-paste actions using your mouse. To move a cell or contiguous range of cells, select it and position your mouse over the selection outline. The mouse cursor will change to "move" pointer . Now drag the selection by holding down the mouse button. Once you reach the target cell, release the button in order to paste the content. Similarly, to copy a cell or range, hold down thePrinting Gridlines
We love this program but need to print with gridlines, is there a way to do this?? You can reply to butterflykisseskids@hotmail.com or specially.hers@hotmail.com. Thanks DawnSpreadsheet Does Not Show Negative numbers
This issue has caused a few minor financial issues for myself. I use this spreadsheet to track my spending in order to forecast how much funds I will have remaining once checks have cleared and all expenses have hit my account. There has been a few times that I've mistaken the total amount that I have calculated for a positive, when in reality it was a negative. I didn't realize this issue with your site until I exported the document and noticed the issue. I hope you see this and resolve this issue.Can row and column names be removed when embedded in webpage?
I have a sheet embedded in my web page. Works great. I'd like to be able to make it look less like a spreadsheet. Can I not show the row and column names? You know, like, Col A, B, C and Rows 1, 2, 3...Freeze Header Columns/Rows
Is there any way to freeze header columns and rows? If not, when will that feature be implimented, as that is a feature that I pretty much need before being able to adopt a system. -Justin jmyer (at) incrementaladvantage (dot) comLink to external data by sql
Hi guys, I'm trying to get my company to switch from Office to Zoho, mainly for the collaboration capabilities. One thing which is really missing for me, is the ability to pull data from an SQL data source (mySQL in our case) automatically. Is there a way to do this which I have missed? Do you have any plans to add it? Thank you, Near PrivmanOffice plun-in comment conversion error
When I convert a Zoho sheet for modification in xl 2k10, the Office sync plug-in removes carriage returns from comments when convertion occurs, and so make the comment unusable. It'd be corrected, I think.Selection Buttons
Hi I have a number of registers amongst my sheets where birds, mammals, insects etc are listed in alphabetical order. Is there a possibility to have selection buttons at the top of the sheet (A - Z) and by clicking on a button it takes the viewer straight to that particular section. This would save a lot of scrolling, which a lot of visitors do not like to do. I look forward to hearing from you. Kind regards HansHow many sheets / workbooks can I create?
I am new to using ZOHO and would like to use it extensively for my blog for various purposes. Now I need to know: How many workbooks can I create in a free account? (I have no plans to buy any paid stuff right now) What are the limitations (other than number of workbooks, if any) in free account as compared to premium/paid version? Thanks in advance for assistance Mohit电子表格无法输入数据
你好，我的电子表格没法输入任何数据，不知道为什么？Is it possible to set an e-mail notification for event listed in Sheet?
Hi, I am new to ZOHO. Is it possible to set an e-mail notification for event listed in Sheet? And how to do it? I know how to do it in Calendar, but I need to make notifications for some dates listed in Sheet. Thank You!Cells do not merge
Hi On my sheeet "Birds Q - Z I have title blocks which are 4 horizontally merged cells. It has so far worked perfectly on dozens of items, but in rows 50 and 51 the third and fourth cell refuse to merge! As soon as I try to merge, it goes back to split cells. It's a mystery! What am I doing wrong? Many thanks for any help! HansEmbedded sheet = You do not have permission to access this document.
I had a simple public sheet embedded into my Typepad blog. It worked for years, now it displays "You do not have permission to access this document." I re-embedded the code, republished, and still get the same display in my blog. The URL is http://www.coffeehabitat.com/2008/03/what-does-a-gre.html I am moving this blog to Wordpress, and have the same problem. I also re-embedded the code, republished, cleared my cache, and still get the same display. The URL is http://www.coffeehabitat.org/2008/03/what-does-a-gre/Multi-layer folder - can tagging do a similar job?
I am seriously looking at "Zoho'ize" our company's document storage and sharing. It will be huge since we have several geographically diverse offices who need to share/cync data all the time. Zoho Sheet and Writer can well be an ideal solution - with one exception - tagging. While I love tagging personally, and on my PC, tagging has become the primary means of organizing files, our other users in the office may not be so thrilled. Our shipping team, for example, stores files under a folder such asMacros 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 7paste
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-4898zohosheet表格中列能否按第一个字的汉语拼音排序
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.comLive 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 anIn 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-4898losing 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 imProblems 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. jtmitcNext Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatThemes in Zoho Sheet: Keep your spreadsheet's formatting consistent
Formatting a spreadsheet is now even easier with Themes. With Themes, Zoho Sheet empowers you to select, customize, and apply a uniform formatting style throughout the entire spreadsheet. When working on a data set with collaborators, you might noticeSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Our pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingCheck out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
Most Discussed Topics
Syncing Sql Query Table to Zoho Sheets
I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is thereSUMIF with "=" condition giving #NAME! error
I have =SUMIF(H21:H27;=&B55;I21:I27) which is throwing an error. Have tried =SUMIF(H21:H27;=B55;I21:I27), =SUMIF(H21:H27;"="&"B55";I21:I27) and =SUMIF(H21:H27;"=B55";I21:I27)Data overlapping error - data connection schedule
Hello, I created a spreadsheet and connected it via data connection to zoho analytics, asking to fetch data monthly from a table in analytics. I want the data in the spreadsheet to be replaced each month with the newest data in the analytics' table. Eachzohosheet keep loading and don't know how to fix it
one of my zoho sheet is getting slow. How to fix it.Zoho Sheets hide or unhide columns. How it impacts other users
Hi I would like to know, when someone hides a column in the Zoho sheet, the hidden column is also hidden from everyone else that is using the file. The collaboration feature seems to not work.
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatTip #16: Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-relatedFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
Top Contributors
Vinoth Kumar K
Narendra Eswar G
Murugalakshmi S
Mehnaaz T
kvansensie