Why am i unable to use an aerial font smaller than 10 pts?
Why am i unable to use an aerial font smaller than 10 pts? Without being able to do so I'm unable to get a decent looking printout onportrait. I can use 'fit to page' but it doesn't look right?
Comment enhancements - more productivity inside the box.
Let's say you're building a sales forecast for your product or developing a marketing budget for your team. You start out with a spreadsheet and soon realize that you need to work with other people: to validate assumptions, get estimates, verify processes etc. Do you find yourself sending emails, making calls—trying to reach people—cutting, pasting, waiting... waiting for the input you need? Built right into Zoho Sheet is the prescription for this headache. It's called Comments. Now we've improved
*URGENT - Zoho Spreadheets (Disabled Macros error)
Hello, I really a fix for this in the next few hours. For whatever reason VBA code keeps disabling when a selection in drop down F is made and producing the following error message:''The following error has occurred in Sheet 2 at line 3. You cannot modify the locked cell range'.'. I thought I had fixed this last week but when 12 uses go access to the shared spreadsheet the problem returned. It seems to be one issue after the other... Can someone please contact me ASAP on my mobile phone ASAP (linked
Unable to connect to messaging service
HI , I get this message when I open a Zoho Sheet. The funny thing is that when I open the file from my mobile phone, it opens ok. But when opening it from the desktop, errors appear on the formulas and the "Unable to connect to messaging service" appears. Can you help ? I am testing and evaluating Zoho to see it is answers my companies needs . Thanks
merging duplicates & searching for format types
Does anyone know how to search for Format = bold and so that I can get results on a search for all cells that have been bolded? Also, want to be able to remove all duplicates / any tricks to this? Thanks!
MESSAGE: "the server has encountered an error. Please try again later"
I was going to use a spreadsheet now. it wont open or let me use it. Keeps giving me the msg on the title. Can you please have a look? It opens for few seconds and after is gone Thx, Joao
Cannot view AWS S3 files in zoho sheets excel viewer
I cannot view the aws url in https://sheet.zoho.com/sheet/view.do?url=https://s3.ap-south-1.amazonaws.com/ledgers/8/books/58850833.xlsx?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAJLJ6P27HLOO6Z2MA%2F20170807%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20170807T125701Z&X-Amz-SignedHeaders=host&X-Amz-Expires=900&X-Amz-Signature=d0d124559f098c31b61e49f5d99408abea0c4681cfd9b47d2c6774055d1427f6&name=58850833.xlsx
linking MS Excel with Zoho docs Excel
Hi team Is there any possibility to link Ms Excel with Zoho Excel such that update made on Ms Excel can directly modified in Zoho. Awaiting ur response ASAP.
Macro error
I'm new to Zoho sheets, and have been having issues with Macros (if statements in particular). Currently I receive the following message when running a macro (copy/paste from excel vba). Unknown function Worksheet_Change Below is the code, starting with the line that referred to in the error. If count >0 Then Range("A2:A999").ClearContents Worksheets("Want List").Select i = 9 Do While Cells(i, 2) <> "" i = i + 1 Loop For j = 1 To UBound(Qty) If i + j - 1 =
Auto populated sheet data from a form (zoho sheets)
Having created a form with 5 variables, I have decided I don't want the 2nd, 3rd or 4th variables anynore and have deleted them from the form, which has deleted them form the sheet. This leaves me with the 1st and what was the 5th variable on the form. In the sheet I have timestamp, user, then variable 1, then three empty cells, then variable 5. How can I tell the form to enter var5' data in the cell immediately after var1, I have A B C
Zoho Sheet and Freeze Panes
I am opening an Excel workbook in Zoho sheet. The workbook has images in the top rows of cells. When I freeze panes, the images disappear. The images reappear when Unfreeze is selected. Is there a way to make this behave as it does in Excel, where the images remain visible regardless of Freeze?
Can someone help me with Zoho spreadsheets?
I requested an appontment call back which I never received early this morning. I've just rebooked and the time that I've been booked for is appearing as 3:30pm CST time, when I specified my time zone as Beijing, China time. 3:30pm CST time is early in the morning in China. Can somone please cancel this appointment and just either call me any time during the day, China time or respond to my previous thread?? This query about macros has now been going on for 2 weeks!! If converting the macros from
Allow Anonymous Collaborators
Hi, I would like anyone to be able to edit a sheet but without logging in or added as a collaborators. Is there such a thing as world read/writable?
Split Function
Hi, Is the a split or equivalent function available? Here is what I'm trying to accomplish. If a cell has 5 names (John, Bob, Larry, James, David) I want a count of the names. In Google docs, I accomplished this by doing =counta(split(A1,",")) It's hacky but it works.
Problem with macros
This code return error Wrong number of arguments or invalid property assignment: _Default Public Sub ReCalculate_acepted_contacts() i=10 j=2 'это шаблон заполнения Sheets("Сводная").Cells(i, j).Value = get_acepted_contacts(Sheets("Сводная").Cells(i,i)) End Sub But this code is work correct Public Sub ReCalculate_acepted_contacts() i=10 j=2 'это шаблон заполнения Sheets("Сводная").Cells(i, j).Value = get_acepted_contacts(Sheets("Сводная").Cells(10,2)) End Sub In first example
Link to table on a web page
A table is updated daily on this page: http://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml ...and I wish to update it daily on a spreadsheet. When I used google sheets, the function is successful when using this formula: =IMPORTHTML("http://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml","table",2) ...but when using Zoho Docs, selecting "link external data," and using this URL: http://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml ...the message returned
How can I store an old value as comment using VBA?
Hi, I am trying to make an excel spreadsheet which will retain the value of the cell as comment when new values are inputted. I know on excel this is possible and I found the following off the internet. Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'copy previous value to another sheet Sheet2.Range(Target.Address) = Target End Sub Private Sub Worksheet_Change(ByVal Target As Range) '//clearing more than one cell causes an error On Error Resume
Spreadsheet disappeared after marked as favorite.
Hello Zoho, I just recently starting using a Zoho spreadsheet to keep track of some information. As I uploaded different files I wanted to make sure I could always find this spreadsheet so I marked it as a favorite. After that the spreadsheet dissapeared. I can't find it in any of my folders or the trash. Do you know what happened to it and how I can get it back? Thank you.
Formulas don't import properly from excel .xlsx
I imported my Excel file and when I try to use it many of the formulas aren't working. Is there an ideal format that I should first save my Excel file in so it imports formulas properly? Please help.
Sorting numbers and letters in columns
When I try to sort combination letter/numbers, like S1, S2,S3,S4,S5,S6,S7,S8,S9,S10,S11,S12, anything above S9 will be sorted following S1,, like this: S1,S10,S11,S12,S2,S3,S4,S5,S6,S7,S8,S9, I have tried everything I can think of like using "S01" instead of "S1", etc. How do I fix this? Thanks.
Sluggish performance when sorting large column
Hi, I have an embedded spreadsheet on my website and one sheet has quite a long column of data - about 700 rows and counting daily. When trying to sort or filter this data on the embedded version, it simply refuses to respond. The column or selection stays in green but no matter how long it is left to do it's working, nothing happens. As the data contained on the spreadsheet is intended for visitors to do exactly this and is a main reason why they come to my website, this is very frustrating. Especially
How do I read multiple Zoho Spreadsheets, which are different files in Zoho Docs?
I have 3 spreadsheets where I need to read the data into one spreadsheet. How do I do this?
Can I set a spreadsheet so that only some users can view/edit certain worksheets within that spreadsheet?
EOM
Excel containing 1,00,000 rows with 200 columns is not opening in ZOHO Spreadsheet.
I have tried to open local excel file with 1,00,000 rows and 200 columns in ZOHO Sheets, which is not opening. Is there any possible way to open this in ZOHO Sheets?
??? where the cell is empty in the formula
Hi, I have been using Zoho spreadsheet for a while.In most of the cell I found sign of "????" in which the cell are empty but the formula is there whose results is zero. Why this so ??
Why can't i select a single cell? is this a bug?
Hi, When i type a formula, like in any spreadsheet editor, i can select another cell with mouse pointer. At this point, i expect the select cell (only) to be added to my formula, but instead of that, i get a bloc of 4 cells, that need to be manually adjusted to 1 cell. 1) why..? Why would you do that? 2) is this a bug? if no, then please answer question number 1. :) 3) Is there a way to disable this ? Please tell me it's a bug or it can be disabled...
Conditional formatting not gets ported when downloading zoho sheet to PC
Hi Team, While downloading a zoho sheet as Xlsx file the conditional formatting in the sheet is not getting downloaded in the file. It will be a good ad if it could be fixed. Thanks! Raaj
Problem with: "Your edit is not applied to the document. Please try again later."
Whenever I try to edit my spreadsheet called "brojila", Zoho spreadsheets says "Your edit is not applied to the document. Please try again later." It has been saying that for couple of days. Any help is appreciated. Thanks, Davor
Get set for Icon Sets.
Conditional Formatting in Zoho Sheet has become more exciting with the addition of Icon Sets. Represent a series of data with certain intervals using colorful icons. They are available in sets of two to five icons making them flexible with your data. How to use it. Icon Sets is placed under the Conditional Formatting menu tab. You can use a set containing two icons for data with TRUE/FALSE or similar conditions, three or more icons to see the change in data with many
Unable merge cell
I fisrt time ZOHO office speadsheet. i have problem on merge cell at my pc. i unable to use merge cell icon. The merge cell icon is not active... is my pc need to update? PC Specification Windwos 10 pro Intel Core 2 Dou CPU E7500 @2.93Ghz Installed Memory = 2 GB System type = 32 - bit Operating system
2 Spreadsheets Disappeared from Shared Folder
2 weeks ago one spreadsheet disappeared from my shared table Yesterday this happen again with another shared spreadsheet Each time this happen after Server Error which was something like "We are sorry but there is current problem with the server" And after refresh the spreadsheet was gone. Already checked Trash but isn't there. Can you help me, please? These spreadsheets are very important and i don't know how they just disappeared from my files. Thank you in advance.
Write in a cell of a locked spreadsheet Using VBA code
Hi. How can I write in a cell of a spreadsheet that is blocked? I mean: I need to collect information in a spreadsheet of an user and through a macro (button) this information is sent to the spreadsheet that is blocked for that user. The user can not write directly to the blocked spreadsheet, but he can enter in another spreadsheet where he enters information. Can this be possible? for example: There are three spreadsheets: Sheet 1, Sheet 2 and Sheet 3. Sheet 1 is a spreadsheet locked and no one
How tot color a block of cells with a condtional format
I would like te automatical color en block of cells (for instance B5 to D8) when in one of the cells a name apears. I have tried tot celect the block an formulate the conditi0on but a best one cells colors. What is the right formula or is in not possible in Zoho spreadsheet? I have tried text contains end trhe formula´s =$B$5="dave" and =$B$5=dave
Indirect() function not working
H, I had the following function in Excel INDIRECT("'" & $A4 & "'!" & C$2) when imported to zoho, I get an error, event though, apparently - indirect() exists - what is Inside the parenthesis works and gives " Act 1_1!C26" (tab & reference I want to get the content of..) Can you help me? Thanks Loïc
Finding a value in a worksheet via VBA
Hi, I'm trying to find a string (ex. "Smith, Joe") in a column ("A") in a sheet. First, it appears that Match is the function I should use, is this correct? If so, I cannot get it to work. Here is the code dim x as long msgbox (x) x = worksheetfunction.MATCH("Rabbit", WorkSheet("KeithQuoteData").Range("A1:A50"), 0) I'd appreciate any help with the Match function or a better way to search for a string and return its location. Thanks, Dennis
Dialog Box
Hi there, I'm trying to add a dialog box with vba to confirm that a certain action is about to happen and it just produce me a regular message box. The code: If MsgBox("Delete this Row?", vbYesNo, "Confirm") = vbYes Then Thoughts? Thanks, O-Ren
Adding more color and category to Charts.
Charts are the most effective way to represent data inside a spreadsheet. Zoho Sheet is constantly working on improving this marvelous tool of data visualization. Let's see what the current Chart update has in store for you. 1. Colors to make charts with elegance. Color Schemes Default colors can make your charts look monotonous. Hand-picking colors for each segment of a pie or funnel can also be tiring. Choose from the four sets of color schemes, or from the various other monochromatic shades. Already
Workbook_SheetChange is not working
Is there a reason for that? Thanks O-Ren
How to connect or link one workbook to data that is stored in another workbook?
How? Thanks, Oren
IMAGE(URL) Function on Spreadsheets
Hello ZOHO Team, I see that the IMAGE / IMAGE(Url) function is available now on Spreadsheets, I searched on Zoho's forums/topics with no results about this new feature from other users. How can I make it work? I already tried the following ways with no luck: =IMAGE(http://mysite.com/image.gif) =IMAGE('http://mysite.com/image.gif') =IMAGE("http://mysite.com/image.gif") All of the above functions just returns a !NAME# This IMAGE function requires most of all my imported spreadsheets To make World
Next Page