• Opening a file from a program vs. from a folder

    We have a shared folder on our server where we store spreadsheets, documents, etc.  It uses Server 2003 Small Business.  If I search for a file using explorer and try to open it, there is usually a decent amount of lag before it opens.  If I open the program and search to open the file from...

    XENOPHON222,340 pointsBadges:
  • Can data on a second sheet be pulled up by a cell on sheet 1?

    Hi... I work in an Emergency Room, and I'm trying to set up either a formula or macro so that when I'm making the "Call List" for the day I can type out the doctor's name in the "A" column, and in the "C" column of the same row have the phone number for the office automatically populate into that...

    LeviG5 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:
  • 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:
  • Upload Spreadsheet to AS400 using Excel addin – creates graphic fields for alpha fields

    I am using the Excel addin to transfer excel files to our AS400.  The file does not exist on the AS400 and when the transfer runs, the field created for the alpha fields is 'Graphic' when I display the file field definitions.  I cannot read these fields in my RPG program - they are only text...

    PaulClemens25 pointsBadges:
  • Data transfer from AS400 to Excel 2007 Stops at 16,xxx rows

    I am using client server to access my AS400.  i downloaded and installed it within the last 6 months i have the excel add on installed and it seems to be working well on tables with less than 16,xxx rows.  1. can anyone help me find out if there is a more up to date add on for excel 2007? 2. My...

    Ringside35 pointsBadges:
  • How do I overcome the “Could not find installable ISAM. Excel 2007″ Error? Ex

    I got the "Could Not find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line. -- Web Application -- .Net 2.0 -- Testing using IIS 7.0 on Vista Ultimate -- Office 2007 Enterprise Installed on machine. Code works...

    Donnybrasco10 pointsBadges:
  • Run a Macro in Excel 2007 spreadsheet located on a file server

    When I run the macro located on the local drive it works, but when I put the document out on a shared file server I get an error. The server folder is in my trusted locations.

    njasche5 pointsBadges:
  • WebUtil client_ole2 commands in Oracle Forms 10g

    I want to attach a sheet from an excel 2007 datasource to a word 2007 mailmerge using webutil client_ole2 commands in oracle forms 10g

    Petitejean5 pointsBadges:
  • Separating dates into year, month and day componrents

    I have an excel file of some 80,000+ records, one of whose columns - C- is in date - YYYY/MM/DD form. I want to split off the date into separate columns of years and months. I've managed to split off the years by using the expression LEFT (C2,4) where C is the label of the column containing the...

    Rogerc5 pointsBadges:
  • File Transfer to iSeries from Excel 2007

    I am using the iSeries Client Access for V5R4, and trying to transfer an Excel 2007 (.xslx) file. There is no corresponding file type to choose from (only goes up to Excel 2003 (BIFF8). Is there any other way to do this using Client Access

    Badkarma40 pointsBadges:
  • Excel VBA – Cell value not being displayed

    when i display all the values there is a cell that dosnt display it's result,but when u put the mouse on it in the comment box it appears

    Skh805 pointsBadges:
  • Excel 2007 – How do I ignore zero %’s for a graph?

    Excel 2007 - How do I ignore zero %'s for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2. But then you will...

    Jreifenstein001185 pointsBadges:
  • Excel 2007 – How to find duplicate data and sort into a row

    I have two column. I would like to find the duplicate data and sort the int a row. Eg: Name Name2 Julie Jane Sally John Jack Paul Jane Sally The result: Name Name Julie Sally Sally Jack Jane Jane John Paul Pls help

    Miya30 pointsBadges:
  • Seperate emails from Excel File

    I need to send a 500 e-mails separately to different users depending on their name and e-mail address.

    Mfagabani5 pointsBadges:
  • vba recorder issue

    When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can't figure out why it will record...

    Lostinspace20005 pointsBadges:
  • Unable to view Excel 2007 workbook

    I have open a workbook, but unable to view it. When I attempt to reload, excel ppoup ststes already open. The workbook has macros. The VB editor shows them, therefore the file is open.

    Jhengineer5 pointsBadges:
  • Using a drop down window in Excel to look up a List .. The names shown are so small it is difficult to read them

    How can I get the Font larger in the drop down window in XL for say cells A1:A200

    Yoka25 pointsBadges:
  • Microsoft Excel 2007 charts

    I AM UNABLE TO USE CHART OPTION IN EXCEL 2007

    Jollybhupi5 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