• 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,047,345 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,047,345 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,047,345 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:
  • Export data from SAP to Excel 2013

    I upgraded from Excel 2010 to Excel 2013. When I export a report from SAP to Excel, all the number formatting is now text. What can I do to change this? Previously it would export to Excel with out that problem.

    Marinda15 pointsBadges:
  • Exporting numbers with .IQY file

    When I open an .IQY file, my numbers become a text, e.g. '=5.3. I can manually change them but will go back to a text when I refresh. How can this be corrected?

    bchristiansen5 pointsBadges:
  • Link cells of two Microsoft Excel workbooks

    I have two different Microsoft Excel workbooks that I would like to link together. Meaning - I would like to link the cell (in one workbook) to a cell in the second workbook. So when I make a change in one, the change is made in the other. Does that make sense? How can I do it?

    ITKE1,047,345 pointsBadges:
  • How to deactivate hyperlinked email address in Microsoft Excel

    When I'm working from home, I use LibreOffice. So I'm able to easily deactivate a mailto link when a particular cell contains an email address. But when I'm at work, we use Microsoft Excel and I can't find a way to deactivate it. And do I have to do this one cell at a time? Thanks so much.

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

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