• Can you show lotus notes table rows as rows in a view?

    I have a table with 5 columns. Each row as 5 fields. first row, Field A, Field B, Field C, etc second row, Field X, Field Y, Field Z, etc I need to be able to show the table rows as as rows in a view to export to excel. I have tried using a lot of formula language in column formulas and it is not...

    Penguins10 pointsBadges:
  • Data and Variables in SPSS from Excel spreadsheet

    have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable -...

    Terrymb310 pointsBadges:
  • extenda x550 series

    I am using Extenda X550 (1+5) and having a typical problem while working in excel like - some area gets selected automatically - copy paste does not work - cursor starts moving weirdly

    Jaideep Khanduja11,710 pointsBadges:
  • Excel data and variables in SPSS

    I have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable...

    Terrymb310 pointsBadges:
  • Displaying amount field in query 400.

    In query400, i created a report which will be downloaded to excel. If i download report, it is showing amount fields without decimal values. How to display amount fields with decimal fields using query400?  

    VJayashree185 pointsBadges:
  • Calculating Columns

    how do you create a formula using data tables calculate each divide each (3) quiz by 100 times .01 times 10%, each (2)test by 100 times .01 times 35% to get the final %

    Wandaj535 pointsBadges:
  • Automatic Publish web page when excel data changes

    I have 4 files created from scheduled jobs on the AS400. Each file automatically updates a worksheet in an excel spreadsheet. (sheet1 to sheet 4) On the 5th worksheet I have graphs based on the 4 sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the...

    Gerrib150 pointsBadges:
  • Excel .xla slow to save

    I have a custom toolbar saved as an .xla.  Works great.  It has always taken about 1 - 2 min. to save the .xla.  But about two weeks ago the save time increased significantly. It now takes over 12 mins. to save.  Any ideas.  I haven't added much in the last month.  Tried rebooting machine. ...

    Smf170 pointsBadges:
  • Excel Macro to password protect

    I have this spread sheet that I want to be able to protect from distrubution when given to one person. Is there a way of writing in a macro that will ask for a new password that is in a hidden list at the end of say 30 days and if not entered in the program will not be usable? I hope that my...

    Smarbada15 pointsBadges:
  • Send as excel received as pdf in Office 2003

    Hi, I have an employee who has a Windows 7 computer with office 2003. When she is sent an excel file, it comes through to her as pdf. We can't figure out why. Please help

    Kerrimac985 pointsBadges:
  • Crystal Reports file error: data may have been lost

    using CR7 xp sp 3 office sp 3 when I do a export from CR7 to excel I receive the following message file error data may have been lost

    Leeanne455 pointsBadges:
  • 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?

    Sumit0 pointsBadges:
  • Excel 2007 ‘Edit Links’ Command deleting information

    I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit...

    Hporiginal15 pointsBadges:
  • Macros in a drop down list

    How can I get macros into a data validation list so I can select a macro to run from that list.

    Excerlnovice15 pointsBadges:
  • Need help using excel to amend ibm reflections

    Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them. What I want to do, which I would do if it were two excel files, is update the database file by using a vlookup...

    Riotburn15 pointsBadges:
  • Microsoft Excel report generation from Oracle Forms 10g

    what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

    Pupun5 pointsBadges:
  • 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?

    XMac110 pointsBadges:
  • Reports to be pulled from iSeries

    Hi. I have a query regarding pulling the report from i series, am working on I series when i pull the report into txt format in notepad,when  i copy and paste it into excel it displays unwanted rows with blanks and some special characters and word like particulars would be splitted like parti cula...

    Ausboi095 pointsBadges:
  • Excel: Hyperlink to Lotus notes with message field populated

    Hello I have a spreadsheet which just has email addresses on it.  When I click on them they open a new email in Lotus Notes.  I want to know if there is a way to make it so that when I click on the hyperlink the message field is populated with a template letter which can be edited by the user...

    Hosteen5 pointsBadges:
  • Performance files to Excel

    I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks

    DudleyShaw15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.