Suddenly embedded sheet missing data
Suddenly all my sheets embedded in iframes are missing data. It seems like anything in a merged cell (with the odd exception) is not showing at all Is making my pricing tables look rubbish as the column headings have disappeared. Is this something new or temporary? Has been fine until today
Using tags in spreadsheets cells
I would like to add this line in a cell: a2cestmieux.com <info@a2cestmieux.com>, But it automatically change to a2cestmieux.com <info @a2cestmieux.com="">, How can I disable this kind of autocorrect?
Zoho Docs corrupting XLXS file
We have an Excel .xlxs file that we share on Zoho Docs for capturing data.. We have 1 computer that syncs the file to a local drive so it can be used in conjunction with a larger Excel spreadsheet. Have had this setup working well for over a year. Two days ago we started having a problem with the xlxs file sync'd down through the Desktop app being corrupt. When trying to open the file with Excel we get 'Excel cannot open the file because the file format or extension is not valid'. I've confirmed
Maximum Number of Simultaneous Collaborators?
Hello! I am currently researching a viable replacement for Google Sheets for my department at work. We typically have about 20-40 people editing one spreadsheet at the same time. What is the maximum number of simultaneous collaborators in one spreadsheet at one time with ZOHO? I need this answer as soon as possible so that I may begin preparations to migrate from Google Sheets. Thank you! Adam S.
Worksheet Open Event
I'd like to execute a macro when a user opens a worksheet. I tried to do this with this code in sheet "ThisWorkbook", but it doesn't do anything. Private Sub Workbook_Open() Sheets("FirstSheetToDisplay").Select End Sub Any idea?
How can I generate a wide message or report with a macro?
I've a spreadsheet with a lot of data on multiple sheets. I would like to generate, based on that content, a kind of report which I would like to copy & paste into an e-mail program or on a formular in another website. The only way to do this was using the "msgbox" statement. But this is very inflexible, the number of lines are limited, it is not possible to insert CRLF, so it works only for short messages. Isn't there any possibility to extract data from the spreadsheet and generate a report? Perhaps
Does Zoho Sheet support bullets (dots or numbers)?
Dear Zoho sheet? Can I use bullets (dots or numbers) in Zoho Sheets? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Conditional Formatting Bug
I'd like to highlight cells in an area based on a formula. The area is J6:AU44. The formula is =ISEMPTY(J6)*($G6>0)*(J$1<>"") It works. But after a while, I don't know what exactly is the trigger, the formula changes on a magical way to =ISEMPTY(A1)*($G1>0)*(A$1<>"")
Buttons are not displayed on Handy Browser
I recently added some buttons with underlaying macros on an entry page of my workbook. Looks great, work great. But after a while I discovered that my iPhone 6 is not able to display that page correctly, all buttons disappeared, only some pictures and texts are visible. I tried Safari, Opera Coast and Mercury, all same result.
Bug in Sheets: If statement with "<" operator
Hello, last weekend I was fighting against a very ugly bug. It happens in a procedure like this private sub ChangeColor() dim x as variant dim iLimit as integer iLimit = range("Player").value for each x in range("User") x.Select (1) if iLimit > x.value and not isempty(x) then (2) if x.value < iLimit and not isempty(x) then Selection.Interior.Color = 49407 else Selection.Interior.Color = RGB(255,255,255) end if next x end sub When I use (1) it works correctly,
One more reason to move to Zoho Sheet.
Parting with data while moving to a new product is not the case with Zoho Sheet, as the improved 'File Import' lets you bring your files into Zoho Sheet effortlessly. Replace current spreadsheet. Constant updates to your spreadsheet from different sources don't require duplication anymore. Replace your current spreadsheet, while retaining share permissions. Insert as new sheet(s). Use 'Insert as new sheet(s)' to import sheets(worksheets) from various sources into a single spreadsheet. This helps
vlookup not update when requests data from another tab
I modify the source tab, but the destinations using, vlookup not update. I need click cell by cell and press enter (f9 not works). Have any global command to refresh all page? It is my cell: =IF(ISNA(VLOOKUP($B43;QS_AUGUST_2016_AIR.$C$4:$S374;8;FALSE));"";VLOOKUP($B43;QS_AUGUST_2016_AIR.$C$4:$S374;8;FALSE))
ThisWorkbook
Hi, In zoho spreadsheet the thisworkbook should be called everytime a sheet is opened. For my sheet this is not the case anymore. Is there a problem with this function? Thanks and kind regards Ernst
VBA: How dan I insert CRLF into strings?
I'd like to insert new lines into strings which should be displayed with msgbox function. I haven't found anything, the constants vbcrlf or vbNewLine don't work. My goal is, to generate a message based on the sheet content which can be copy&pasted into an e-mail or something else outside Zoho. It works great but I need CRLFs. Example: dim message as string message = "Line 1" & vbCrLf & "Line 2" & vbCrLf & "Line 3" msgbox message range("TextForCopyAndPaste").Value=message
countif returning #NULL! -- formula worked fine yesterday
On my 'Hosts' tab in my spreadsheet, this formula: =COUNTIF(Sites.$N$3:$N$185;$A2) worked fine up until now, where it's only returning #NULL!. The range in question on the 'Sites' tab is correct; I've quadruple checked that N3 is where my data starts and N185 is where it ends. I have a strong feeling that this is a problem on Zoho's side but would love any tips.
Feature Data Validation doesn't work on Handy App
I'm using data validation with area on my spreadsheet. Works great when I'm in the browser, but if I'm in the app, there's no dropdown box showing the valid entries. Even more, it doesn't accept correct entries.
COUNTIF function returning #NULL!
all of the COUNTIF functions that I have in my sheets are returning #NULL! when they worked just fine yesterday. =COUNTIF(P3.H$1:H$5036;"In") is there something wrong with that function now?
What about the error #NULL in excel?
How can i fix about #NULL error?
countif function with compare
In a spreadsheet I would like to count the numbers of occurences that values in an area are greater or equal than a compare value. Both the area and the compare value are referenced. Example: The area is B3:K3 The compare value is in cell A2 In Cell A1 I would like to display the number of occurences, so I'd expect to use a formula like this in cell A1: =countif(B3:K3;??>=A2) Doesn't work as countif compares only values or expressions. Is there any workaround?
Publish only one sheet, not the others
A calculation table can have multiple sheets, I'm using this extensively with cross references to each other. Great! Now the problem: I'd like to publish only one of a few sheets of a calculation. Up to now I can either publish ALL sheets or none. It there any way to make this possible, may be by referencing from another table?
How can I determine the person who is currently working in the spreadsheet
I'd like to generate a "Last Change when/who" entry in a spreadsheet. I was successful with time/date but I have no clues how to find out who is the person who was doing the change. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV range("LastChangeDateTime").Value=Now ' <- this works perfect range("LastChangePerson").Value=???? ' <- what should I enter here? ENEV: Application.EnableEvents = true End Sub
lock cell/sheets for shared access
Hi Is there a way to lock a cell or cell range or sheet so it can not be edited by others. Currently the lock also locks me (the owner of the sheet) out as well.
Why can't I addin Visual Basic? I'm sure its simple...
My code: c_size = application.counta(Worksheets("Sheet1").range("a1:a999")) c_size = c_size+1 My error: Encountered "1" at line 49, column 21.Was expecting one of: <NL>, ":", "&", <DOT>, "^", "(", "-", "+", "=", ">", "<", ">=", "<=", "<>", "\\", "/", "*", "IS", "LIKE", "MOD", "AND", "OR", "XOR", "EQV", "IMP", What am I missing?
Request: Option to Export to Google docs
Hello, I see there is an option to import a sheet from Google docs. I see the Export option has quite a few formats where a sheet in Zoho can be exported to however, it does not have the option to export to Google docs. Would it be possible to put this request into your roadmap? -- Thank you, TXTNLRN Dan text or call: 512-850-4898 Web site: http://www.TXTNLRN.com Teaching and learning through text messages. TXTNLRN Introduction Demo presentation - http://goo.gl/z1MJO or Get to know TXTNLRN http://screenr.com/7yS8
Opening Multiple URLs or Hyperlinks In Zoho Sheet
Hi there, I have a long list of urls in a spreadsheet: http://facebook.com http://perfectclicks.com http://twitter.com Problem: When I click on each one, it opens in a new tab and automatically takes me to that tab. This makes it very slow to open a long list of urls. Potential Fix #1: Can I stay on the current tab when clicking a hyperlink? There should be an option to uncheck "When I open a link in a new tab, switch to it immediately" just like Firefox has. Or, a short cut for this would be great.
display sheets by crm user
Is it possible to authenticate a crm user so that they can see either certain columns and rows or tabs? Thanks
Customizable Charts in Zoho Sheet
Now, create charts the way you want. Show your analysis effectively by picking colors of your choice for various elements of the chart. Visually appealing charts Set colorful backgrounds for your charts. Choose from a wide range of colors for plots, series, titles and subtitles. Choose 'Edit' mode to edit charts with just a click. With the new chart enhancements you can change the color, size, format and font of texts in charts by clicking them. Note: Avoid unintended changes to charts, using the
Impossible to use basic http auth in external data link.
If for example I set https://user:password@example.com/api/data.csv in external data link, a warning says that URL is invalid. Why ?
Can't pablish spreadsheet in Zoho Connect
I have access as administration. In case a document is all ok. In case spreadsheet can't. But for owner all ok, for administaror isn't.
Updating an embedded Zoho spreadsheet
Hi, I have successfully embedded a Zoho spreadsheet on a (password protected) webpage on my site. I would like people visiting the page to be able to update the spreadsheet, but can not find a way to do this. The spreadsheet says ‘NOTE: Any changes that you make will not be saved to the original document.’ Is it possible to change the settings for the embedded sheet so that changes CAN be saved? Thanks for any thoughts. Peter
match or vlookup substring in a cell
Hi Support few cells has a values like MOC-Apple-iPhone-SE-1 MOC-Apple-iPhone-SE-2 MOC-Apple-iPhone-SE-3 MOC-Apple-iPhone-SE-4 I want to count the no cells which contains MOC-Apple-iPhone-SE- how do i do that at the end result should be 4
counting completed check boxes
Hi! I am trying to use a spreadsheet to keep track of a sequence of tasks which must be completed for each customer. I have created columns with the tasks and placed checkboxes in each column under the headings Can I: a. count the fill check boxes and have a tally of completed tasks in a column? b. count the check boxes in groups and change the colour of the box containnig the customers name, according to how faralong the sequence the check boxes have been ticked If not, is there another way to achieve
Merge and sort data from multiple tabs to a single "Master" tab
Our company was using Google Sheets for the last several months and we had a system working great, but are now looking for an alternative. Below you will find the working example Google Sheets we were using. Basically, every call we receive is logged in a spreadsheet in a tab unique to each representative. We have a CURRENT WEEK tab which is supposed to hold a static version of all the calls received by every rep, sorted by date. In Google this was done with a =query() formula, seen in A2 of the
Two Questions
First, is there any way to make the program pause 1 second before continuing to calculate? I can do it in excel but can't figure out how to do it here. I'm reasonably familiar with VBA. Also, all of my worksheets have the maximum of 65,536 rows. No matter how many I delete, it remains at 65,536. This happens in a brand new worksheet with no code as well. I only need a few hundred rows or less on these sheets.
"Document not ready. Please try again" Error message
I have been working on a spreadsheet forever and just encountered this error message. I re-open, close, tried to copy and re-open - no dice. What's the scoop? Edit: Resolved...not sure how.
Freeze 20 Rows At Top of Zoho Sheet
Hi there, I would like to freeze the top 20 rows. However, it only lets me freeze the top 5 rows. I feel like this is a very basic limitation. Is there anyway you can raise it to 25 or 30 rows? If not, can you provide a work around for me and my team. Thanks, Chad A.
freeze in androide
why freeze doesnt show on ondroid ??? thanks
change the backgroung color (gray) of the locked cells in spread sheets
Hi, Is it possible to change or remove the backgroung color (gray) of the locked cells in zoho spreadsheets ? thanks
Losing Content and Slow System
Our company only uses the zoho docs, specifically the spreadsheets, and we have been experiencing a large delay between typing content and seeing it appear on the sheet. We have also been experiencing the loss of content after leaving the sheet. It would be a big help if we could receive some guidance with these issues. Something to note, we have a large quantity of sheets in each spreadsheet booklet that we use.
spreadsheet can not be opened usin zoho sheet as it exceeds the maximum limit of 56
Dear Team Spreadsheet created with 4 or 5 columns and rows, but after uploading into Zoho Docs, it is showing error while opening the same. Please let us know the resolution on the same.
Next Page