• Problems with refreshing Access data that has been imported to Excel

    Hi, I keep getting error :you attempted to open a database that is already opened exclusively by user "xxxx" on machine "xxx". When I look there is a duplicate database name with the .dlb extension. This lock seems to be on all day? at the end of the day my excel works perfectly(when the .dlb is...

    barbaraw5 pointsBadges:
  • How do I open two separate instances?

    How do I open two separate instances of Excel; using two monitors, how can you put different spreadsheets on each monitor?

    20650suewriter5 pointsBadges:
  • excel password recovery

    i lost my excel password, can you track?

    Stalinthen20 pointsBadges:
  • Password remover for Excel 2007

    I have forgotten my password for my imp Excel sheet. How would I recover that Excel sheet now?

    Gvk5 pointsBadges:
  • Microsoft Excel formula: Sum the column of times

    I want to know the excel formula to sum the column of times (in Hr:mm) format. for e.g. if times are 10.20, 10.10, 10.25 and 2.10 it should result as 33.05 i.e total no. of hrs and minutes.

    shivasanjay3,195 pointsBadges:
  • Downloading from AS/400 to Excel

    I have just being informed by a senior employee that it is wrong to download from AS/400 to Excel, that it gives the staff the opportunity to alter data. Please help with answers that I can use to table my case for either for or against. Reference please

    Ebejale5 pointsBadges:
  • How to open .db files with Excel

    Hi, how to config Excel to allow opening of .db files?

    cfs0105 pointsBadges:
  • Excel Spreadsheet to i5 Physical File

    What's the best way to upload an Excel Spreadsheet to the i5? I've been trying to use XLPARSE2 but have experienced a lot of problems with hung up jobs and such. At first, I thought it was authority. But, that's not the case. Currently running V6R1.Thanks, Dave

    thedaveeffect10 pointsBadges:
  • Retrieving missing Excel data

    I had an excel file with 10 worksheets on it. I opened the file yesterday and found the whole 10 worksheets missing from the file. What could have caused it and is there a way to retrieve this data back to the file?

    Tess695 pointsBadges:
  • Running display program using macro and input from spreadsheet

    Is there a way to create a macro (either from the iSeries or Excel) to copy/paste data from a spreadsheet into an iSeries screen and then invoke keystokes to perform an action within the interactive program?

    KevinCmyrgroup15 pointsBadges:
  • QSYSPRT

    Hi , A program generated two reports.There is a job that runs every monday , and these report are generated every week.They are copying the data in the report to a work file in Qtemp by the command CPYSPLF .Then they copy the records from work file to Qsysprt by CPYF. My queries are , is this...

    Shobi40 pointsBadges:
  • Excel file for big data analytics

    Can you please provide me with the Excel file sample for big data analytics with real world examples.

    khannamoney5 pointsBadges:
  • Business Objects 12.1 and Office 2010 compatibility

    How can I determine if BO 12.1.0 is compatible with Excel 2010?

    vballkitty5 pointsBadges:
  • Download data from iSeries to Excel

    How do I download data from iSeries to Excel?

    lr538615 pointsBadges:
  • Pull data from AS/400 table to Excel

    I need to pull data from a AS/400 table to Excel, and need to create a Micro for this. I am not aware of Excel Micros that much. Can I get some help?

    Aundhekar5 pointsBadges:
  • How do I get a macro to move between workbooks?

    I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4, 5.......

    Bondsmith5 pointsBadges:
  • DBF file formatting from excel to dBASE file in openoffice

    I am trying to save an excel file opened in openoffice as a dbf file. However when I try to "saveas dbf" a text box opens that says "this document may contain formatting or content that cannot be saved in the dBASE file format". I was wondering if anyone can help me with how it should be formatted...

    kimannep10 pointsBadges:
  • Export Arabic data from AS/400 to Excel

    How can I export Arabic data from AS/400 to Excel?

    YEMEN50 pointsBadges:
  • Export Arabic data from AS/400 folder to Excel

    How to export data from AS/400 folder containing Arabic data in to Excel

    Jaipalsingh5 pointsBadges:
  • We are trying to make database of membership

    We're looking to create a database for our membership (particularly searching for an Excel sheet).

    jagdishchandrajoshi5 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