How to Convert VBA to Zoho Macro
Anyone how knows how to convert this? Thanks Sub ClearSummary() 'This macro clears the summary sheet for recording purposes' Sheets("Summary").Select Columns("H:IV").Select Selection.EntireColumn.Delete Sheets("Options").Select End Sub
Zoho and Huddle
Hi I use Huddle workspace and when I create a online spreadsheet from huddle i do not get the full features of Zoho WHY? Can I create a Zoho spreadsheet, save it and link it ot my huddle account? Cheers Mel
SaveAS XLS and HTML
I need to versions of the submited spreadsheet - an XLS and a HTML File. Is it possible to post both versions? Best regards, Andy
SEARCH function in spreadsheet
How do I search for text in the spreadsheet? Example, we have a job number register. We list the job number (1000) and the customer name (ABC Company). We need to be able to search for job numbers or customers in this spreadsheet. We have hundreds of jobs listed and it would be much faster to be able to find the names with a search. Please let me know asap. Thanks,
Help creating a spreadsheet
How do I get this sample brief report to work for me Zoho spreadsheet? Date: May 20, 2011 Buyer: John Rutger Item: Rado Automatic Price: $3,100.00 USD Commission 5%: $155.00 USD Fees: $135.00 USD Forwarded to Jennifer Jorgensen: $2,810.00 USD Reference Numbers for Jennifer Jorgensen: 645-333-8907
Where did all my Edits go??
https://public.sheet.zoho.com/public/rm2dance/cosmetics-industry-map "I saved to my account" so where is the most recent edits??
row selection error
my spread sheet is selecting the row two rows below my selection point. How can I fix this? Sapoty
Unknown function: Goto
I imported an excel file with macros in it. I believe that Zoho supports macros and as i was trying to assign a macro to a button with the macro coming from the excel file i upload it does not execute and says that Unknown Function: Goto. How can i resolve this? Does zoho support goto or it has another function for it? thank you. Here's the link: http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3
Goto Function
I have this excel sheet imported from microsoft 97-2003. It has macros in it and the buttons have been removed upon importation. So i made button(base-titles) and was trying to assign the imported macro (Gototitles). But i received this error. Unknown function: Goto here's the link to the zoho sheet:http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3 Thank you for your help.
unable to view the shared sheets in office plugin
Dear sir, I found this is very intresting tool for online geeks.But you can make this still more interesting by adding few more options i sent in previous mails. this time I got with one more requirement. I shared the excel sheet with Avinash ( my close fiend) in zoho online sheets. I was surprised that avinash was not able to open the sheet with zoho office plugin. I worked out and found that shared excel sheets are not viewable with office plugin. Aviniash found out something in zoho that is create
Sorting problems!
Very simple sheet, no formulas. First row labels (DATE, NAME, ETC) which I've "set as text" so it won't sort along with the data. I only sort by column A (DATE), I select the column, right click sort descending, I'm SURE to answer OKAY to "expand selection?", and yet.... my dates have gotten hopelessly fucked up. Sorted without the rest of the data in rows. Or, sometimes the column just WON'T sort-- data seems frozen. Only been using this for about a week, I'm afraid to keep using it for fear of
#NAME?
I've been editing this spreadsheet i imported from excel 97-2003. I changed a value of a cell and it keeps coming back to #NAME? what does this mean thanks. Need reply asap.
font color and background color
we cannot change the font or background color-- it's not allowing us to select.... we're using from China, Guangzhou?
Allowing Shared Users to Export Workbooks with Hidden Sheets
I've read through the blogs and found out that once you hide at least one sheet from a shared user, they no longer have access to the export functionality to save a local copy of the sheet. Is this correct? Is there anyway to override this and still allow users to export the workbook even though there are hidden sheets (without having to set the hidden sheets to Read-Only)? If not, is there any plan to perhaps allow the ability to export the workbooks and not include the invisible sheets? (i
Wrap text button deleting data
Sometimes when I hit the wrap text button after I've entered a long(er) list, my data disappears. I can't retrieve it with the back button - it's just gone. This is becoming frustrating. Am I using the button correctly? Mostly it works fine - the problem seems to occur when I've entered more than three items. Please help.
Format issues with downloaded public sheet
I would like to download/import a public sheet into Excel, however when I do it places all the information into one column. I would like the Excel sheet to stay the same format as I see on the website. So I don't have to spend tons of time formatting data. I have the link of the sheet (for example: http://public.sheet.zoho.com/sheetview?do). I have installed the latest plugin into my computer and am using FireFox 3.2 Please help. I have tried everything.
Link External Data
'Link External Data' allows you to periodically sync up the data in your spreadsheet with data available on the web in the form of CSV files, HTML web pages (tables) and RSS feeds. This is quite powerful if you want to make use of live data in your spreadsheet. Learn more about this feature from the blog posts we wrote as it evolved: blogs.zoho.com/sheet/link-external-data-comments-and-more blogs.zoho.com/sheet/sync-up-remote-data blogs.zoho.com/sheet/rss-feeds-into-your-zoho-sheet-plus-new-charts
IE8 Script Warning "Stop running this script?" during Macro Code execution
I am seeing a prompt in IE8 while executing a macro for a ZOHO Sheet. The prompt is as follows: "Stop running this script?" "A script on this page is causing Internet Explorer to run slowly. If it continues to run, your computer might become unresponsive." An example of the code causing this is pasted below: Sheets("Sheet1").Cells(3,2) = 1 Sheets("Sheet1").Cells(3,3) = 2 Sheets("Sheet1").Cells(3,4) = 3 Sheets("Sheet1").Cells(3,5) = 4 Sheets("Sheet1").Cells(3,6) = 5 Sheets("Sheet1").Cells(3,7)
sheetについて
オートフィルタの機能を付けてください。
セルの結合について
セルの結合、現在は横にしか出来ません。これではGoogleスプレッドシートと変わりありません。 セルの縦結合が出来る様にして下さい。 バージョンアップしたら使います。
Upload and Replace existing file?
Hello, I am working on my Excell sheet on my desktop and I upload it then here on Zoho but every time I upload I get a different file. How can I upload and replace the existing file on my Zoho? Thanks in advance.
uploading complete folder
how can i upload complete folder. if i edit it online, do it leaves any traces to the hard disc on my computer or any other place
Auto-Sorting
I love the webdata auto updating feature, but there is 1 part that I still have to manually do -- sorting. I have the webdata set to get me a list of numbers that change continually. It is a scoresheet so I like to have it sorted so the highest numbers are on top. It's not a huge deal to manually update it, I have been doing it that way for many months now. Just figured I might as well suggest it here and see what happens.
Creating an audio alert in Sheet
Is there a way to create an audio alert in Sheet?
Copy a zoho spreadsheet
Hi, I created a zoho spreadseet and i want to make a duplicate of that file. But zoho doesn't allow me to make a copy of that file. How can I make a copy of the file so the new file contains all the formatting and formulae of the original file?
auto save each field imediatly when is eneter in Survey
i have a survey with 8 pages and a lot of questione i need a solution to save each field when is enter by the operator
Is it possible to track what exactly was changed in a spreadsheet?
I am looking for a solution that provides me with general project management tools as well as an online spreadsheet that allows us to create and edit different information customised for our project. We've previously had problems with different people changing different cells in "normal" Excel with-out other people realising what was changed and who changed it. Hence we need to see when and who has changed the spreadsheet as well as who exacly changed it. In Zoho sheets I discovered the functionality
Monthly Exp Report
Monthly Exp Report June + July 2011
New in Zoho Sheet: Image support in Export and in Remote API
We have been supporting images in spreadsheets since Sep 2007. However, when you export the spreadsheet from Zoho, the images were not retained in the exported spreadsheets. We are glad to announce that we now retain the images when you export your Zoho spreadsheets. Remote API users will also be able to view and insert images to the spreadsheets opened using our Remote API. Images are also now supported in the spreadsheets uploaded directly to Zoho Docs. The 'View in Zoho Sheet' functionality available
Linking external data -- Please provide valid dataurl.
I do have a valid data url. It was linking external fine using this url until I decided to make a change. It lets you go through the entire wizard. Provide data (HTML with URL) select data (the tables appear fine with the correct data and let you select the ones you want) select location (no issue) schedule (now or schedule both have issues) When you select DONE I get the error 'Please provide a valid dataurl.' I never use to receive this error for this same URL. Here is the URL. Again,
Zoho Sheet Crashing Too Often Today
Dear zSheet Team, Today I am seeing to much of the message as in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Broken Grammar in Zoho Sheet
Dear zSheet Team, One of the recent error messages that I encountered with Zoho Sheet was: The server has encountered a problem. We are sorry! We recommend that you copy the data that you entered till now, paste it elsewhere and then create a new document and try again The second line seems to be too much fragmented and/or using the 'and' in a way bit not-so-desirable way. Can you rephrase and correct the same please? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Unable to copy the error message
Dear zSheet Team, This is a related issue to http://help.zoho.com/portal/en/community/topic/zoho-sheet-crashing-too-often-today. The error message "The server has encountered a problem. We are sorry. We recommend that you copy the data that you entered till now, paste it elsewhere and then create a new document and try again". does not seem to be copy-able. It looked like you have overriden clipboard functionality for the sheet. But can you also provide a diagnostic copy for the user to copy and
Can buttons be cloned or copied to another sheet within the same workbook?
Can buttons be cloned or copied to another sheet within the same workbook?
Use REPT() to draw in-cell bar charts / sparklines
The REPT() function is used to repeat a text, 'n' number of times. This can be used in interesting ways. For example, you can use this function to draw a bar chart within a cell. Here is a sample spreadsheet which uses the REPT() function for in-cell charts. This spreadsheet holds the statistics of previous Wimbledon championship winners by Country. The range B3:B16 is named 'gentscount' and the range F3:F13 is named 'ladiescount'. Cell D2 is named 'maxbars' and it refers to the maximum width of
How can I create macros to shift cells in each direction?
I am using the code below: Public Sub ShiftCellsToDown() Selection.Insert shift:=xlDown End Sub Public Sub ShiftCellsToUp() Selection.Insert shift:=xlUp End Sub Public Sub ShiftCellsToRight() Selection.Insert shift:=xlShiftToRight End Sub Public Sub ShiftCellsToLeft() Selection.Insert shift:=xlShiftToLeft End Sub However, when I run these macros, only the shift to right works.
How can I display the cell contents from another sheet using sheet index rather than sheet name?
I have a workbook that it is every expanding and the name of the worksheets change. However I always want to display information on the first worksheet that is pulled from the 4th worksheet, despite the 4th sheet name changes.
Excel formula to Zoho formula
Hmmf - just finished writing this - tried to add a Google doc and it crashed the page and now I'm having to start again. Anyway, I'm new to Zoho, and I'm trying to use Zoho to create an HTML or iframe version of an excel spreadsheet I've made which I then plan to paste in a Wiki page in Moodle. It's so my students can add their own grades to their own grade sheet - and automatically get the correct overall grade shown. Once up and running I'd like students to be able to add predicted grades and also
Bookmark your spreadsheet
Here is how you can bookmark your spreadsheet. This could be useful when you want to open a spreadsheet by default as soon as you sign in or to create bookmarks for several of your spreadsheets. Open the sidebar using File -> Open (Ctrl+O) or the sidebar handle on the left Right click on your file listed under My Sheets. You will be presented with the browser's contextual menu. To bookmark a file: On IE, select 'Add to Favorites...' On Firefox, select 'Bookmark This Link' To copy the link to the
Default file in Zoho Sheet
Is there some way to set one file as the default sheet in Zoho Sheet, rather than it opening on a new workbook everytime?
Next Page