client access for Iseries export
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?

Answer Question   |  April 16, 2010  8:27 PM
iSeries, Microsoft Excel

Excel Pivot Table
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

Answer Question   |  April 12, 2010  6:53 AM
Microsoft Excel, Pivot tables

Exporting data from SSIS to Excel
I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I [...]

Answer Question   |  April 8, 2010  3:18 PM
Excel functions, Microsoft Excel, SSIS

What formula is needed for this below in Excel?
What Excel Formula’s could i use? First # is starts with 1  back slash 2400.   2400 stays the same only first # changes. example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST] [tbody] [tr style="height: 12.75pt;" height="17"> [td class="xl66" style="height: 12.75pt; width: 65pt;" height="17" width="86">1/2400[/td] [/tr] [tr style="height: 12.75pt;" [...]

Answer Question   |  April 7, 2010  9:01 PM
Excel 2003, Excel 2007, Microsoft Excel

compare and merge workbook in Excel Program
salam! sir i am zia from pakistan i am parmenent user of office program but i still dont know how to compare two workgroups? thanks u wati for answer…

Answer Question   |  March 24, 2011  7:35 PM
Microsoft Excel

excel encryption
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.

Answer Question   |  March 31, 2010  10:22 AM
Encryption, Microsoft Excel

Transfer particular pieces of data from Excel into Word over a large number of documents
Thank you for coming and reading my question! I am trying to write a letter in Microsoft Word 2007 that will be personalized with the names and addresses of about one thousand donors to a non-profit organization. I have a spreadsheet containing everyone’s name and address in Microsoft Excel 2007, and would like to be [...]

Answer Question   |  March 5, 2010  7:12 PM
Excel 2007, Microsoft Excel, Microsoft Word, Word 2007

Converting Data in Excel to PF on DB2/400
Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

Answer Question   |  February 26, 2010  10:57 AM
Data in Excel To PF, DB2/400, Microsoft Excel, Physical Files

Need loop to cut rows that meet criteria and paste to another sheet.
I want a loop that will look at the first four words in column A and if they match then the entire row should be cut and pasted to another sheet.

Answer Question   |  March 3, 2010  9:55 PM
Excel 2003, Excel macros, Microsoft Excel, VBA, VBA/VB

One macro to systematically run F5 key on up to 20 other macros
I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination Ctrl+Shift+(?)

Answer Question   |  February 25, 2010  2:31 AM
Excel macros, Microsoft Excel

Re-linking data source in Word 2007
I have a bunch of word documents that are linked to an Excel spreadsheet (master sheet) for mail-merge reasons. Now all these documents are templates on a server. I need to Copy-Paste the entire folder (Including all documents and the Excel sheet) onto my computer before editing them. My problem is that when I Copy-Paste [...]

Answer Question   |  February 18, 2010  11:37 PM
Data Sources, Excel 2007, Mail merge, Microsoft Excel, Microsoft Word, Word 2007

The “TRUNC” Function in Excel
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 fault with Excel?

Answer Question   |  April 5, 2010  2:30 AM
Excel 2003, Excel functions, Microsoft Excel

how to input excel file to crystal report in C# .NET
How to input an excel file to crystal report and get a report in required format i.e as client requirement grapph,piechart or tables ? In c# .net

Answer Question   |  February 10, 2010  11:20 AM
.NET, C#, C# .NET, Crystal Reports, Microsoft Excel

vba loop help
i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1       x 2 3 4 5 6 [...]

Answer Question   |  February 19, 2010  4:14 PM
Excel 2003, Excel VBA, Microsoft Excel, VBA

AS400 Transfer to Excel with a Locked Cell
Hi everyone I hope someone can help me with this. I have an Excel template for a download for a group of users. The cell containing the formula was requested by management to be locked due to some of the users incorrectly removing the formula or leaving old data in cells outside the screen view [...]

Answer Question   |  February 4, 2010  7:19 PM
Excel 2000, Exporting AS/400 to Excel, Microsoft Excel

Oracle Forms to MS Excel
I have several reports which extract data via Oracle Forms into MS Excel. But Excel cuts off the input at row 999.  The Oracle Form uses the DDE.EXECUTE(ConvID) command.  Does anybody know if Excel has a limitation of the number of rows it will import via Oracle Forms?

Answer Question   |  January 12, 2010  4:22 AM
Microsoft Excel, Oracle Forms

Inputing greek symbol in concatenated text
I am trying to concatenate the contents of several cells (which contain alpha numeric data) into a text statement and and also concatenate the Greek letter “mu” representing micro to the end of the statement. When I do this it appears as m. It seems as if I need to be able to specify a symbol [...]

Answer Question   |  January 14, 2010  2:58 AM
Excel 2003, Microsoft Excel, Windows XP Professional

Create Excel file on web server by using SQL
How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I’m retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a [...]

Answer Question   |  January 13, 2010  12:02 PM
Microsoft Excel, SQL Server 2005, SQL Server stored procedures

db2 to excel
i was tryin to import from db2/400 into excel but when i did. the description came up in a different language…in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

Answer Question   |  February 1, 2010  10:38 AM
DB2/400, Exporting AS/400 to Excel, Microsoft Excel

CPYTOPCD as an XLS
I am using CPYTOPCD and emailing the resulting *.csv and *.txt files successfully. However, I am now trying to send the data as an XLS. Although the file is sent, the data does not appear in the different cells as I would expect, the whole string (although comma delimited) appears a whole string (ie. Dealer [...]

Answer Question   |  December 23, 2009  11:53 AM
CL Commands, CL programming, CPYTOPCD, File conversion tools, File formats, File Transfer Protocols, Microsoft Excel, XLS