• Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • Linking cells in an Excel spreadsheet

    I have an Excel spreadsheet that has 350 rows with 31 columns of information and I need to print each row separately. I only need the information from 23 of the columns to be printed on each page. I created a new spreadsheet listing the 23 column names and then in the cell underneath it, I linked...

    Teicneoir220 pointsBadges:
  • Outlook 2007: Where does it store opened attachments temporarily

    One of my good friends (mistakenly) double-clicked a Microsoft Excel attachment from an Outlook email, saved it, closed Excel and the email but now we can find the email. Does anyone know where the file might be hiding? Would it be in a temporary folder? Thanks so much.

    ITKE352,380 pointsBadges:
  • How can I find an Excel formula that helps me change text?

    How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form different words? Copy and...

    Ja555you15 pointsBadges:
  • MS Access Tools References

    Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library...

    Rjwilcox45 pointsBadges:
  • Parameterized Query Syntax

    Thank you Mr Hatmaker for sharing the "Parameterized Query with excel." I have watched the videos on youtube (beyond excel) describing the function and I have a few questions.1-I am looking for the syntax for "contains". I am searching for the syntax to place in the criteria field that would return...

    YulData5 pointsBadges:
  • Have an Excel macro download data to the iSeries

    Is it possible to code an Excel macro to download a spread sheet to the IFS (on the iSeries) and then to start an iSeries job to process the downloaded data?

    aderene180 pointsBadges:
  • Wildcard Characters in Microsoft Excel

    I have a formula to search for a code and return results. The problem is that within the code there are wildcard characters. How do I make wildcard characters searchable text?

    Shultzie5 pointsBadges:
  • SSRS Excel Reports

    Hi, I have exported my SSRS report to Excel. Everything seems to be fine regarding the alignment of columns etc. However, additional row or two appears colored below the complete table of the report. Can you please help me on removing this?

    Souras5 pointsBadges:
  • MS Office Excel 2007 cannot be open by MS Office Excel 2003 (even after installing compatibility pack)

    Cannot open the EXCEL file using MS Office EXCEL 2003 (after installing the Compatibility pack) that was saved by MS Office EXCEL 2007. The error message: This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click...

    Phlim35 pointsBadges:
  • PDF format file change to Excel

    My friend got one PDF file and contain some table based data. How can we convert that file to Excel format?

    Tonycheng5 pointsBadges:
  • What formula is needed for this below in Excel?

    What Excel Formula's could I use? First # is starts with 1  back slash 2400. 2400 stays the same only first # changes. Example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST]...

    Jreifenstein001185 pointsBadges:
  • Specify the read only attribute in my Perl code so I don’t have to click on read only

    I have created a perl script that read from an excel file that is located on our windows server, the goal is to automate the perl script to run once a week and read the first 5 columns of the row that matches the current date and then write the data to a .txt file. A bash script will then open that...

    Guylevy5 pointsBadges:
  • How to repair and recover corrupt MS excel file?

    How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please help me.

    DredSelpy5 pointsBadges:
  • Damaged Excel file

    Today I cannot open several Excel files they all say cannot open the file because the file format or file extension is not valid. The files which do open all the tabs have disappeared except one which is full of garbage characters. The files that do open also say the data is delimited.

    jon77775 pointsBadges:
  • Problems using VLOOKUP

    I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a...

    Ironsprings5 pointsBadges:
  • Input to Rumba macro

    How can I vary data in a Rumba macro (Excel)?

    BSAfromMA5 pointsBadges:
  • Excel 03 opens as Read Only always

    We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks

    Littlejuanito7420 pointsBadges:
  • Is it possible to take data from Excel to IE?

    I have a list of numbers, that need inputting into IE, that then follows a process such as…Number from Excel > Copied into a box in IE and enter press > loads up a page, you then select and open the correct tab that opens in another IE window > drop downs selected > notes entered >...

    loobiedoo15 pointsBadges:
  • Problems oprning Excel File

    I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below: [Excel found unreadable content in 'filename.xls'. Do you want to...

    EB35 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following