• transferring data from iSeries to Excel 2007

    Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows?

    Popers40 pointsBadges:
  • Excel 2007 charts

    I have a macro that runs when a cell is updated by a PLC. When this cell changes its value I insert a cell into a column and copy data from another cell and paste it into that new inserted cell. My problem is that my chart that is associated with the data where the cell is inserted dissapears. I...

    JimGlover5 pointsBadges:
  • Adding standard text to multiple cells in Excel 2007

    Hi, I have a list of about 800 products that I sell ( flags). Most of the flags are 150cm x 90cm in size and I would like to add this text to a chosen amount of cells for example: Grenada 150cm x 90cm Marshall-Islands Maurutania Palau Rhodesia Salomon Islands Trinidad und Tobago West Sahara Is it...

    Wereldvlaggen5 pointsBadges:
  • Creating a CSV file to FTP

    I just loaded Office 2007 and created a csv file which then was FTP'ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?

    Superiorsys15 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • Menu Driven Macros

    I have a database within Excel 2007. There are quite a few macros in it. I want others to be able to use the database and certain macros, but I want the options to be in a menu type layout not on the bar. I know this has to be possible, but I don't even know what it would be called to look it up....

    Cindyhale5 pointsBadges:
  • Excel 2003 to 2007 Link Issue

    We purhcased a new pc and it came with excel 2007. After moving our documents (excel 2003) we were no longer received the LINK update request. The only way our linked documents work is if we open each one, then open our document to be updated. Is there something we need to change? We would like it...

    SWMPC5 pointsBadges:
  • file format or extension invalid

    after using Excel 2007 for several months with no problem, I had to reformat and reload windows xp professional. then I installed Excel 2007 and now I can't open the xlsx files created by Excel 2007. I get the error in the above title box. Any help will be welcomed. Gervis.

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

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