Excel cell referencing across worksheets
In the past I used to be able to caculate a cell reference on another worksheet in the same spreadsheet and get the value(contents) and use it in the worksheet that was referencing out, but this feature seems to have disappeared. At present I am using Excel 2003. Any suggestions?

Answer Question   |  February 18, 2008  6:18 AM
Excel 2003, Microsoft Excel

Excel Functions
I am compiling a sales report that with all the sales figures of different branches in my region, these figures are then listed from the best performer to the worst performer in a separate spread sheet using the large function in excell my problem is how do I get the name of the stores to [...]

Answer Question   |  February 18, 2008  8:43 AM
Microsoft Excel

how to save crystal report in excel format ?
hi i wanna to save crystal reports as excel form so can anyone help me

Answer Question   |  February 22, 2008  7:19 PM
Crystal Reports, Microsoft Excel

Excel compute time
We have an Excel spreadsheet that volunteers use to document their time working. The time in an out is based on 12-hour time (am/pm). I would like a formula that would use the in and out time to compute number of hours worked. Anyone know how to do this?

Answer Question   |  February 2, 2011  12:51 AM
Microsoft Excel

One Cell to calc inputs from mult workbooks
Have a summary sheet and want it to calculate information from a standard daily form (seperate workbook) that gets saved as the days date, daily. Want summary sheet cell to continuously calc what is inputed on daily form even after it is saved as something else.

Answer Question   |  February 13, 2008  6:10 PM
Microsoft Excel, Microsoft Office, Workbooks

Range of one cell backcolor in excell 2003
Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance [...]

Answer Question   |  February 19, 2008  5:02 PM
Microsoft Excel, VBA

Automatic transfer of Data from AS/400 DDS Described file to Excel spreadsheet
Hi, Is there an easy way to automatically “refresh” the data in an excel spreadsheet from an AS/400 DDS Described Data file? I’d like the data to be collected whenever someone opens the spreadsheet. I can already get the data using a transfer request, but I have to start the request manually. I’ve tried making [...]

Answer Question   |  January 27, 2010  1:54 PM
AS/400, Lotus, Microsoft Excel

SSIS only 255 rows uploaded ?
Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view – [...]

Answer Question   |  February 22, 2008  7:53 PM
Microsoft Excel, SSIS

Pivot Tables – I need more than rudimentary calculations
Does anyone know of a site that exchanges calculation information for Pivot Tables???

Answer Question   |  April 4, 2008  3:23 PM
Microsoft Excel, PivotTable

formatting excel using lotusscript
I would like to know how can I draw borders on a cell in excel with lotusscript? I’ve goggled for sites that give excel exporting tutorial but none provides a detailed explanation. Any suggestions?

Answer Question   |  January 4, 2008  2:56 AM
Export, LotusScript, Microsoft Excel

Lotus Notes Import
I am using Lotus Notes 6.5 and I have an Excel spreadsheet that I have saved as a 123 (.wk4) file. In Lotus Notes I imported the file using File Import. I then used the following critera: Import as: Main Document Using form: To Do Defined by the WKS title: this is turned on WKS [...]

Answer Question   |  December 17, 2007  8:05 PM
Lotus Notes, Lotus Notes 6.x, Microsoft Excel

Vista and Office 2007
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.

Answer Question   |  June 4, 2012  7:25 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007

Error while running a form
Hi when running a form i am getting an error and my output is not been created and when i debug i gives me a clause that excel is running in the back end but there was no excel running

Answer Question   |  June 4, 2012  5:12 PM
Microsoft Excel, Microsoft Office

How do I activate specific worksheets when importing from Excel
I have a script in Lotus Notes that imports data from a excel spreadsheet. I want to be able to always activate a specfic sheet every time the script runs. Currently I am using this method and it directs to the last saved(active) sheet. Set xlsSheet = xlsWorkBook.ActiveSheet I tired this method but got a [...]

Answer Question   |  November 19, 2007  5:08 PM
Lotus Notes, Microsoft Excel, OLE objects

NUnit Test
How to create NUnit tests that will test Excel-AddIn.

Answer Question   |  October 25, 2007  1:58 PM
C, Microsoft Excel, NUnit

How do I run my report on excel worksheet?
I have a alv report and i need to run on my excel sheet ,How do I go about?

Answer Question   |  April 27, 2011  6:49 PM
ALV, Microsoft Excel, SAP