• Convert spreadsheet into a flat file

    I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?

    Kioh4650 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,026,805 pointsBadges:
  • Hyperlinks disappeared in Microsoft Excel spreadsheet

    I have this large Microsoft Excel spreadsheet and one specific column has a list of our website (and each our hyperlinked). Our company lost power during a storm and now when I open the spreadsheet, the hyperlinks are gone (just the text appears). Why did this happen? There's way too many to add...

    ITKE1,026,805 pointsBadges:
  • Microsoft Excel 2010 window is always on top of other windows

    I'm not sure why my issue is happening so I need to turn to the experts. I've begun to notice that my Microsoft Excel 2010 is always on top of other windows. Is there a certain bug that I should be aware of? If not, any way to fix this?

    ITKE1,026,805 pointsBadges:
  • Entries are reversed in Microsoft Excel spreadsheet

    This is an interesting issue. I'm using Office 365 and whenever I start typing into an Excel spreadsheet, it's writing everything backwards. Basically I type this word 'number', it gives me 'rebmun'. I'm not sure how to stop it. Why is this happening?

    ITKE1,026,805 pointsBadges:
  • How to save Microsoft Excel worksheet as JSON file

    Hi experts, I'm looking for a way to save my Microsoft Excel worksheet as a JSON file. Does anyone have a VBA code that works? I can show how it's setup too if that helps. Thank you.

    ITKE1,026,805 pointsBadges:
  • Microsoft Excel 2013: Limit to number of worksheets

    Hello, I'm on Microsoft Excel 2013 - is there a specific limit to the number of worksheets that I can have in the BIFF8 format? I'm finding information about columns and rows but nothing about worksheets.

    ITKE1,026,805 pointsBadges:
  • Add Microsoft Excel 2016 template to entire network

    Hello, We recently got Office 2016 on our entire network (we're very excited). However, we're still on Windows 7 but plan to upgrade shortly. For the time being, I've also created an Excel template that I want our company to use. How can I do that? Any idea on the process?

    ITKE1,026,805 pointsBadges:
  • How to remove HTML tags from Microsoft Excel file

    An Excel file was recently given to me that has cells with text (which include HTML tags). This file was exported from one of our databases and those tags were included. I need to remove it. How can I remove all of the tags?

    ITKE1,026,805 pointsBadges:
  • Can not open XLS files

    I can not open previous Excel Docs. They show as XLS files and will not display any data.

    perose4125 pointsBadges:
  • Cannot add row in Excel 2010

    My Excel worksheet is formatted as a table. However, I'm trying to add a new row and I can't. It's greyed out. Columns are working fine, just rows. This is on Microsoft Excel 2010.

    ITKE1,026,805 pointsBadges:
  • Microsoft Excel: Cannot choose rows to repeat at the top

    I have a Brother printer setup on my network and I'm working with Microsoft Excel right now too. When I'm about to print a worksheet, the 'rows to repeat at the top' isn't highlighted and I cannot choose it. What should I do?

    ITKE1,026,805 pointsBadges:
  • Microsoft Excel 2016 keep freezing after cell is modified

    I'm running both Microsoft Office 2016 and Windows 10. In my department, we have a shared Microsoft Excel document that I access a ton. But whenever I try to modify a cell, Excel keeps freezing on me. This will happen for roughly two minutes and then everything is fine. Why does this keep happening?

    ITKE1,026,805 pointsBadges:
  • Turn off autorecover on Microsoft Excel workbook

    My team has one large Microsoft Excel workbook and several other smaller workbooks. There really is a large amount of data on the one workbook so that's currently read-only (but I do need to edit it at times for filtering and other things). Here's what I want to do: I want to turn autorecover off...

    ITKE1,026,805 pointsBadges:
  • How to export Access file to Excel automatically

    Our department has a Microsoft Access database file that updates all of the time. We need to export all of this data to Microsoft Excel automatically. So whenever we need the newest updates, it happens automatically (not manual process). How can we do that? Would a Power Query work?

    ITKE1,026,805 pointsBadges:
  • Add up points in Microsoft Excel

    Say in examination you have A=1,B=2,C=3,D=4,F=0. Now I need a column where I can put total points. How should I go about it?

    mnyita5 pointsBadges:
  • Cannot resize Microsoft Excel column width

    I'm trying to resize my Microsoft Excel column width with my mouse but it's not working. It was working just a couple of days ago. Did I lock some setting on Excel? I don't have any hidden columns either. What should I do here?

    ITKE1,026,805 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,...

    SandeepKommineni60 pointsBadges:
  • Delete non-English/alphanumeric characters in Excel workbook

    How can I delete non-English/characters, special characters, unnecessary spaces? I have a Microsoft Excel Workbook where I've 240 Thousand different type of  descriptions that are alphanumeric and Chinese characters. Examples: 03�� 120 10 千克≤重量<50 他猪(改良...

    EmyHazel5 pointsBadges:
  • How to set Microsoft Excel workbook name through PowerShell

    Hello, Would there happen to be a way I could set a Microsoft Excel workbook name using PowerShell? I'm not sure the best way to do this. I already have a script that opens a CSV file from Windows Explorer.

    ITKE1,026,805 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