• 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:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 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:
  • Forgot password on Excel

    In LAN environment, is there any way to find out forgot password that I set for excel spreadsheet?

    Eogy60 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:
  • Problem with AS/400 data transfer to Excel

    I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...

    JDK55 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following