Excel Question
Can you repeat the ‘LESS’ command by pressing CTRL + R?

Answer Question   |  September 17, 2012  3:49 AM
Microsoft Excel, Microsoft Excel commands

Excel x-axis labels
I have tried unsuccessfully to create labels such as Aug 11, Sept 11 under the x-axix. Would appreciate any help.

Answer Question   |  September 11, 2012  11:03 PM
Microsoft Excel, Microsoft Excel labels

CVTPFXLS
Hi people, I need some help with formatting Excel spreadsheets within the IFS. My program currently prepares a physical file on the i-series and uses the CVTPFXLS command to create a Excel sheet. However, this sheet is pretty bland and I wish to add some formatting before the user gets it. The CVTPFXLS command does [...]

Answer Question   |  September 6, 2012  11:53 PM
CVTPFXLS, Microsoft Excel, Microsoft Excel spreadsheet

SQL table connectivity via odc
Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

Answer Question   |  August 30, 2012  2:18 PM
Microsoft Excel, Microsoft odc, SQL Database

Outlook email
Can I export my daily mailbox into an Excel spreadsheet or table?

Answer Question   |  August 23, 2012  3:59 PM
Microsoft Excel, Microsoft Outlook

Opening files
How do I get excel and word to open files without giving me the “read only” screen and having to click “notify” and wait? In the 2007 version, they would just open and 2010 takes so much longer because of this “read only” issue. How do I take that off so they just open?

Answer Question   |  August 23, 2012  8:07 PM
Microsoft Excel, Microsoft Office 2010, Microsoft Word

Excel Quickbooks Update Report
I was wondering what the Quickbooks Update Report in Excel does? I was going to try it but I am on a work computer and was afraid to try it without knowing what it does first.

Answer Question   |  July 18, 2012  1:15 PM
Microsoft Excel, QuickBooks

I want to play one of two wav files
I want to play one of two wav files when cell D11 value changed from Right to Wrong. What I have works perfectly for the value “Right”. But I don’t know how to change the code to play a wav for “Wrong”. I tried adding a second modual but that did not work. Sheet 1 [...]

Answer Question   |  June 21, 2012  5:03 AM
Microsoft Excel, microsoft excel functions

Numbers not registering in cell
I am trying to enter data (money totals) in an existing spreadsheet but when I enter the numbers and go to the next cell, no numbers but ##### instead.

Answer Question   |  June 16, 2012  6:21 PM
Microsoft Excel, Microsoft Excel spreadsheet

Is it possible to pop up an option box for user to select after checkbox is checked in Excel?
I would like to create a checkbox that once checked, pop up an option box woth 3 or 4 options to choose from. Based on the option choose, write different values into a cell. This is all in excel. I’m trying to prepare a timesheet with checkboxes for, e.g. Worked, Vacation, Sick, etc. Once the [...]

Answer Question   |  June 12, 2012  6:06 PM
Microsoft Excel, Microsoft Excel checkbox

Query from Oracle forms to Excel sheet
I had a matrix report made in oracle reports builder 11g. This report was called from a button in my form. now, I want to open an excel file when that button is pressed and show the data exactly in the format as it was shown previously in the report which was made using report [...]

Answer Question   |  May 25, 2012  6:04 AM
Microsoft Excel, Oracle 11g

R6V1 iseries Excel Addin to download data from AS400
On V6R1, how do I install the Excel Addin? The file that is in the shared folder for IBM does not have the cwbtfxla.xll like it did in R5.4

Answer Question   |  April 23, 2012  3:00 PM
AS/400, AS/400 Transfer, Microsoft Excel

error in grid xml: each dimension must be used once and only once
Hello, I’ve got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can’t get data. It shows #NAZEV? instead numbers and popups Error window ‘Hyperion Smartview for Office’ with message “Error in grid xml: each dimension must be used once and [...]

Answer Question   |  April 19, 2012  1:52 PM
Hyperion, Microsoft Excel, XML

convert report to excel without convater
Is it possible to convert a 10g generated report to excel without excel convater?  

Answer Question   |  April 19, 2012  9:13 AM
Microsoft Excel, Oracle 10g

Mail Merge
I have an excel document from my accounting software that lists donors by each donation they have given. When I mail merge them I want to print one document for each name- putting more than one donation on each page. Meaning, I need to get more than one row on each page when the name [...]

Answer Question   |  April 18, 2012  3:33 PM
Microsoft Excel, Microsoft Office, Windows 7

Adding an editable Excel spreadsheet to a Lotus Notes form
Hi, I’m totally new to Lotus Domino designer so please forgive me if this is an incredibly stupid question. I’m trying to add an editable spreadsheet to a form. It seems simple enough to add a spreadsheet attachment, however the attachment is not editable as the edit button is greyed out. I need to be [...]

Answer Question   |  May 10, 2012  9:22 AM
Lotus Notes 7, Lotus Notes 7.0.3, Microsoft Excel

Data transfer from excel to PF
How to transfer data from excel to PF if PF file has more the 300 Fields

Answer Question   |  April 12, 2012  10:30 AM
Microsoft Excel, PF file

How to Update Manager Field in Person Document
HI,   It will be great, if anyone answer my query. I am searching for agent/script which can be used to update/modify Manager Field in Person document using Excel sheet.

Answer Question   |  April 3, 2012  11:32 AM
Domino 8.5.3, Microsoft Excel

Upload data from excel to lotus notes in web
How to incorporate the facility to upload data from excel sheet to lotus notes web?

Answer Question   |  March 1, 2012  12:23 PM
Lotus Notes, Microsoft Excel

how to export to excel in web with heading row frozen
I want to export to excel report in lotus notes web, when report is available it should be showing Ist column as frozen, , ie. 1st row should not move when scroll bar moved to up and down.

Answer Question   |  February 29, 2012  2:10 PM
Lotus Notes, Lotus Script, Microsoft Excel