• Forms in Excel 2003

    I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when a title is selected it...

    Mccuistionm5 pointsBadges:
  • email macro

    create amacro to send an email with Excelattachment

    Jraleccolin995 pointsBadges:
  • Pivot Table Dimensions (Not all are showing in the drop down)

    I have created a Pivot Table with 5 different columns in the Page area.  Not all of the values in the raw data are appearing in the dropdowns.  I need to see all of the dropdowns for each of the 5 different columns.  Why is this only showing a partial dataset?

    Jzgraham20 pointsBadges:
  • 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

    C1915 pointsBadges:
  • How do I read in the comma delimited files by SAS

    How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed "sheet 1" and second for the sheet tabbed "sheet 2"? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read into the SAS program

    Mimi1111115 pointsBadges:
  • Linked Workbooks return #VALUE error until linked workbooks are opened

    I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I'd really like to be able to open just one workbook at a time. Is there some setting in Excel 2007...

    Blubudda15 pointsBadges:
  • 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...

    Patcoad30 pointsBadges:
  • 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

    Doodoo5 pointsBadges:
  • SQL Server 2005 Legacy DTS fails when run as a job

    When the DTS is run from SQL Server Management Studio within the Legacy Data Transformation Services the log shows Executed By: sqlagent

    Ftornoe40 pointsBadges:
  • 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 font...

    HENRYj5 pointsBadges:
  • 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 stored procedure...

    SwapnilD25 pointsBadges:
  • How can I use a variable in my macro to import data from as-400 to excel?

    I import data from our as-400 to an excel spreadsheet to do further analysis.  One of my criteria is the customer number and that is what I would like to be a variable. Hence under the vba that retrieve the info, that criteria now read like this   "WHERE (ORDDET01.CUSN='3559')" When i tried to...

    Yves69520 pointsBadges:
  • 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...

    Ricca100 pointsBadges:
  • Access denied message when trying to save on network

    Hi all I have Server 2003 operating system om server.and officeXp with Office2007 on desktop when I work some EXCEL work on Desktop and treid to save on server it give me "Acces denied" Is Anybody Have any sloustion for thant.pls help me to reslove the issue.thanks in advance.

    922657968770 pointsBadges:
  • Outlook 2003: Export PST Emails To Excel

    When I use the "File > Import & Export" command from Outlook 2003, I have mixed results. I keep my emails in sub-folders off one of several PST files that I use regularly, in the "All Mail Folders" side-panel. I broke up the larger folders into smaller ones in case there was a size limitation. I...

    CaliforniaJerry5 pointsBadges:
  • Add in option to transfer from Iseries to excel2007

    I cannot find where to add in the Iseries transfer from or to the Iseries in Excel 2007 running windows vista.

    Jpnick5 pointsBadges:
  • Is it possible to export gantt chart view to excel 2007 in MOSS 2007?

    Hello All,               Is it possible to export gantt chart view to excel 2007 in MOSS 2007?              Now i am trying to export gantt chart view but i am getting only columns in excel sheet. my requirement is i want gantt chart view with list columns in excel sheet....

    NASE5 pointsBadges:
  • Download Spool file to Excel Format

    Hi Guys, Do you have any idea how to download the Spool Files(WRKSPLF with PRTF) to Microsoft Excel?   Thanks Mickey

    SoulReaper20 pointsBadges:
  • BOM Download To Excel For I&PD Exercise

    Are there easy directions for me to download from the SAP BOM's comprising 7000 lines to Excel for manipulation and pivoting of the data?

    NDIRISH5 pointsBadges:
  • How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?

    I am recreating a transfer form we currently have on paper into an Excel spreadsheet to have it electronically emailed. In the form I have a section that asks the user to choose a desired station to transfer to from a list of 3 stations with check boxes next to each station. I would like to have...

    2knowmore5 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