• How to sync data between two Microsoft Excel worksheets

    In my department, I'm resonsible for keeping our Microsoft Excel worksheet up-to-date for tracking reasons. Now, a co-worker from another department wants me to fill in his Excel sheet with all of the same information. Would I be able to sync my data over to his sheet? I don't want to maintain two...

    ITKE1,052,125 pointsBadges:
  • Copy and paste Microsoft Excel tables into Gmail

    I'm sure this question has been asked before but here it goes: How can I copy and paste several tables from a Microsoft Excel spreadsheet into Gmail? I don't want to lose the original formatting and borders. Can someone help me out?

    ITKE1,052,125 pointsBadges:
  • Convert date in Microsoft Excel

    Hello, I need some date conversion help in Microsoft Excel. Here's what I currently have: dd.mm.yy I need to convert it to this: dd/mm/yyyy How can I do that?

    ITKE1,052,125 pointsBadges:
  • Remove People Graph from Microsoft Excel document

    A co-worker accidentally changed something in a very important Microsoft Excel document and this 'people graph' showed up on the entire spreadsheet. I'm able to select it but can't seem to remove it. Can someone help me?

    ITKE1,052,125 pointsBadges:
  • How to Migrate from Outlook Express to Windows Live Mail on new Computer

    I have been using Outlook Express on Windows XP operating system. Recently I have upgraded to Windows 10. In this operating system I am using Windows 10 Mail. Which is quite impressive. But Outlook Express contains some crucial email from clients. So, I want to access Outlook Express DBX Files in...

    WarriorBhagat310 pointsBadges:
  • Add options to Microsoft Excel drop down menu

    My department works with Office 365 and, with Microsoft Excel, we have several drop down menus that our entire staff can access and make changes too. And now - I need to add an extra option for our managers so there are things that they can only select. Is that possible? Is there a macro I can use?

    ITKE1,052,125 pointsBadges:
  • Microsoft Excel: How do you group a list of companies/account numbers that are duplicated on several rows

    How do you group a list of companies/account numbers that are duplicated on several rows (separate purchases) to identify companies that purchased specific products within 2 code ranges (c50-c509, c18-c20.) and include ALL of the that companies purchase rows regardless of the product code in that...

    Csimon125 pointsBadges:
  • How to use formulas in Microsoft Excel text box

    Are there any Microsoft Excel experts here? I have an idea but not sure if it's possible or not. I would like to setup a text box in my Excel spreadsheet that would display the output of a formula. I can add an example if that's needed.

    ITKE1,052,125 pointsBadges:
  • Remove character limit in Microsoft Excel column

    When I'm importing from CSV to Microsoft Excel, one of my columns has data with over 255 characters in it. But when I run the text to column command, it cuts off the data in the cells to 255 characters. How can I prevent this from happening?

    ITKE1,052,125 pointsBadges:
  • 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:
  • Can’t open an Excel file with extension XLSX

    How do I open this file that I have been using for months but now can't open? I get an error message that says "the file format or file extension is not valid". I did not consciously change the extension when I saved it.

    cwilton5 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,052,125 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,052,125 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,052,125 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,052,125 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,052,125 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,052,125 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