• 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.

    shivasanjay2,510 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:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 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?

    YEMEN40 pointsBadges:
  • Parameterized Query Syntax

    Thank you Mr Hatmaker for sharing the "Parameterized Query with excel." I have watched the videos on youtube (beyond excel) describing the function and I have a few questions.1-I am looking for the syntax for "contains". I am searching for the syntax to place in the criteria field that would return...

    YulData5 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