Collaborative editing of spreadsheets by multiple users simultaneously - Is it really possible?
I work in a SharePoint 2010/SharePoint Server 2010 environment and we use MS Office 2007(Excel 2007) . I have been trying to create a MS Office document which will allow multiple users to work on a spreadsheet simultaneously. For that I have: 1) Created a excel workbook and published as a workspace as suggested by Andrea Kalli in her link: http://www.wonderhowto.com/how-to-collaborate-files-between-sharepoint-and-office-2007-182172/ 2) Set up and saved the Excel Workbook as "Shared" and made it available
How do I share a single sheet from ZOHO spreadsheet?
I am sure I saw this option 15 days ago. I just stumbled on it and can't find it any more. I would like to share one sheet of a single document to each collaborator. Was it not possible? Thanks in advance!
Red dashed line around cell
I have a red dashed line appearing around a cell. It does not go away when I clear formatting and I'm not sure how to get rid of it. The formula in the cell is quite simple and the cell is displaying the correct result. The outline also persists if I
Connect a form with a Spreadsheet
I have a spreadsheet that performs once-off calculations on inputted data. I made the input fields editable and locked the other fields, and that works on a desktop browser (Firefox). However those fields are not editable on a mobile browser (Firefox
importXML function and related use case
Hi, I would like to know is the spreadsheet roadmap plans to implement the importXML function? My use case is as following: - I need to get date from a web page and then to compil them - I would like to publish the result in a blog in a form of the dynamic table. The table value must be updated as per the web value. - Because many people ask the way to do that with an online spredsheet, I prefer zoho then Google spredsheet, because when you share a range, the user can style edit it whithout modifying
Working with Zoho IDs in Sheets - Eliminate Scientific Notation
When exporting a data table to Sheets from Analytics, it seems the 18-digit Zoho record ID values get screwed up going back and forth from scientific notation. Actual ID value from Analytics: 586138000007735001 Comes to Zoho Sheets as: 5.86138000007735E17
IMPORTRANGE with table references?
Can IMPORTRANGE be used to get a table instead of a range? More specifically, can I use column references to only get the columns I want instead of the whole table? I want the imported data to grow as the table grows. I've tried this: Where my table name
How can I stop a NOW() from update every time I open the sheet?
Hello, I'm trying to use the current function =IF(B1<>"", NOW()). Is it possible to update the NOW() function only when the B1 cell is modified and not when the sheet is opened? Best regards
List Range In Zoho Sheets Data Validation
Hello, I have 2 worksheets "Sheet 1" & "Sheet 2". I want to set data validation in Sheet 1 but using a named range for the drop-down list. I have set a dynamic named range CSID "OFFSET(Sheet2.$A:$A;0;0;19999;0)". I tried typing in CSID in the list or cell range but it didnt work like Excel. Please help, thanks.
copy format ?
Is there a way to copy the format from one cell, or group of cells to another cell or group of cells.(like the format paint brush function?) Thanks,
Zoho API accessing another drive which is not mine
I used my email to register my organization on zoho, I want to access my sheets with zoho api. But it's giving me the files in the organization workdrive instead of my personal workdrive. Since I used my email to register the organization, there are duplicate
Pick list
I am finding it difficult creating a picklist from the mobile app. Also, I want to format the date display. How do I do it? The app seem to be slow and crashes sometimes
Maj Février 2024
Bonjour Depuis la mise à jour proposée, hier, par Zoho sheet, il m’est impossible d’ouvrir mes fichiers d’emploi du temps! L’application se ferme avant l’ouverture du fichier. que faire?
Sheets running slow
Utilizing sheets for a very simple budget record, simple column adds nothing with fancy overclocking cpu utilization arithmetic . Yet just entering a number in a cell, prompts me to experience the very frequent "working" notification. if this isn't bad
Set table dimensions
New user - I created a new sheet, but can't find any way to set the numbers of columns & rows. When I try deleting rows or columns I don't want (select, right click, select "Delete Rows/Columns"), the selected area remains (or is immediately replaced
The value entered violates data validation rules set in cell E6
Hi, I was trying to shift a data from sheet 1 to auto paste into sheet 2 by press from row and colume at = 'e6' from page 1 and press enter then there have an error pop up said: The value entered violates data validation rules set in cell E6. Please advice what is the solution and what is going on?
Embed With Formula Bar and Headers Not Visible
Is there a way to embed the sheet on an external page without the formula bar or headers showing? Love the product and it's an awesome way to present users with tools and calculators but for aesthetics, it would be great to remove these for a cleaner look. Thanks!
Apply conditional formatting to a row
I would like to apply conditional formatting to a row. This can be really helpful for project based sheets where each row might be associated with a task/to-do. When the task is complete, a cell within the row is Checked/True, or updated to 100% or
Disable copy/cut/export for guests
I need to share a large spreadsheet with lots of formulas so that the guest can edit data to see if the model will work for their needs. However, this is rather sensitive data and I do not want them to be able to copy anything from the spreadsheet and paste it into their own spreadsheets. Is there a way to disable the cut/copy option for guests, but still allow them to edit data?
Is there a way to disable Create and Copy Sheet in external share?
Is there a way to disable Create and Copy Sheet in external share? VBA would be fine, but I'm not seeing it. For our business, large table-style data entry is a must for our orders. I've been able to push Sheets a long way, but I still need more excel-like
Auto shapes in Zoho sheet.
Does Zoho sheet supports inserting auto shapes (rectangle, circle...). I did not see any option to do so. If its not supported currently, is there any plans on bring in this features. Any timelines ?
Do you know any zoho sheet professional, who I can hire?
I am looking for any zoho professionals, who I could hire when I need to deal with my zoho apps. I think, many of us do not have time to learn everything about sheets, flow etc but we are keen to learn as we go with ours needs for solutions. I need to
Sort data in Pivot Table
Is it possible to sort by a data field. I can gruop and filter, but I culdn't find how to sort the results. Tank You.
Can't share, no response
Hello, I emailed sheet, writer, email & WD over 12 hours ago because other than email, nothing is working & I can't work. NO ONE has responded back to me. What is going on???
use of comma as a decimal separator
Hello, I wish to find a way to customize the number format for my proper use. I have to use french data, where the "," is used as the decimal separator : for example the french way to write "3.99�" is "3,99�" Is it possible to do it in Zoho Sheet ? If this is not actually the case, I'd love this feature to be implemented !
Zoho Sheets Row Height Issue
I am having issue with adjusting the row height. The row height for my Zoho sheets have to be at least 47px, sometime as high as 61px. If I decrease the height i cannot see any contents in that cell. This happens to few columns like A or B while column
Cannot select cells
I am using the Android app and don't seem to be able to do the most basic thing: selecting a group of cells. Whether for the purpose of formatting or generating a chart, for some reason I am not able to select the cells I wish to format or chart. When
Text Boxes
Any plans on being able to add text boxes and cell merging in the near future?
Select multiple options in a dropdown?
Hello! I am trying to create a column in which you can choose from multiple options. In this case, it's venue categories as an example (weddings, social events, concerts, corporate). I may wish to choose both "social events" and "weddings." I used the picklist for other columns, but I can only choose one. Thoughts on how best to incorporate this (or another way I could set up this information)? Thank you!
Quicktime movies
Can I upload quicktime movies from my camera and have other people play them from one of these apps. Vince M
Introducing Dynamic Array Formulas to Zoho Sheet
We're happy to announce that Zoho Sheet has opened up the new dynamic array formulas to all our users! The addition of dynamic array functionality will make your spreadsheets and the formulas you use in them a lot simpler, while at the same time making
How to change my sheet to landscape format?
Please help me, I can't seem to find how to change the orientation of my spread sheet, I need it to be landscaped not portrait. Thank you!
Insert/Delete Table Rows macro
Anyone know how to write macros to insert or delete table rows? I use these buttons in Excel all the time for expanding/shrinking BOM tables. I tried recording a macro. But, it is empty after performing the insert table rows command. Looked into writing
[Function Zoho Analytics] - Is there a query function in Zoho Analytics?
Hello team zoho, Is there a Google Cheats query function in Zoho Analytics? If not, how can I replacement?
Stock Prices using STOCK function
Hello, I've been using the STOCK function for over a year without any problems. Today, however, the prices are not getting updated. Might anyone know if there is a problem with this feature? Thank you
How to make some cells invisible to some users
Hi there, I am collaborating with some colleagues and would like to hide some of the information in our shared spreadsheet (a few cells - not rows or columns). Would love to know if it is possible and how. Thanks, O-Ren
PDF tables to Sheet tables
Hi, I am looking for a way to convert PDF tables to Sheet tables. I am unable to find a way to do it. Two additional info for background. (a) The PDF (basically a credit card statement I am trying to get the transactions into Sheet) is password protected
Published sheet download error
I have a published sheet embedded into my website, but when I click the download button, it says that download has failed. I have enabled downloads in the sheet publish settings.
How do I print a worksheet with VBA code?
I want to create a print button on an embedded sheet on a website. How do I create a macro that will print the active worksheet?
Print
does zoho macro support print related function? thanks
Next Page