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
Hours Calculation
Hi, I'm trying to sum some hours on my spreadsheet, but every 24 hours I get back to zero. How can I solve this or at least go around of it?
Zoho Spreadsheet not opening
All of my spreadsheets keep on loading but doesn't show any data
File is lost after being online 9 years
Hello, I uploadd XLSX file about 9 years ago and it was working fine untill recently. Now it's completely empty and I can not download it in original format either.
Unable to export spreadsheet
I have several spreadsheets that will not export or download. I have tried restarting the browser, clearing the cache, even rebooting the computer. I also tried copying the spreadsheet nothing is working.
How to insert combo box in Worksheet ??????
How to insert combo box in Worksheet ?????? Anyone have idea about it Please, tell me it's argent
Can't find a function
Could I ask some assistance in figuring out some formulas to perform a couple of calculations I am attempting to perform? I cannot find anything in the help files. Scenario 1: Let's say that, for any given row, columns E through X all contain numeric values, except that one and only one contains text. How would I perform a calculation that finds that occurrence of text, or even the "first" (of one) occurrence of text in columns E through X, and set that cell's value equal to the text? Secondarily,
Working at the same time in shared spreadsheet
When sharing a spreadsheet, we cannot work on it at the same time. If we use filters and i have it opened with a filter selected whoever is working on it at the same time will see his screen the way I see it, with the filters I selected so he has to stop whatever he is doing until I finish using the filter... Any suggestions? am I doing something wrong?
CMD + Select in Sheets?
Hello, Is there any way to use the traditional CMD select function? Normally its like the Shift + select, but it does not include everythign in between - only what you are clicking on while holding command. (might be control for PC users) Thanks
zoho sheet stuck
I Need help. ZOHO sheets stuck on the loading screen. I've already deleted the system cache and cookies of my browser (google chrome) but it's still not opening.
[Zoho Docs] Charts are changed after exporting from Zoho Sheets
This is what my excel sheet charts look like in Zoho Docs, After exporting, it looks like this. Is there any way to fix this? Please help.
Want the conversion of MS Excel function to Zoho format
My current formula excel formula is : =COUNTIF(D8:AH8;"*"&AI$7&"*") Can you please help me convert this in format of Zoho Docs.
How to count events that match multiple criteria?
hi, i'm have a table with information about specific meals: sept 1 Chris Burger Sept 2 Jane Pizza Sept 2 Chris Pizza Sept 3 Jane Chicken Sept 4 Jane Burger Sept 5 Chris Burger etc. . . What I want to be able to do is count the number of instances that meet two criteria (person and meal), for example how many times did Chris eat a Burger, and I want to do this for every combination of people and meal. What I would do in Excel is make a table with names
How to generate a random number
Hi I'm interested in some way of generating a randon (pseudo random I guess) number. I think some spreadsheet programs have such a function but couldn't find anything in Zoho Sheet's function list. I guess if not there must be some formula to replicate the function... -- Cheers Mark
Macros disappeared from workbook
With the recent update to Zoho Docs it seems all macros have disappeared, at least from my workbooks. I've tried downloading older versions and opening them locally in MS Excel to retrieve the macros but have not had luck so far. Does anyone know of a solution to this problem?
Spreadsheet issue
An interesting problem. I keep a spreadsheet of books I assign for review, with columns for title, author, reviewer, etc. When I have to update a row, I search for title or author, etc. The find action will locate the information I'm searching for and highlight the cell, but the other cells in the row don't align correctly -- the Title row, for example, is highlighted, but the Author row, etc., are for a completely different title. It's very frustrating. Is there a fix for this? Thanks.
Next Page