• I have an excel template and would like to allow the user to input their date in one of two ranges and have the other range calculated automatically based on a formula to use in each cell This means that the formula needs to be outside the cells in the two ranges as they are both used for date...

• Hi. On some different pc I have MS Office 2002 and BOE XI. After a couple of time (usually after a system update) something goes wrong. Example: I create a document on Excel, like a graph. I copy the graph on a Powerpoint sheet or a Word page, then when I try to modify the data with a double clik...

• Hi, I'm creating a sheet for the employees in my retail store. The spreadsheet has a column for the different items that I'm selling, and another column for the number of these items that I have in stock. Next to each of the item, I'd like to create a button. So here is my question: How do I assign...

• I have exported data via excel but I can't seem to get a certain column (data not numeric) across. I have displayed my database file and it is there but when I export it, that column is missing. What do I do?

• When I export a report to excel all columns export correctly except the sub report it makes it a new row. Any tips on how to fix this PLEASE!!!

• Sir I Using Excel Pivot Table I Create Calculated Filed Formula is If(((total Debit-total Credit)>0),(Total Debit-Total Credit),0) This Formula very perfect use But Pivot Table Grand Total show the zero (0) How Grand total sum run please tell me

• What to do when I cannot get Excel spreadsheet to link with WORD document to make mailing labels

• how to export visual basic6 to excel file

• I used the "trunc" function this way "=TRUNC((H41-(I41*25))/10,9)", where H41is "=(A41-INT(A41))*100" and I41 is "=TRUNC(H41/25)".Â  A41 is 346.95. With the Excel 2003 version on my computer, the result is 1.999999999; when, in fact, the result should be 2. What am I doing wrong?Â  Or is there a...

• I wish to encrypt and send excel spreadsheets to customers where they can modify some input data and calculate but not read formulars or change the spreadsheet. I want a form of security that is better that the standard microsoft encryption that cannot easily be broken by password crackers.

• Has anyone had problems importing spreadsheets created in Google Docs to Excel, or vice versa? I'm considering recommending the Google Docs tool to some of my colleagues who use Excel but am fearful the product may not be ready for prime time.

• We are developing an integrated application that will incorporate excel application, access databases and pda applications using visual basic 2005. Problem is whether to use web services to develop the project. This request for help was originally submitted to the Research Assistant on WhatIs.com.

• I see there is a Transfer Data to iSeries option but is there a way of making this run automatically daily? Can something be schedulled from iSeries to initiate that? I want to reduce user intervention so would prefer not forcing the user to daily execute the upload. Any suggestions? Thanks, Rod

• I use Excel 2007 to do a fairly large multidepartmental Financial forecast and results package. The file size is currently at 48,000 KB and will continue to grow. I have this file open along with others of its size at the same time during use. Frequently Excel will crash during an autosave, when...

• when I use a DTF to download directly to excel the order of my data changes. The PF is NOT keyed and I am NOT selecting any order on the DTF. It is intermitten. any suggestions?

• I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just...