• Create random sample of Microsoft Excel data

    I'm looking to do some random sampling on my Microsoft Excel spreadsheet. Basically, it has over a thousands rows on it and I want to sample around 100 of them randomly. Would this be possible? If so, what's the process?

    ITKE1,016,375 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE1,016,375 pointsBadges:
  • Importing Excel to Access auto populating data

    I have imported an Excel spreadsheet into Access (2016) and am trying to figure out how to populate data. For example, I imported a spreadsheet containing employee name, ID, Department, Supervisor. If I select the employee name, I want my form to automatically populate with the rest of the data....

    motogirl15 pointsBadges:
  • Update changes to Microsoft Excel file in Dropbox

    Hello, At work, I have a Microsoft Excel that I'm always updating. Would I be able to upload / update it in my Dropbox account every few hours so I don't lose any data?

    ITKE1,016,375 pointsBadges:
  • Cannot delete Microsoft Excel macro

    I have Microsoft Excel 2013 installed on my MacBook Air. I'm trying to delete a macro but I keep getting an error message: Cannot edit macro on a hidden workbook. Unhide the workbook using the unhide command. My worksheet is already unhidden so I'm not sure what to do here. Can someone help?

    ITKE1,016,375 pointsBadges:
  • How to import Microsoft Excel data into existing SQL Server table

    We have a SQL Server table that currently has data in it. Can we import more Microsoft Excel data into this existing table? We already tried using the export wizard but we got a ton of errors.

    ITKE1,016,375 pointsBadges:
  • Selecting largest number in Microsoft Excel

    Hi, in my Excel sheet, I have 1 Part procured 10 times with different prices. I have to select largest price and also I want to get the latest date when I procured. Please help me out.

    tanmay0485 pointsBadges:
  • How to estimate work hours for a typical data profiling and cleansing effort? Any Estimate calculators in Excel can be shared?

    One of my known acquaintance asked a question to help him with an estimator to logically estimate person hours required for data profiling and cleansing. His company is assuming their data quality will be bad. Now that there is a necessity to check and cleanse data, how to arrive at the man hours...

    swamis5 pointsBadges:
  • Change Microsoft Excel numbers to English

    I've noticed a very odd issue in my Microsoft Excel program. My tabs and commands are in the English language but the numbers are in a foreign language (I think it's German but I'm not sure). How can I switch it back to English?

    ITKE1,016,375 pointsBadges:
  • Why are my Microsoft Excel cells hidden?

    Hi all, I noticed that in my Microsoft Excel spreadsheet that several of the cells are hidden. I'm not sure why that happened. What's the cause of this? Thank you.

    ITKE1,016,375 pointsBadges:
  • Record last used Microsoft Excel macro

    In Microsoft Excel, is there a way for me to track when a macro was used last? Looking for the date/time. What do I need to do on my end? Thank you.

    ITKE1,016,375 pointsBadges:
  • Macro for copying data from Excel to AS/400

    Hi,I'd like to create a macro (in AS/400 or Excel VBA, doesn't matter) that copies cell data from an XLS spreadsheet to AS/400. How would I do that?E.g. copying cell A1 in Sheet1 from c:\spreadsheet.xls to 10/035...Thanks in advance.

    Hanisadeq963575 pointsBadges:
  • Merge several Microsoft Excel files into one

    I'm a beginner to Microsoft Excel so bear with me please. I'm trying to merge four different files into one file. Each one has the same column headers. Should I just copy and paste or is there a better way?

    ITKE1,016,375 pointsBadges:
  • Open Microsoft Excel 2013 file on Microsoft Office 2010

    I'm currently on my home laptop that runs Office 2010. My co-worker gave me an Excel 2013 file that I can't open. Excel 2010 is telling me that it's a corrupt file. How can I view / open this file? Thank you so much.

    ITKE1,016,375 pointsBadges:
  • Consolidate multiple Excel 2016 worksheets into one

    I'm using Microsoft Excel 2016 and my workbook contains roughly 15 sheets. I need to consolidate all the sheets into one specific sheet. Obviously, I could copy / paste but that would take way too long. All the data is in the same format. Thanks.

    ITKE1,016,375 pointsBadges:
  • Open Excel XLL file

    Hi, how can I open (to view the code) of an Excel XLL file?

    TutanoKamon5 pointsBadges:
  • Spreadsheets vs. Desktop Analytics

    Has anyone successfully migrated from MS Excel to MicroStrategy? Would love to hear your experience.

    Tareen5 pointsBadges:
  • Why is Microsoft Excel overloading my computer?

    I recently did a Windows 10 update (just a few days back). Ever since the update, my computer fan has been going crazy and I only have a couple of programs open. I looked at Task Manager and it says Microsoft Excel is running. But I closed it out. I'm not sure what to do here. Any suggestions?

    ITKE1,016,375 pointsBadges:
  • Hyperlinks in Microsoft Excel spreadsheet are not working

    I've had an Excel spreadsheet for years for my job and I have certain links in it that open in Google Chrome. But when I upgraded my Windows version, none of the links work. What should I do? I thought it was a cookie issue but that wasn't the case. Not sure what I should do.

    ITKE1,016,375 pointsBadges:
  • Create multi-level list in Microsoft Excel

    I'm not sure if there's a way to do this but I thought I ask. Can I create/implement a multi-level list in Microsoft Excel? I'm looking for something like this: 1. XXXX 1.1. XXXX 1.1.1. XXXXX 1.1.2. XXXXX 1.2. XXXX Does anyone know? Thanks.

    ITKE1,016,375 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