• Merge fixed Excel columns into one file

    I have about 15 Microsoft Excel files with fixed columns. Usually, once a day, I have to merge them all into a master file. What's the best way to merge all of these files into one Excel file? Is there a VBA code to do this?

    ITKE1,060,150 pointsBadges:
  • Cannot unlock Microsoft Excel worksheet

    I tried to unlock a protected Microsoft Excel worksheet using the correct password but it keeps saying that's it not correct. Last night, I got into the worksheet with that password no problem. Any idea what's going on here.

    ITKE1,060,150 pointsBadges:
  • Data download to Excel 2010

    When using Excel's add-in to download data from a PF to excel, it brings only 65536 rows. Why not 1048576 rows as per the limit in excel? Do we need some PTF on IBMi? or a service pack for client server?

    mpasha5 pointsBadges:
  • Office 365: Link to another Microsoft Excel document in cell

    I'm using Microsoft Excel (Office 365) and I need to add a link (in a particular cell) to another Excel file. What's the best course to do that? I've tried a few times but it keeps launching Outlook because it's adding 'mailto' to the link.

    ITKE1,060,150 pointsBadges:
  • Convert Microsoft Excel image into PNG file

    I have this dynamic image that's in a Microsoft Excel file (.XLSM). Is there some macro that would create a .PNG file for this image? Or any other way would be helpful. Thanks!

    ITKE1,060,150 pointsBadges:
  • How to update multiple Microsoft Excel workbooks at the same time

    Does anyone know if there's a way to update multiple Microsoft Excel workbooks at the same time? Basically, I have one master workbook and two other secondary workbooks. So when I update the master workbook, the secondary ones are updated too. Thanks!

    ITKE1,060,150 pointsBadges:
  • Fixed height and width for Microsoft Excel cells

    For Microsoft Excel (I believe I'm on 2013), I need all the cells to have the same height and width. For example: 3 CM by 3 CM. How can I do it?

    ITKE1,060,150 pointsBadges:
  • Open .MDB file in Excel?

    Can you convert MDB files for use in Excel?

    Austida25 pointsBadges:
  • Remove or hide Microsoft Excel 2007 Filter button

    Hello, I'm currently using Microsoft Excel 2007. I'm not going to use the Filter feature so I was wondering if I could either remove / hide the button. What's the best way to do that? Thank you.

    ITKE1,060,150 pointsBadges:
  • Microsoft Excel filter by color option disappeared

    I have a bunch of filters associated to several rows in a Microsoft Excel worksheet. But I noticed that my 'filter by color' option is completely gone. What happened here?

    ITKE1,060,150 pointsBadges:
  • Why does Microsoft Excel 2016 keep shutting down when trying to print?

    Over my network, Microsoft Excel 2016 keeps restarting when I'm trying to print. It's on a Sharp printer. Microsoft Word is working just fine. I tried to run a repair on Microsoft Office but everything was fine. I'm not getting an error message either - just shuts down whenever I'm printing.

    ITKE1,060,150 pointsBadges:
  • How to select all cells in multiple Microsoft Excel worksheets

    I have multiple sheets in a Microsoft Excel workbook (it contains a ton of data). I need to select all of the cells from each sheet. Is it possible to do that? Perhaps a keyboard shortcut? Thanks very much.

    ITKE1,060,150 pointsBadges:
  • Unhide hidden Microsoft Excel worksheet

    I accidentally messed around my Excel worksheet and now it's very hidden. I don't know how to unhide it. How can I do it? Can someone help?

    ITKE1,060,150 pointsBadges:
  • How to unhide Microsoft Excel worksheet

    I was doing some work in a Microsoft Excel worksheet but, all of a sudden, the entire sheet went hidden. I'm not sure what I did. How can I unhide it?

    ITKE1,060,150 pointsBadges:
  • Transfer DBR file to Microsoft Excel

    How can I transfer a DBF file to Excel sheet no 3 and from row no. 5 of a saved Excel file?

    subhendu1234515 pointsBadges:
  • How to select and delete set number of values in Microsoft Excel

    My Microsoft Excel spreadsheet has hundreds of thousands of values in it. But roughly the first 50,000 values are out of date so I want to delete them. Is there an easier way to do this instead of clicking and dragging through all of the values? I would appreciate any help.

    ITKE1,060,150 pointsBadges:
  • Export Crystal Reports to Microsoft Excel format

    how can I export crystal report to an excel file

    Yyt5 pointsBadges:
  • Microsoft Excel is showing strange black lines through spreadsheet

    So whenever I'm opening up a new Microsoft Excel file, it keeps showing these weird black stripes and boxes. Basically lines through all of the cells. Is there a setting on that I need to turn off?

    ITKE1,060,150 pointsBadges:
  • VBA Macro to pull data from secure website to excel

    I have code to pull general data from a website into Excel using a macro, e.g. yahoo finance quotes. But, is it a possibility to pull data from a secure website (one that requires login) to automate a report? The link provided was close, but I don't understand how to pass the parameters in. Also,...

    SandeepKommineni70 pointsBadges:
  • Exporting data from SAP to Excel 2013

    I am trying to Export data from SAP to Excel 2013 and an error appears with no comment. Somebody had similar Problem posted here and the answer was changing Excel Setting but my I am not sure which exactly Excel Setting should I change. Thank for your answers in advance.

    Izabela210915 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