• JDBC/ODBC to Excel 2007 getting Exception

    Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

    Ansipar288315 pointsBadges:
  • To connect to Excel 2007 using free version API Java

    Presently we are using JavaExcel(JXL) API to read/write from the Excel 2003. Now we have to update to Excel 2007. The problem was JXL is not supporting for the Excel 2007. The other API's are in the Beta version. Guys any API's are there to support Excel 2007 ......

    Ansipar288315 pointsBadges:
  • Is there a macro to transfer a row of data from top to bottom row of range ??

    I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3,...

    Colwyn25 pointsBadges:
  • can anyone help with a formula for excel

    I have Excel 2007. There is one sheet with 2 columns of data. Column one has a series of numbers (e.g, 111,22,3333,etc). Column 2 has a series of terms (e.g, work,gym,home,etc). My problem is: whereas there is a series of numbers in column 1, the terms in column 2 only appear on the first row of...

    Colwyn25 pointsBadges:
  • Office 2007

    I have been having problems opening Excel documents. I have to use Internet Explorer to open these files. I have uninstalled office 2007 and re-installed it but it still hasnt made any difference. Any headway on this would really be helpful. Cheers.

    Yusufidris10 pointsBadges:
  • Data Label Help

    Hi I have made a stacked column graph comparing three types of presenters by percentage. I am trying to make a data label appear at the top of each three stacked bars that shows the total percentage for all three. I know I can do this by way of a text box but I would like the label to update...

    Hmarshall055 pointsBadges:
  • Having problem opening Excel files on Zip drive results

    A reader asks: Hi There. My question relates to opening a file in Excel 2007. Briefly, files were created on another computer using Excel 2007, put on zip drive which I have been able to open print, update, etc. previously. Now it allows me to open the files, however, no data appears on screen once...

    BrentSheets6,950 pointsBadges:
  • finding words within other words with an Excel macro

    column B has 2 letter words, the next 3 then 4 and so forth. I am looking to find the words in each column to the right to find all of theentrie that contain it and change the color of only the 2 or 3 or 4... letters in the new word for all words in each of the colomns to the right. Example: AA...

    Brayleen5 pointsBadges:
  • Excel 2007 data – sorting source workbook

    I want to create a link to data in a second workbook. My problem is when the source workbook is sorted, the links are misaligned. I don't think absolute/relative references are the issue. How do I create a link such that no matter where external reference in the source workbook workbook moves to,...

    Rschwieterman5 pointsBadges:
  • Excel data daily update linking between workbooks

    Using Excel, I am trying to link a column in one workbook to update daily to one cell in another workbook. The part I can not get to work is making the one cell automatically pull the current date value from the first workbook. I believe I need to use either an IF formula or a macro to tell the one...

    Twirlind55 pointsBadges:
  • Rusty and Need Help

    I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....

    Bluize20 pointsBadges:
  • Excel 2007 Freeze pane problem

    AOA SIR, I am using Office 2007. I have protected sheet which were created in office 2003. When ever we have open this proted Workbook In Excel 2007 the freeze pane option is disbaled. Please help me out to Solve the Above mention Issue. I Will thankfull to You.

    Mobilink115 pointsBadges:
  • CSV data into Excel 2007

    Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a ":"....

    SHAPOW45 pointsBadges:
  • MySAP to excel 2007

    We just upgraded to excel 2007. When I try to export a spreadsheet from MYSAP to Excel, the worksheet comes up blank and no information can be seen. Any help would be appreciated!

    Scrbayer335 pointsBadges:
  • Automate download from ALV grid to excel using VBA

    I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks

    VB Monkey5 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.

Following