• Query to update last 2 digits of a numeric field

    I have few records in a column of length 6. Now I want to update the last 2 digits of them with other number. eg:- 12360, 453560, 6760, 124560 and 6060 these are the records I have. Now I want to update only the last 2 digits '60' with 58 (no other places to be updated). Is it possible to do? Can...

    patnam85 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE1,047,950 pointsBadges:
  • Microsoft Excel: Calculate total average productive state for real-time staffing

    Hi! Can you help me with my Excel inquiry, please. I can't seem to figure out how to calculate the AHT, (+) avail,(+)acw in 30 min increments?

    garfield15 pointsBadges:
  • Script to upload to eBay without being on their site?

    Question. I'm interested to know if there's a way to write some script to upload a listing to ebay (whether from something like a CSV, Excel etc or any other format) without actually doing it through the File Exchange on the ebay site or using the standard listing procedure. Any ideas / suggestions...

    pluxmania5 pointsBadges:
  • Extract fields from PDF in bulk, using ABAP

    Hi all, We have a requirement from a client. They receive purchase orders in PDF format. Data like PO number / date. Ship to party etc has to be pulled out from the PDF and saved as an Excel file. This data will be used to post sale orders in SAP (using BAPI) My questions: Can we write an ABAP...

    MadhuKrishna5 pointsBadges:
  • Last row timestamp for Excel Online

    We're currently using Office 365 with Excel Online. For one of our workbooks, can we get the last updated timestamp for each row? Meaning when it was last updated? Or is this not possible with Excel Online?

    ITKE1,047,950 pointsBadges:
  • Microsoft Excel keeps saying that Clipboard is almost full

    A couple of weeks ago, my entire organization upgraded from Windows 7 to Windows 10. But now whenever I'm trying to copy and paste data into an Excel spreadsheet, I keep getting a message saying that there's not enough memory. And when I paste it, I get another message saying that the Clipboard is...

    ITKE1,047,950 pointsBadges:
  • Embed Microsoft Excel file into Word document

    Okay - to start. I'll give you some background. I embedded an Excel file into a Word 2007 document. Now, I closed everything out. Here's my question: When I do modifications to that spreadsheet, how can I get the changes reflected to the Word document too? Thank you.

    ITKE1,047,950 pointsBadges:
  • 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,047,950 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,047,950 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,047,950 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,047,950 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,047,950 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,047,950 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,047,950 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,047,950 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,047,950 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,047,950 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