Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2014, 06:08 AM
sportster sportster is offline Cannot open Excel file Windows 7 32bit Cannot open Excel file Office 2010 32bit
Novice
Cannot open Excel file
 
Join Date: Sep 2014
Posts: 4
sportster is on a distinguished road
Default Cannot open Excel file

I have spent two hours working on an Excel file which was sent to me via email. I have saved the file on to a memory stick saving it as "copy of" but now when I try to open the file the following message appears "Excel cannot open the file "File name....." because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"



How do I do that or how can I access the file?

I am only a basic user of Excel files so do not understand all the technical terms etc.

Can anyone help me as I need the information on the file by tomorrow.

Thanks
Reply With Quote
  #2  
Old 09-16-2014, 07:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Cannot open Excel file Windows 7 64bit Cannot open Excel file Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,478
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

What is the file's name?
Reply With Quote
  #3  
Old 09-16-2014, 09:53 AM
sportster sportster is offline Cannot open Excel file Windows 7 32bit Cannot open Excel file Office 2010 32bit
Novice
Cannot open Excel file
 
Join Date: Sep 2014
Posts: 4
sportster is on a distinguished road
Default

The file name is just "copy of................"
Reply With Quote
  #4  
Old 09-16-2014, 10:10 PM
gmayor's Avatar
gmayor gmayor is offline Cannot open Excel file Windows 7 64bit Cannot open Excel file Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,558
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

It sounds as though the file has been corrupted.

You should never save Office files to memory sticks (or open them from there) as they are a regular source of data loss. If the available space is too small the file is corrupted or lost completely. Similarly if there is an interruption to the data or you remove the flash media before the file has been completely written, you will get file corruption. Always work from the hard drive and copy to and from flash media.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 09-17-2014, 12:25 AM
excelledsoftware excelledsoftware is offline Cannot open Excel file Windows 7 64bit Cannot open Excel file Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
excelledsoftware will become famous soon enough
Default

The other possibility is that the computer you are trying to open it with cant open it because it is not converted. This happens all the time when an office 2003 tries to open 2007 or 2013 without a converter pack. What is the file extension of the file you are trying to open and although I see on your stats that you are using office 2010 I was hoping that maybe you were trying to open it with 2003 (wishful thinking)
Reply With Quote
  #6  
Old 09-17-2014, 04:53 AM
sportster sportster is offline Cannot open Excel file Windows 7 32bit Cannot open Excel file Office 2010 32bit
Novice
Cannot open Excel file
 
Join Date: Sep 2014
Posts: 4
sportster is on a distinguished road
Default

Thanks to all who have helped/advised, I will learn from this!
Reply With Quote
  #7  
Old 09-18-2014, 01:21 AM
Peasy Peasy is offline Cannot open Excel file Windows 7 64bit Cannot open Excel file Office 2013
Novice
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default

Does the filename have the .xls or .xlsx extension on it?
Reply With Quote
  #8  
Old 09-18-2014, 02:32 AM
sportster sportster is offline Cannot open Excel file Windows 7 32bit Cannot open Excel file Office 2010 32bit
Novice
Cannot open Excel file
 
Join Date: Sep 2014
Posts: 4
sportster is on a distinguished road
Default

The file name has xlsx on it
Reply With Quote
  #9  
Old 09-18-2014, 02:54 AM
macropod's Avatar
macropod macropod is offline Cannot open Excel file Windows 7 64bit Cannot open Excel file Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,214
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Sportster,

For future reference, please give your threads titles that at least hint at what the issue is. Titles like 'Cannot open Excel file' are not particularly descriptive of the issue you're seeking help with. I've renamed the thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot open Excel file excel 2013 local file contact to shared path when i open it osama6767 Excel 3 05-28-2014 06:29 AM
Cannot open Excel file excel cannot open the file .xlsx because the file format or file extension is not val teddysika Excel 1 11-22-2012 06:06 AM
How can I add hyperlink to open a word file from an excel combo box selection? mahmoudramadan Excel 0 10-20-2012 10:41 AM
Cannot open the file in excel Shaikhu Excel 0 02-21-2012 04:49 AM
Cannot open Excel file Some Excel File Will Not Open cgoodlein Excel 5 05-19-2009 04:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft