• Upgrading from excel 2003 to 2007

    After upgrading our laptops from Office 2003 to Office 2007 somehow the permissions in the IFS have changed and certain groups can no longer save Excel documents with system i data. They get a "cannot save" message. Any idea where to look? Netserver etc.?

    Kbordner5 pointsBadges:
  • Can Windows Explorer ‘File Types’ settings be amended by Group Policy?

    To enable our reporting software to correctly export to Excel 2007 (WXP SP2 operating system) we need to change the following Windows Explorer 'File Types' setting: Open windows explorer and navigate to the XLS file type and enable the "browse in same window" option, see path: \Tools\Folder...

    Redtyke130 pointsBadges:
  • Excel 2007 Crashes

    I am using Excel 2007 working in a workbook that has forms for each census year. In the form I put the data for the family name that I am researching, these forms might be several hundred lines to several thousand lines each. Size of each census year may vary. There is quite a bit of formatting,...

    Mwellis15 pointsBadges:
  • Excel cell referencing

    What is absolute cell referencing and how is it beneficial in excel

    Xxrerexx10 pointsBadges:
  • Does Apache POI-XSSF support Excel 2007 runs under Java 1.4?

    Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.

    Ansipar288315 pointsBadges:
  • import data from excel 2007 to iseries

    how do you import data from excel 2007 to iseries

    JimC11285 pointsBadges:
  • excel 2007

    I am trying to use non-adjacent ranges to setup a clustered column with 3D visual effect option by pressing the ctrl key and selecting my ranges and every time I get the box saying one can't use the chart with information selected, what am I doing wrong?

    Lisa1005 pointsBadges:
  • Excel 2007 – formula or macro to show value from one cell next to a given reference

    Hope someone can help I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG - Sheet 1 has a cell with £500 in cell 3A The reference 1.01 is located in cell 3B...

    PeteAtGlasshead5 pointsBadges:
  • 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,925 pointsBadges:
  • Convert Number value in text string

    I am using Microsoft Excel 2007.I want automatic conversion of a number value into relative text string.It means if I have "687" into one cell, then it should be converted into "Six hundred and eighty seven" into next cell.Pl. guide me for this.

    Makkes5 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:
  • MS Office Excel 2007 cannot be open by MS Office Excel 2003 (even after installing compatibility pack)

    Cannot open the EXCEL file using MS Office EXCEL 2003 (after installing the Compatibility pack) that was saved by MS Office EXCEL 2007. The error message: This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click...

    Phlim35 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:

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